Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.
In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.
This hands-on course will teach you Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.
Master more advanced techniques for this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks.
If you use Microsoft Access, this course will help you manage databases more efficiently by advancing your skill set through hands-on lessons.
This hands-on course will teach you how to use Microsoft Access 2019 efficiently and effectively. You will learn how to manage databases and advance your understanding of this powerful software.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.