Excel 2013 - Intermediate
Course Description
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
1 days
€225.00
Prerequisites
Experienced MS Excel users who have completed a foundation course or have a similar level of knowledge.COURSE OBJECTIVES
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 viewUsing 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
ExcelExcel 2013Microsoft ExcelMIcrosoft Excel 2013MS Excel