Excel 2016: Intermediate

Expand your basic Excel 2016 skillset by learning about intermediate features and functions that will help you work more efficiently, and effectively, with your data. In this course, you will learn how to work with text, logical and lookup functions, in addition to learning how to use range names to simplify and improve the readability of your formulas. You'll learn how to create tables and charts, as well as more advanced PivotTables and PivotCharts, to organize and analyze your data. Navigate through your worksheets and workbooks more effectively by creating links, using conditional formatting and outlining subtotals and groups. The course also covers how to work with Flash Fill and date and time functions to save time and effort. This course is the second part in a 3-part series on Excel 2016. To take your skills to the next level, watch the next course in the series, Excel 2016 Advanced. This course aligns with the CAP Body of Knowledge and should be approved for 4 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Learning objectives:

• Customize the Excel 2016 environment to your preferences
• Work with text, logical, look-up and date and time functions
• Use tables and charts to effectively analyze and organize your data
• Improve navigation by creating links and using conditional formatting
• Manipulate data using PivotTables, PivotCharts and Slicers
• Simplify and improve the readability of your formulas by using range names