Course Overview:

Features, functions and techniques for analysing & visualising large data sets using Excel.

Target Audience:

● All staff who analyse large data sets or databases

● Business/Finance Analysts

● Internal/External/IS Auditors

● Systems Accountants

● Finance/Accounting staff

Learning Objectives:

● 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.

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

There is no exam for this course.

Technical Requirements:

For eBooks:

● Internet for downloading the eBook

● Laptop, tablet, Smartphone, eReader (No Kindle)

● Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

● eBook download and activation instructions

Agenda:

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