Build a solid foundation in Excel 2021/365 with this comprehensive 4.5-hour tutorial. Learn the differences between Excel versions, explore the interface, and master essential features including formulas, functions, formatting, and themes. Practice with downloadable exercise files to reinforce your learning. Cover topics such as navigating the Excel environment, working with templates, entering and editing data, using basic functions, managing named ranges, applying number formats, and customizing worksheets. Gain practical skills applicable to both work and academic settings, progressing from beginner concepts to more advanced Excel techniques.
Overview
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
