Excel Level 3

Advanced skills


Overview

What does the course cover?

This course covers the advanced tools in Excel. 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 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, Live demo’s, Downloadable exercise files and Real-world templates for you to use.


Live demo’s

Downloadable files

Real-world templates

Course detail and sample lessons

Section 1: Advanced Formatting

Lesson 1: Introduction
View Demo
Lesson 2: Orientation of text
View Demo
Lesson 3: Merge and centre options
Demo Not Available
Lesson 4: Wrap text
Demo Not Available
Lesson 5: Custom formats
Demo Not Available
Lesson 6: Find and Select Options
Demo Not Available
Lesson 7: Paste special options
Demo Not Available

Section 2: Pivot Tables and Pivot Charts

Lesson 1: Introduction
View Demo
Lesson 2: What is a Pivot table?
View Demo
Lesson 3: How to create a pivot table
Demo Not Available
Lesson 4: Working with an existing pivot table
Demo Not Available
Lesson 5: Slicer tool
Demo Not Available

Section 3: Macros

Lesson 1: Introduction
View Demo
Lesson 2: Running an existing Macro
View Demo
Lesson 3: Recording a macro
Demo Not Available
Lesson 4: Recording a macro using relative referencing
Demo Not Available
Lesson 5: Deleting a macro
Demo Not Available
Lesson 6: Assigning a macro to a command button on the Quick Access Toolbar
View Demo
Lesson 7: Applying modifications to a Macro
Demo Not Available

Section 4: Forms

Lesson 1: Introduction
View Demo
Lesson 2: The data form
Demo Not Available
Lesson 3: Inserting form controls and setting their properties
Demo Not Available

Section 5: Advanced Window Options

Lesson 1: Introduction
View Demo
Lesson 2: Arrange windows
Demo Not Available
Lesson 3: Using New window
Demo Not Available
Lesson 4: Linking workbooks
Demo Not Available
Lesson 5: Advanced Worksheet protection
Demo Not Available

Section 6: Working with Formulae

Lesson 1: Introduction
View Demo
Lesson 2: Tracing formulae
Demo Not Available
Lesson 3: Watch Window
Demo Not Available
Lesson 4: Calculate options
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 Pivot Tables 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:

Excel_Apprentice_Certificate


What’s next?

Upon completion, you can move onto you will be ready to take the Expert and Specialist 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.