Training in all Microsoft Office Applications

Our experienced instructors will put a package together that suits you.

EXCEL ADVANCED

Print Friendly
Consult With A Trainer

Pre-requisite

Duration:1 Day

Objective: To create spread sheets with complex formulas. Manipulate and analyse data.

Essential: Have Mouse Skills, an awareness of keys on keyboard e.g.: Shift, space bar, and Enter key.

Learning Outcomes: By the end of the day you will be able to create complex functions, manipulate data.

Topics

Module 1 Functions

Refresher basic IF and Absolute Cell Referencing, SUMIF, COUNTIF, Nested IF, IF Function with AND/OR/NOT ISBLANK, ISTEXT, ISERROR

Range Names

Creating A Range Name, Create A Range Name By Selection, Using Range Names in Functions, Paste List

Module 2 Complex Functions

Lookup, Refresher VLOOKUP, HLOOKUP, CHOOSE, INDEX, MATCH, IFERROR

Module 3 Clean up Functions

Using Text to Column, UPPER Case, LOWER Case, LEFT/RIGHT, TRIM, LEN, CONCATENATE, TEXT, T, SUBSTITUTE, Flash Fill, Text to Column

Module 4 Data Analysis

Goal Seek, Solver, Scenarios, Data Tables

Module 5 Workbook Tools

Data Validation Rules, Creating List, Setting Error Alerts, Circle Invalid Data, Track Changes, Create Track Changes History Report

Module 6 Working with grouping

Subtotalling Totalling by Sum, Subtotalling by Count, Grouping and Outlining

Module 7 Pivot Tables

Creating Pivot Tables, Group Data, Work with Value field settings, Create Calculated fields, Field Filters, Filter Options, Insert Slicers, Creating a Pivot Chart

Module 8 Macros

Creating Macros, Viewing Macro Code, Creating a Message box in VBA Code, Assign a Macro to a Command Button, Creating Relative/Absolute Macros, Store Macros Global/Local

EXCEL INTRODUCTION              EXCEL INTERMEDIATE

What People Say about AZ Solutions

Analir was able to tailor a program that suited the varying levels of experience in Excel for our employees.  The training was beneficial for all that attended and we were amazed at some of the more basic tips and tricks that make life easier when using Excel on a day to day basis.

Liza Jones

I found this course to be extremely educational. I would definitely recommend this to beginners of Excel users. Analir was excellent to work with and had the patience to answer all questions asked.

Jessica Holroyd

Very helpful and useful. I had an urgent need since I was starting a new role in a company and decided to undertake a beginner Excel Course to refresh my knowledge.

Thiago Costa

How Can We Help You?

Contact Us with your specific Office Software Training requirements and we will find an answer for you.

Contact Us Now!