Excel - Intermediate Level

Description

Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.

Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists. The Intermediate Excel 2016 / 365 training course is ideal for those with a working knowledge of Microsoft Excel and demonstrates how to work more efficiently with workbooks and enhance the appearance of the data in the spreadsheets.

Day 1 

• Create an IF Function
• Nest AND, OR and IF Functions
• Use the PMT Function
• Use the VLOOKUP Function
• Use the HLOOKUP Function
• Create Named Cells
• Create Named Ranges
• Create drop down lists

• Sort Data
• Create a Custom Sort
• Filter Data
• Advanced Filter
• Subtotal Data
• Create a Column Chart
• Create a Pie Chart
• Modify Chart Options