Master the skills and develop the knowledge you need to increase your financial awareness, while taking your Excel skills to add time-saving functions to your repertoire.
Discover the advanced features and functions of Microsoft Excel 2010, including data analysis tools, database techniques, and advanced methods for using PivotTables.
Master advanced features and functions of Microsoft Excel 2013, including analysis tools, data tables, PivotTables, and conditional formatting.
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/Office 365's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.
Learn how to build more intuitive and powerful Microsoft Access 2010 databases.
Learn how to use Microsoft Access 2013's advanced features to build more intuitive and powerful databases.
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.