![]() Trust us, test prep has NEVER been this much fun!īy the end of the course, you'll be able to apply advanced formulas and functions, design custom visuals and formats, explore data with PivotTables, automate manual tasks with macros, collaborate with other users, and much more. You'll work with real data from Airbnb, and use Excel's full arsenal of tools to analyze property details, rental rates, mortgage projections, and everything in between. ![]() ![]() Unlike other test prep materials, this is a hands-on and 100% project-based course, designed to put your skills to the test with practical demos and unique business intelligence case studies. Linking Excel workbooks, protection & encryption, comments, calculation modes, language tools, etc. ![]() Statistical charts, tree maps & sunbursts, geospatial maps, PivotTables & PivotCharts, etc. Logical operators, date/time functions, financial functions, lookups, basic macros, formula auditing tools, etc.Ĭustom formats, data validation, removing duplicates, autofill & flash fill, conditional formatting, etc. We'll start by introducing Microsoft's MO-201 Excel Expert Exam, reviewing the test structure and interface, and addressing the key topics and objective domains you'll need to master, including: This course is specifically designed to help you ace the MO-201 Excel Expert Exam and earn your official Microsoft Expert Certification for Excel 2019 or Office 365. With hands-on projects, full-length practice tests, and free downloadable study guides, this is the ONLY course you'll need to prepare for the MO-201 Excel exam, guaranteed!
0 Comments
Leave a Reply. |