Training in all Microsoft Office Applications

Our experienced instructors will put a package together that suits you. Click the Icons below to choose from a list of topics.

course outline microsoft excel
Excel
course outline microsoft publisher
PUBLISHER
course outline microsoft word
WORD
course outline microsoft access
ACCESS
course outline microsoft outlook
OUTLOOK
course outline microsoft PowerPoint
POWERPOINT

Visit our YouTube videos produced by Analir Pisani a Certified instructor with over 23 years experience.

Watch Now

Choose A Course Level

Deciding which course level to book into can be daunting. Think of it this way.

If Excel is completely new to you and you haven’t played with it much – you’re Intro.
Are you not sure how to start a Formula, do you get there but would struggle to get there again – you’re Intro.

If you’ve played with it and you’re stuck on Functions – you’re Intermediate.
You can do basic formatting, get around ok, but need to work across multiple sheets, summarize and return  data from other locations – you’re intermediate.

If you need to manipulate data, you import data then need to take out extra spaces, use upper case, clean up columns and you do this all the time, you may need a macro to automate your steps – you need Advanced.
If you need statistical information. You need Advanced.

If you have design recorded macros and they just don’t cut it anymore, you need to do loops. Something that can re test, “Does this sheet name exist – go check existing sheets -if no then insert new sheet and name it” – you need Excel VBA
If you want to customize your own message prompts and data validation can’t do it – you need Excel VBA
You want to create prompt boxes (input boxes) or design a form – you need Excel VBA

Consult With A Trainer

Pre-requisite

Duration:1 Day

Objective: To gain an understanding of the potential of Excel. Be able to create basic formulas apply formatting and print successfully.

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 understand what Excel is capable of. Create your own spread sheets, apply formatting, perform basic Formulas/Functions and print.

Topics

Module 1 Getting Started: Opening an Existing Spreadsheet Using Templates Understand Compatibility Mode Getting to Know the Environment Saving.

Module 2 Navigating:  Cell Pointers Navigation Techniques Selection Techniques Freezing Panes Splitting Zoom.

Module 3 Editing: Worksheets Entering Data Editing Data Undo & Re Do Deleting Data Deleting Columns & Rows Inserting Columns & rows Change Column Width.

Module 4 Automated Features:  Auto Complete Auto Fill Module 5 Formulas & Functions Basic Formulas Basic Functions:- Sum, Average, Max, Min, Count, Counta Using the Function Wizard Relative Cell Referencing Basic Absolute Cell referencing.

Module 6 Formatting:  Cells Font Formatting Conditional Formatting Formatting $ % Decimals Using Clear Format Using Clear all Using Format Painter Merge Cells, Text Wrap Apply Borders Cut, Copy, Paste Paste Special :- Keep source column width.

Module 7 Printing:  Work in Page Break Preview Insert page breaks Set headers to repeat Understand Page Setup settings Print – Selection.

Excel Intermediate               Excel Advanced

Print Friendly PDF
Consult With A Trainer

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!