This intermediate Excel training course aims to enhance your Excel skills by covering logical functions like IF, COUNTIF, and SUMIF, lookup functions such as VLOOKUP and HLOOKUP, and various other formulas like UNIQUE and CONCAT. You will also learn advanced filtering techniques, sorting methods, data manipulation, and Excel tips and tricks. The course includes downloadable exercise files for practical application. The intended audience for this course is individuals looking to deepen their Excel proficiency and leverage Excel 2021/365 features effectively.
Overview
Syllabus
- 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 Function
- INDEX and MATCH
- XLookup and XMatch
- OFFSET Function
- INDIRECT Function
- Exercise 02
- Sorting on Multiple Columns
- Sorting Using a Custom List
- SORT and SORTBY Functions
- Advanced Filter
- UNIQUE Function
- FILTER Function
- Exercise 03
- How Dates and Times are Stored
- Custom Date and Time Formats
- Time and Date Functions
- WORKDAY and WORKDAY.INT Functions
- NETWORKDAYS and NETWORKDAYS.INT Functions
- DATEDIF Function
- EDATE and EOMONTH Functions
- 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
- Using Flash Fill
- CONCAT Function
- Formatting Data as Table
Taught by
Simon Sez IT
Related Courses
-
Microsoft Excel Masterclass (2016/2019) - Basic to Advanced
-
Excel 2021-365 Beginners & Intermediate Training
-
Introduction to Data Analysis using Microsoft Excel
-
Microsoft Excel - MS Excel Formulas & Functions in just 3hrs
-
Excel Lessons - Zero to Pro for Teachers and Office Workers
-
Finding, Sorting, & Filtering Data in Microsoft Excel
