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: CAD 649.00
Regular Price: CAD 799.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: CAD 549.00
Regular Price: CAD 699.00
Private Group / In-House Learning:
Have a group of 5 or more people?
Register yourself with a special pricing and
request the training exclusively
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.