Data analysis - with Excel

The advanced features and functions

• All who use Excel on a regular basis wishing to learn more about performing various kinds of analysis.
• Support staff, finance professionals and analysts wanting to increase their functional knowledge of Excel.

Quick tips to utilise the power of Excel more effectively, which will enhance your expertise in analysing large data sets, reporting tools, array formulae and CSE keystrokes, nesting functions, data manipulation and text extraction, plus scenario analysis and macro automation.

• Time savers.
• Pivot tables and charts.
• Frequency distribution tables. 
• Functions: logical; conditional, error; textual; nesting (for increased power); array.
• The CSE keystroke method: simplifying IF functions; multi-cell array functions.
• The LOOKUP family: flexible lookup methods; VLOOKUP alternatives; practical solutions for complex data sets.
• Scenario building.
• Extensive conditional formatting: data bars; using formula based rules.
• Increased automation techniques using macros: applying meaningful macro functionality; viewing and simple editing of macro VBA code.

See also

Introduction to data analysis - with Excel offers an introduction to the topic, while Excel VBA for finance professionals will extend your knowledge. 

General information

CIMA members and students should log in to their MY CIMA account in order to receive the appropriate discounts.

The course starts at 9.30am. Lunch and refreshments are included.

6 CPD hours (where applicable)

CIMA Mastercourses held in partnership with BPP 

Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.

CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more