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.
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.
Learn how to write powerful and flexible PL/SQL programs.
Learn how to use Crystal Reports to create attractive business documents that are easy to read and understand.
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.
This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.