![]() By the time you finish this course, you will know all the possible features and function of Microsoft's powerful spreadsheet software. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. ![]() This course will help you make the most of your investment in Microsoft Excel 2019. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. You will first learn how to quickly and efficiently create fully formatted worksheets. This course focuses on the fundamentals of Excel 2019.
0 Comments
Leave a Reply. |