Information Technology

Excel 2013 - Level 3

Instructor-Led 8 Agenda

Description

Work with advanced formulas and lookup functions. Advanced data filtering & apply advanced chart formatting. PivotTables & Charts, export/ import data and external databases. Analytical features and create scenarios. Run/record macros. Explore VBA code.

Course Overview

Course Objective

Upon successful completion of this course, students will have advanced skills in using Excel 2013.

Who Should Attend

This course is intended for students who want to further build on the acquired skills from Level 1 and Level 2 Excel 2013 classes.

Advanced functions and formulas Lesson Id 1

Advanced functions and formulas

Lookups and data tables Lesson Id 2

Lookups and data tables

Advanced data management Lesson Id 3

Advanced data management

Advanced charting Lesson Id 4

Advanced charting

PivotTables and Pivot Charts Lesson Id 5

PivotTables and Pivot Charts

Exporting and importing data Lesson Id 6

Exporting and importing data

Analytical tools Lesson Id 7

Analytical tools

Macros and Visual Basic Lesson Id 8

Macros and Visual Basic

Lesson Id	Title	Description
1	Advanced functions and formulas	Logical functions<br />Conditional functions<br />Financial functions<br />Text functions<br />Date functions<br />Array formulas
2	Lookups and data tables	Using lookup functions<br />Using MATCH and INDEX<br />Creating data tables
3	Advanced data management	Validating cell entries<br />Advanced filtering
4	Advanced charting	Chart formatting options<br />Combination charts<br />Graphical objects
5	PivotTables and Pivot Charts	Working with PivotTables<br />Rearranging PivotTables<br />Formatting PivotTables<br />PivotCharts
6	Exporting and importing data	Exporting and importing text files<br />Getting external data
7	Analytical tools	Goal Seek<br />Scenarios
8	Macros and Visual Basic	Running and recording a macro<br />Working with VBA code