Overview

***Exercise and demo files included***In this second installment of our Excel 2021 course series, you can expand your Excel foundation beyond what you've learned in the beginners' course and take your skills up another notch.During this course, you will create intermediate-level formulas, prepare data for analysis using PivotTables and PivotCharts, make use of WhatIf analysis tools, learn how to use validation rules to control data input, and explore the fundamentals of spreadsheet design.And we are just getting started!You will also get to discover all the new features and functions available in Excel 2021, the latest standalone version of Microsoft Excel.Explore the exciting world of dynamic array functions and learn how to use XLOOKUP, XMATCH, FILTER, and so much more.This Excel 2021 Intermediate course is designed for those with beginner-level knowledge of Excel who are looking to take advantage of the application's more advanced features. It's also suitable for individuals who have beginner to intermediate skills using an older version of Excel.The only prerequisites for this course are beginner-level knowledge of Excel and a working copy of Excel 2021.This course covers:Designing better spreadsheets and controlling user inputHow to use logical functions to make better business decisionsConstructing functional and flexible lookup formulasHow to use Excel tables to structure data and make it easy to updateExtracting unique values from a listSorting and filtering data using advanced features and new Excel formulasWorking with date and time functionsExtracting data using text functionsImporting data and cleaning it up before analysisAnalyzing data using PivotTablesRepresenting data visually with PivotChartsAdding interactions to PivotTables and PivotChartsCreating an interactive dashboard to present high-level metricsAuditing formulas and troubleshooting common Excel errorsHow to control user input with data validationUsing WhatIf analysis tools to see how changing inputs affect outcomes.This course includes:9+ hours of video tutorials84 individual video lecturesCourse and exercise files to follow alongCertificate of completion

Skills

Reviews