You will apply visual elements and advanced formulas to a worksheet to display data
in various formats.
In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
On completion of Basics, Intermediate and Advanced Microsoft Excel delegates may also write the Microsoft Office Specialist Exam,Microsoft Excel 2013 77-420
Save up to 10% by booking and paying
10 business days before the course.
Brochure:
Information may change without notice.
Audience
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web
Pre-Requisites
Microsoft Office Excel Basic
Course Outline / Curriculum
Lesson 1: Creating Advanced Formulas
Apply Range Names
Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
Leverage Questions and Testing to Write Formulas
Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3:Organizing Worksheet Data with Tables
Create and Modify Tables
Sort and Filter Data
Use Summary and Database Functions to Calculate Data
Lesson 4: Analyzing Data with Pivot Tables, Slicers, and PivotCharts