Training in all Microsoft Office Applications

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

EXCEL INTERMEDIATE

Pre-requisite

Duration:1 Day

Objective: To become familiar with functions and working with multiple sheets.

Essential: An awareness of keys on keyboard e.g.: Shift, space bar, and Enter key. Completed Introduction or equivalent.

Learning Outcomes:

By the end of the day you will be able to understand Absolute cell references, have a greater understanding of Functions & linking sheets. You will be more confident in manipulating data.

Topics

Module 1 Cell Referencing

Absolute Cell Referencing, Mixed Absolute Cell Referencing

Module 2 Range Names

Defining a Range Name, Creating a Range Name, Using range names in Functions, Create Range Name from Selection, Paste List

Module 3 Functions

Basic IF Function, SUMIF, COUNTIF, Nested IF Functions, IF with And/Or/Not, VLOOKUP, HLOOKUP

Module 4 Arrays

Using Array instead of Absolute, Creating Arrays, Editing an array

Module 5 Working with Sheets

Create Multiple Sheets, Using Group Mode, Naming/ Deleting/Inserting Moving/Copying Sheets, Linking Sheets, External Sheet Linking, Creating 3D Formulas, Data Consolidate

Module 6 Working with Data

Sorting/Filtering, Sort/Filter by Colour, Filter by dates, Using Search filter, Create a Table, Sheet Protection, Workbook Protection

Module 7 Graphs

Creating Graphs using Insert, Creating Quick Graphs, Manipulating Graphs, Change Chart types, Change Layouts, Combinations charts, Secondary axis

EXCEL ADVANCED            EXCEL INTRODUCTION

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!