BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Excel Tutorial - Getting Started in Microsoft Excel 2021

Simon Sez IT via YouTube

Start learning Write review

Overview

This course on Microsoft Excel 2021/365 aims to provide a solid foundation for beginners to use Excel effectively in a job or school setting. By the end of the course, learners will be able to differentiate between Excel 2021 and Excel 365, navigate the Excel interface, utilize basic formulas and functions, apply formatting options, work with templates, manage workbooks and worksheets, handle data entry and editing, understand named ranges, apply various formatting techniques, and work with rows, columns, and themes. The course employs a hands-on approach with downloadable exercise files and practical exercises to reinforce learning. The intended audience for this course includes beginners looking to enhance their Excel skills for professional or academic purposes.

Syllabus

- Introduction
- Course Intro
- Excel 2021 vs Excel 365
- Launching Excel
- The Start Screen
- Exploring the Interface
- Ribbons, Tabs and Menus
- Backstage Area
- Quick Access Toolbar
- Useful Keyboard Shortcuts
- Getting Help
- Exercise 01
- Working with Templates
- Workbooks and Worksheets
- Saving Workbooks
- Entering and Editing Data
- Navigating and Selecting Cells, Rows, and Columns
- Exercise 02
- Formulas and Functions Explained
- SUM Function
- COUNT Function
- AVERAGE Function
- MIN and MAX Function
- Handling Errors in Calculations
- Absolute vs Relative Referencing
- Autosum and Autofill Options
- Flash Fill
- Exercise 03
- What are Named Ranges
- Managing Named Ranges
- Using Named Ranges
- Exercise 04
- Applying Number Formats
- Applying Date and Time Formats
- Formatting Cells, Rows and Columns
- Format Painter
- Exercise 05
- Working with Rows and Columns
- Deleting and Clearing Cells
- Aligning Text and Numbers
- Applying Themes and Styles

Taught by

Simon Sez IT

Reviews

Start your review of Microsoft Excel Tutorial - Getting Started in Microsoft Excel 2021

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.