Training in all Microsoft Office Applications
Our experienced instructors will put a package together that suits you.
EXCEL ADVANCED
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, 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
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.
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.
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.