Intermediate Excel

Excel is a very powerful and flexible tool for organising and analysing data. Excel offers an enormous number of possible functions, tools and options for use. This course will build on your basic knowledge of Excel and introduce you to working with and across multiple worksheets. Learn simple formulas like sum, count, average, min & max, and more advanced formulas like SUMIF, COUNTIF & AVERAGEIF and HLOOKUP & VLOOKUP.

Learn to use Tables to effectively aggregate data for easy analysis, Conditional Formatting to highlight and gain new insight into your data and Slicers to easily filter and interrogate your data, giving you results in seconds.
If you are familiar with Excel and would like to learn techniques that will make working with spreadsheets easier then this two-day course is for you.
Workshop Content
Reviewing the Spreadsheet
- changing the ribbon and toolbar
- using the zoom function
- freezing rows and columns
- saving the spreadsheet with custom settings

Working with Multiple Worksheets
- creating multiple sheets
- manipulating data between sheets
- calculations across sheets

Formulas
- sum, count, average, min and max formulas
- aggregations between sheets
- autofill
- day, month, year formulas
- weeknum and weekday formulas
- convert month and weekday from numbers into text
- TODAY, NETWORKDAY and WORKDAY formulas
- IF Formula

Enhance the Spreadsheet
- absolute and relative referencing
- formatting the spreadsheet
- working with templates

Working with Tables
- creating tables
- sorting and filtering tables
- aggregating and analysing data in tables
- using slicers to filter data

Conditional Formatting
- creating rules for formatting
- highlight Top 10 analysis
- creating data bars
- using colour scales, icons and sparklines

Advanced Excel Formulas
- SUMIF and SUMIFS
- COUNTIF and COUNTIFS
- AVERAGEIF and AVERAGEIFS
- HLOOKUP and VLOOKUP
Unit Standards
SAQA US ID 116940:  Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Solve a Given Problem.
NQF Level 3
6 Credits
Duration
2 days
Requirements
Basic knowledge of Excel and the principles of operating Excel. 

Your own laptop with Excel 2007, 2010 or 2013.
(If you do not have your own laptop, we can provide one for you to use for the course)  
Cost
R2 700 per person excluding VAT
Price is for training in Gauteng.
Price is for in-house training for 6 people or more.
Assessment and Moderation R500 excluding VAT per person.
Valid until 31 December 2017.

We are happy to discuss all your training needs and work with you to meet your requirements.