This live, facilitator led MS Excel for Leaders training course is delivered to you online at your computer. You still have all the benefits of interacting with our facilitators in real time, just at your office or home desk. You can ask questions both during the training and afterwards with our free post course help desk.
Course Times
-
More and more these days, teams are required to provide accurate analysis and reports from Excel. All leaders require a sound foundation in analysis techniques and the tools to assist in interpreting of the data their team produces. This course is designed to give current and emerging team leaders a good understanding of the latest and most utilised business functions and tools in Excel by using practical business examples of the application of these features for data extraction, examination and presentation.
This is best for: Current and emerging leaders with Excel experience interested in developing techniques for better utilising the functions and features of Excel for their team.
Course Times
Course Content
Top Excel Business Functions
-
-
- COUNTIF
- SUMIF
- IFS
- FILTER
- XLOOKUP
- DATEDIF
- DATEFRAC
- TRIM
- TEXTJOIN
- SEARCH
Top Excel Business Tools
-
-
- Validation
- Conditional Formatting
- Tables
- Slicers
- Pivot Tables
Additional – Top Excel Business Tools
-
- Sparklines
- Charts
- Flash Fill
- Paste Special
On completion of the course, participants will have a good understanding of the major business Functions and features of Microsoft Excel.
Completion of Excel Introduction or equivalent knowledge is required.
