Excel 2021-365 Beginners & Intermediate Training

Overview

This Excel 2021/365 Beginners & Intermediate Training course aims to help learners go from zero to hero by covering basic to intermediate Excel skills. The course teaches Excel logical IF functions, lookup functions like VLOOKUP and XLOOKUP, data importing, formatting, and more. Students will learn how to work with templates, formulas, named ranges, formatting options, logical functions, sorting techniques, date and time functions, and data importing methods. The course includes hands-on exercises and downloadable files for practice. The intended audience for this course is beginners and intermediate Excel users looking to enhance their skills and efficiency in using Excel for various tasks.

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