Excel 2021 Intermediate

Welcome to “Excel 2021 Intermediate,” a course designed to elevate your spreadsheet skills and empower you with advanced Excel functionalities. In this course, we’ll delve into the intricacies of spreadsheet design, enhancing readability through cell styles, and controlling data input with navigation buttons.

Master logical functions such as AND, OR, and IF, progressing to nested IFs and conditional IFs, unleashing the power of SUMIF, COUNTIF, and AVERAGEIF. You’ll explore VLOOKUP techniques, perform flexible lookups with INDEX and MATCH, and employ advanced functions like XLOOKUP and XMATCH.

Learn to manipulate and analyze data with advanced sorting, filtering, and unique value extraction using SORT, SORTBY, FILTER, and UNIQUE functions. Dive into date and time functions, calculating date differences and tabulating workdays with precision.

Uncover the secrets of importing, cleaning, and formatting data using Text to Columns, Flashfill, and CONCAT. PivotTables and PivotCharts become second nature as you create, format, and customize insightful data summaries.

As you progress, you’ll learn to assemble comprehensive dashboards, troubleshoot common errors, and harness the power of dynamic drop-down lists and data validation. Finally, this hands-on course will explore financial analysis with Goal Seek, Scenario Manager, and Data Tables.

By the end of the course, you should be able to troubleshoot, analyze, and present data effectively, making Excel 2021 an invaluable tool for your professional success. Unlock the full potential of Excel’s intermediate features and take your spreadsheet skills to new heights!

In this course, students will learn how to:

• Design better spreadsheets and control user input.
• Use logical functions to make better business decisions.
• Construct functional and flexible lookup formulas.
• Use Excel tables to structure data and make it easy to update.
• Sort and filter data using advanced features and new Excel formulas.
• Work with date and time functions.
• Extract data using text functions and unique values from a list.
• Import data and clean it up for analysis.
• Analyze data using PivotTables.
• Represent data visually with PivotCharts.
• Add interactions to PivotTables and PivotCharts.
• Create an interactive dashboard to present high-level metrics.
• Audit formulas and troubleshoot common Excel errors.
• Control user input with data validation.
• Use WhatIf analysis tools to see how changing inputs affect outcomes.

WHAT YOU GET

Certificate of Completion

• Earn a certificate each time you complete a course.
• Showcase your commitment to continuous growth and professional development.
• Impress potential employers.
• Enhance your professional profile.
• Available in PDF format to Download or Print.

INSTRUCTOR

Deborah Ashby

Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!