Excel 2013 - Intermediate

Request more details:

This course focuses on the need to produce real time reports using Charts and Pivot Tables. It introduces some techniques using functions and Named ranges that will help you be more productive
Experienced MS Excel users who have completed a foundation course or have a similar level of knowledge.
Having completed the training the attendees will be able to:
Use the new features in MS Excel 2013
Identify and create the correct chart type to communicate the message
Use a variety of functions to analyse financial data
Sort and Filter Data in predefined Tables
Use data validation to control data entry
Use the key functions of Pivot tables
New features in Excel 2013:
Flash fill, Quick Analysis & Page Layout view
Using Multiple Worksheets & Workbooks:
Working With Charts:
Creating charts
Identifying and using the correct chart for your data
Using Sparklines to produce a visual snapshot of the business
Working with Functions and Formulas:
Using Functions in Excel: PMT Function, FV Function, Vlookup, Countif, Sumif.
Working with Names and Ranges
Using names to simplify formulas
Data Validation
Advanced Formatting:
AutoFormat (Table Format)
Conditional Formatting
Pivot Tables :
Introduction to Pivot Tables
Manipulating data in the Pivot Table
Creating Pivot Charts
Using Slicers