Microsoft Excel, the world's most popular spreadsheet software, is designed to help users perform a myriad of business tasks, from to-do lists to forecasts to macros and VBA.
Most office staff can use Excel to a basic level for data entry, to format cells, even to use a basic PivotTable. But few make it to the next level, to be able to build models, conduct scenario analyses, apply checks to flag errors, create a dashboard or format to a client-ready standard.
Our Microsoft Excel courses cover a range of topics, which will enhance your knowledge of Microsoft Excel features and the steps required to use these features correctly.
DCM's Advanced Excel Course
This advanced course is aimed at learners who have a good grounding in Excel either from experience or from attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in the gaps in your knowledge. This advanced Excel course focuses on the vast array of the functionality of Microsoft Excel and will allow delegates to enhance their skills.
This 1-day course offers a focused approach that looks at manipulating and analysing data. The course also goes into detail on how to normalise data and analyse it with Pivot Tables.
Learning Outcomes
By the end of the course each learner will be able to:
- Import data into Excel, prepare it and set up pivot tables to analyse it
- Record macros and create icons on the toolbars to run them
- Understand how to locate errors in formulas and evaluate them
- Use analysis tools to forecast figures based on a range of scenarios
- Ensure important data is highlighted by summarising large workbooks and sorting data into key elements
