Microsoft Excel 2016 Intermediate

Course details

Since its inception in 1985, Microsoft Excel has an average of five new users added every minute. Now the total stands at more than thirty million users of this amazing spreadsheet program, who use it every day for personal and professional reasons. The 2016 version has many new features added to the program, and if you would like to learn more about them, you can do so with this Microsoft Excel 2016 Intermediate Training course.
This course is designed to help all users get familiar with the different features of Excel. As such you start out with learning how to use range names in formulas and functions, along with using specialized functions. Next you get to analyze the data with logical and lookup functions, organise and analyze datasets and tables, and also visualize data with charts. Furthermore you will learn about creating Pivot Table, filtering data using slicers, and analyzing data using PivotCharts. Finally the course will teach you to insert graphics, and enhance workbooks through customizing them, managing themes, and creating and using templates.
Overall this course can help you rediscover Excel, and if used correctly, you will only get to add invaluable skills to your arsenal.

COURSE CURRICULUM

• Apply Range Names
• Use Specialized Functions
• Use Text Functions
• Use Logical Functions
• Use Lookup Functions
• Use Date Functions
• Use Financial Functions
• Create and Modify Tables
• Sort and Filter Data
• Use Subtotal and Database Functions to Calculate Data
• Create Charts
• Modify and Format Charts
• Create a Trendline
• Create Advanced Charts
• Create a PivotTable
• Filter Data by Using Slicers
• Analyze Data with PivotCharts
• Insert and Modify Graphic Objects
• Layer and Group Graphic Objects
• Incorporate SmartArt
• Customize Workbooks
• Manage Themes
• Create and Use Templates
• Protect Files
• Preparing a Workbook for Multiple Audiences

Updated on 17 September, 2019