Master Excel 2021/365 from beginner to intermediate level in this comprehensive 10-hour tutorial. Learn essential skills including basic interface navigation, working with templates, entering and editing data, using formulas and functions, formatting cells and worksheets, and applying themes and styles. Advance to more complex topics such as logical functions, lookup functions (VLOOKUP, XLOOKUP), data sorting and filtering, date and time manipulation, and data importing and cleaning techniques. Practice with downloadable exercise files to reinforce your learning and gain hands-on experience with Excel's powerful features and tools.
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
- Course Introduction
- Improve Readability with Cell Styles
- Controlling Data Input
- Adding Navigation Buttons
- Logical Functions
- The IF Function
- Nested IFs
- The IFs Function
- Conditional IFs
- Multiple Criteria
- Error Handling
- Exercise 01
- VLookup Exact Match
- VLookup Approximate Match
- HLookup
- INDEX and MATCH
- XLookup and XMatch
- OFFSET Function
- INDIRECT Function
- Exercise 02
- Sorting on Multiple Columns
- Soring Using a Custom List
- SORT and SORTBY Functions
- Advanced Filter
- UNIQUE Function
- FILTER Function
- Exercise 03
- How Date and Times are Stored
- Custom Data and Time Formats
- Time and Date Functions
- WORKDAY and WORKDAY.INTL Functions
- NETWORKDAYS and NETWORKDAYS.INTL Functions
- DATEDIF
- EDATE and EOMONTH
- Exercise 04
- Importing Data into Excel
- Removing Blank Rows, Cells and Duplicate Entries
- Changing Case and Removing Spaces
- Splitting Up Data Using Text to Columns
- Splitting Up Data Using Text Functions
- Flash Fill
- CONCAT
- Formatting Data as Table
Taught by
Simon Sez IT
