![]() Import data and clean it up for analysis.Sort and filter data using advanced features and new Excel formulas.Use Excel tables to structure data and make it easy to update. ![]() Construct functional and flexible lookup formulas.Use logical functions to make better business decisions.Design better spreadsheets and control user input.In this course, students will learn how to: The only prerequisites for this course are a working copy of Excel 2021 and a beginner-level knowledge of Excel. It’s also perfect for students who have beginner to intermediate skills in an older version of Excel and are looking to explore the newest features. Students will also get to experience all the new functions and features available in Excel 2021, the latest standalone version of Excel from Microsoft.Įxplore the exciting world of dynamic array functions and learn how to use XLOOKUP, XMATCH, FILTER,and so much more.Įxcel 2021 Intermediate is designed for students who have a beginner-level knowledge of Excel and are looking to build on those skills. Students will learn how to create intermediate-level formulas, clean and analyze data using PivotTables and PivotCharts, control data input with validation rules, make decisions with WhatIf analysis tools,and learn the golden rules of spreadsheet design.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |