Microsoft Excel Intermediate Training - Excel Tutorial Class

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Expand your Excel skills in this comprehensive 5-hour tutorial for intermediate users. Learn to utilize logical functions like IF, COUNTIF, and SUMIF, as well as lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH. Master advanced filtering techniques, custom date formats, and data manipulation tools. Explore new functions like UNIQUE, CONCAT, and XLOOKUP. Practice with downloadable exercise files to reinforce your learning. Discover how to improve spreadsheet readability, control data input, and add navigation buttons. Dive into topics such as nested IFs, error handling, sorting methods, and working with dates and times. Learn to import, clean, and format data efficiently. By the end of this tutorial, gain a solid foundation in Excel 2021/365, enhancing your ability to analyze and present data effectively.

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