About Microsoft Excel:
Using advanced calculation features, graphing tools, pivot tables, and a macro programming language called VBA (Visual Basic for Applications). Microsoft Excel will organise your numeric or text data in spreadsheets that allow you to build context, and helps you make more informed decisions.
Which Excel are you?
1 Day
SKILLS COVERED:
- Navigate the Excel user interface
- Use Excel commands
- Create worksheet formulas
- Insert functions
- Modify fonts
- Create and use templates
- Add borders and colours to worksheets
- Preview and print a workbook
- Manage worksheets & workbooks
1 Day
SKILLS COVERED:
- Configure Excel options
- Enable Excel add-ins
- Use range names in formulas
- Use specialised functions
- Text and logical functions
- Advanced conditional formatting
- Create and modify tables
- Sort & filter data
- Create & modify charts
- Create a PivotTable
- Analyse PivotTable data
1 Day
SKILLS COVERED:
- Use 3-D references
- Collaborate on a workbook
- Protect worksheets and workbooks
- Apply data validation
- Work with forms and controls
- Use lookup functions
- Search for invalid data and formulas with errors
- Watch and evaluate formulas
- Use the goal seek feature
- Activate and use the solver tool
- Analyse data with analysis ToolPak tools
- Use advanced chart features
1 Day
SKILLS COVERED:
- Navigate the Excel user interface
- Use Excel commands
- Create worksheet formulas
- Insert functions
- Modify fonts
- Create and use templates
- Add borders and colours to worksheets
- Preview and print a workbook
- Manage worksheets & workbooks
1 Day
SKILLS COVERED:
- Configure Excel options
- Enable Excel add-ins
- Use range names in formulas
- Use specialised functions
- Text and logical functions
- Advanced conditional formatting
- Create and modify tables
- Sort & filter data
- Create & modify charts
- Create a PivotTable
- Analyse PivotTable data
1 Day
SKILLS COVERED:
- Use 3-D references
- Collaborate on a workbook
- Protect worksheets and workbooks
- Apply data validation
- Work with forms and controls
- Use lookup functions
- Search for invalid data and formulas with errors
- Watch and evaluate formulas
- Use the goal seek feature
- Activate and use the solver tool
- Analyse data with analysis ToolPak tools
- Use advanced chart features
1 Day
SKILLS COVERED:
- Navigate the Excel user interface
- Use Excel commands
- Create worksheet formulas
- Insert functions
- Modify fonts
- Create and use templates
- Add borders and colours to worksheets
- Preview and print a workbook
- Manage worksheets & workbooks
1 Day
SKILLS COVERED:
- Configure Excel options
- Enable Excel add-ins
- Use range names in formulas
- Use specialised functions
- Text and logical functions
- Advanced conditional formatting
- Create and modify tables
- Sort & filter data
- Create & modify charts
- Create a PivotTable
- Analyse PivotTable data
1 Day
SKILLS COVERED:
- Use 3-D references
- Collaborate on a workbook
- Protect worksheets and workbooks
- Apply data validation
- Work with forms and controls
- Use lookup functions
- Search for invalid data and formulas with errors
- Watch and evaluate formulas
- Use the goal seek feature
- Activate and use the solver tool
- Analyse data with analysis ToolPak tools
- Use advanced chart features
1 Day
SKILLS COVERED:
- Navigate the Excel user interface
- Use Excel commands
- Create worksheet formulas
- Insert functions
- Modify fonts
- Create and use templates
- Add borders and colours to worksheets
- Preview and print a workbook
- Manage worksheets & workbooks
1 Day
SKILLS COVERED:
- Configure Excel options
- Enable Excel add-ins
- Use range names in formulas
- Use specialised functions
- Text and logical functions
- Advanced conditional formatting
- Create and modify tables
- Sort & filter data
- Create & modify charts
- Create a PivotTable
- Analyse PivotTable data
1 Day
SKILLS COVERED:
- Use 3-D references
- Collaborate on a workbook
- Protect worksheets and workbooks
- Apply data validation
- Work with forms and controls
- Use lookup functions
- Search for invalid data and formulas with errors
- Watch and evaluate formulas
- Use the goal seek feature
- Activate and use the solver tool
- Analyse data with analysis ToolPak tools
- Use advanced chart features
Training Delivery Options:
New Horizons offers the following training modalities for Microsoft Excel courses:
- Publicly scheduled training
- Closed group training at your premises or ours
- OLLAnywhere (Virtual instructor led training)
- Seminar style learning
Accreditations:
Finding the right Excel course:
The key to achieving learning outcomes from an Excel training course is to find the right course that matches your learning requirements at that moment in time. Use our Excel pre-course assessments to find what level of training will be most suited to achieve your learning and consequently your professional goals.
Learn more …
What's included in your Excel training:
- Complimentary Excel pre-course assessments.
- Access to a Learning Solutions Advisor to discuss training requirement
- Hands-on training delivered by Microsoft Certified Trainers
- Printed courseware material in line with Microsoft Office specialisation requirements
- Access to post course online course content
- Access to a 60-day post course helpdesk support service
- 6-month free course repeat/refresher option
Top 5 reasons to choose New Horizons:
- Over the past 18 years (since June 1998), we have trained more than 50,312 Excel professionals Australia wide.
- We have been training Microsoft Excel courses since 1995 globally.
- Our Excel instructors hold the Microsoft Office Specialist (MOS) certification.
- Over 98% of our students would recommend us for training.
- We are a Microsoft Gold Certified Partner.
- We are an Australian Registered Training Organisation (RTO).
- We run over 15 Excel classes each month to provide scheduling flexibility to our customers.
- Every year we look after Excel training needs of more than 2795 business professionals working in the private and public sectors.
- Our Excel instructors are certified by Microsoft.
- We offer a variety of training delivery options to help meet your learning and business requirements (See below for details).
Meet our Excel instructors:
Stress free upgrades/rollouts:
The success of a technology upgrade/rollout goes hand-in-hand with the effectiveness of the skills development plan for the people involved. Over the past 18 years, New Horizons has helped over 1323 organisations make a smooth and successful transition to the latest version of Excel through our detailed pre-training skills gap analysis, flexible training delivery options and post course learning support. Call 1300 794 006 to learn more.
