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.
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.
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.
If you use Microsoft Excel, this intermediate course will bring your Excel skills to the next level. You will learn how to use a number of powerful features in the 2019 version of Microsoft's longstanding Excel software.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Use Microsoft Word 2019 more efficiently by mastering its more advanced features. This hands-on course will teach you how to create an index, build a list of figures, design a table of contents, perform a mail merge, and use timesaving shortcuts to develop professional documents.
Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information.