Our 1 day onsite Excel courses can be delivered at different levels to suit the needs of your staff:
- Foundation
- Intermediate
- Advanced
- Visual Basic (VBA)
Our quick and easy TNA form (Training Needs Analysis) will help you to choose the correct level. If you have a number of staff with different levels of experience, we may be able to tailor a course to suit. Please note that this will by necessity mean that we will have to progress at the pace of the learner with the least knowledge. However, it does allow a number of staff to be trained simultaneously, thereby helping to keep the total cost down. If you would like us to send you a free Training Needs Analysis form, please either telephone or request this on our Contact page.
Here is an overview of our Excel course levels:
Foundation Excel
- Introduction to spreadsheets
- Overview of Excel menus and toolbars
- Entering and editing data & text
- Adjusting column & rows
- Inserting and deleting columns & rows
- Selecting & formatting data
- Copy and pasting data & text
- Using Auto sum for quick calculations
- How to build formulas to perform calculations
- Introduction to Excel functions
- Printing Excel spreadsheets
Intermediate Excel
- Excel overview refresher
- Understanding absolute cell addresses
- Linking data between workbooks
- Using advanced formulas & functions
- Highlighting values with conditional formatting
- Understanding Conditional Logic: Using IF statements
- Finding records using VLookup & HLookup functions
- Creating subtotals & working with levels
- Sorting data using advanced filters
- Sorting data using pivot tables and charts
- Creating and using macros
- Protecting workbooks, worksheets & individual cells
- Consolidating data in multiple worksheets & workbooks
- Data validation: creating drop-down lists
- Embedding spreadsheets in Word & PowerPoint documents
- Using charts and graphs to display data
Advanced Excel
- Advanced Conditional Logic: nested IF, AND, OR & NOT functions
- The Maths Functions: using SUMIF, COUNTIF & AVERAGEIF
- New Excel 2007 Functions: using SUMIFS, COUNTIFS & AVERAGEIFS
- Working with Data: the TRIM, FIND, MID & VALUE functions
- Finding Data Records: using the MATCH & INDEX functions
- Advanced Database Functions: the DSUM, DAVERAGE & DCOUNT functions
- Analytical Tools: using Goal Seek & Scenarios
