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 day
€225.00
16 Aug, 19 Oct, 12 Dec
21 Jul, 05 Sep, 16 Nov

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 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

ExcelExcel 2013Microsoft ExcelMIcrosoft Excel 2013MS Excel