Excel 2016 – Level 3

Advanced skills


Overview

What does the course cover?

This course covers the advanced tools in Excel 2016. You’ll learn how to create custom cell formats. You’ll start to learn about Pivot Tables, the slicer tool, Macros and how to record steps to common tasks. You’ll learn how to trace and watch changes with cells and formulae.

Aims

Why take this course?

This course introduces the power of Pivot Tables and Recording Macros. Pivot tables let us report and manipulate huge amounts of data quickly and easily. Learning the foundations of Macros can save you huge amounts of time by automating repetitive tasks.

Audience

Who should attend?

Anyone who has completed the Excel 2016 Level 2 course and is looking for more knowledge on Excel – in particular anyone looking to learn the foundations of working with Pivot Tables and basic Macros. If you work with Excel extensively, this course will benefit you.


Course preview

Each course contains high quality, professional video lessons, downloadable exercise files and real-world templates for you to use.

Excel 2016 Level 3 - Intro
Simple interface
Excel 2016 Level 3 - Demo
Video lessons
Excel 2016 Level 3 - Download
Downloadable files

Course detail and sample lessons

Section 1: Lookup Functions

Lesson 1: VLookup Same Sheet
View Demo
Lesson 2: VLookup involving 2 Sheets
View Demo
Lesson 3: VLookup involving 2 Workbooks
Demo Not Available
Lesson 4: VLookup with closest match option
Demo Not Available
Lesson 5: HLookup
Demo Not Available
Lesson 6: Comparing 2 Columns
Demo Not Available

Section 2: More Functions

Lesson 1: Quick Analysis Tool
View Demo
Lesson 2: Countif & Sumif
View Demo
Lesson 3: Sumifs & Countifs
Demo Not Available
Lesson 4: Date Functions
Demo Not Available
Lesson 5: Database Functions
Demo Not Available
Lesson 6: Text Functions
Demo Not Available
Lesson 7: Indirect Function
Demo Not Available
Lesson 8: 3D References
Demo Not Available

Section 3: Sparklines

Lesson 1: Insert a Sparkline
View Demo
Lesson 2: Edit a Sparkline
Demo Not Available
Lesson 3: Group and Ungroup Sparklines
Demo Not Available
Lesson 4: Sparkline Axis Options
Demo Not Available
Lesson 5: Delete a Sparkline
Demo Not Available

Section 4: Macros

Lesson 1: Record a Macro
View Demo
Lesson 2: Run a Macro
Demo Not Available
Lesson 3: Assign Macro to an icon
Demo Not Available
Lesson 4: Absolute Vs Relative Macros
Demo Not Available
Lesson 5: Deleting a Macro
Demo Not Available
Lesson 6: More on Macros
Demo Not Available

Section 5: Protecting Your Workbook

Lesson 1: Protect Sheet
View Demo
Lesson 2: Protect Workbook
Demo Not Available
Lesson 3: Share Workbook
Demo Not Available
Lesson 4: Track Changes
Demo Not Available
Lesson 5: Comments
Demo Not Available

Section 6: Charts

Lesson 1: Insert & Delete a Chart
View Demo
Lesson 2: Move & Resize a Chart
Demo Not Available
Lesson 3: Different Types of Charts
Demo Not Available
Lesson 4: New Chart Types in Excel 2016
Demo Not Available
Lesson 5: Quick Layouts
Demo Not Available
Lesson 6: Add a Chart Element
Demo Not Available
Lesson 7: Chart Styles
Demo Not Available
Lesson 8: Selecting Multiple Ranges to Chart
Demo Not Available


Skills you’ll learn

What you’ll be able to do after the course

  • Advanced formatting for text and cells
  • Update changes across a workbook
  • Work with Sparklines and Charts
  • Learn how to record and run a macro
  • How to link worksheets and workbooks
  • Trace and track errors in a spreadsheet
  • Add custom controls to a worksheet

How you can apply these skills

What you’ll be able to use these skills for

  • Automate some repetitive tasks in Excel
  • Drill down and report on large data
  • Perform what-if? type analysis on data
  • Design easy to use Excel forms
  • Track how large spreadsheets work and trace errors
  • Use Excel Forms for data entry
  • Work with multiple spreadsheets at the same time

Certification

When you pass that you will receive an internationally recognised accreditation certificate like this:

IACT_Specialist


What’s next?

Upon completion of Excel courses up to this level you will be ready to take the Expert courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.


Careers that require these skills at this level?

Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.


Want to start learning today?

Joining is simple, easy and risk free with our 7 day money back guarantee.