Features, functions and techniques for analysing & visualising large data sets using Excel.
Duration Learning Credits
1 Day – 8 hours of 8 PDU’s
Session
Public Classroom Pricing:
Early Bird Price: USD 595.00
Regular Price: USD 795.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: USD 495.00
Regular Price: USD 695.00
Private Group / In-House Learning:
Have a group of 3 or more people? Register
yourself with a special pricing and request
the training exclusively for your group.
Hot Selling Course
Analysing Data Held in Excel
● Importing data files
● Useful functions: splitting cells, combining cells, linking multiple tables of data together
● Error checking and error handling
● Autofilter
● Advanced Filters
● Sorting
Excel’s Analysis Tools
● Group & Outline
● Conditional Formatting
● Charting Techniques
● Pivot Tables
● Pivot Charts
Analysing External Data
● Database Fundamentals
● Connecting to databases
● Using Microsoft Query
● OLAP Cube Fundamentals
● Analysing OLAP Cube data
● All staff who analyse large data sets or databases
● Business/Finance Analysts
● Internal/External/IS Auditors
● Systems Accountants
● Finance/Accounting staff
● A sound working knowledge of a range of tools and techniques you can use to visualise and analyse data quickly and efficiently.
● Enhanced skills and knowledge of presentation techniques using the latest Excel functions and features.