fbpx

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.

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

Keep In Touch

Get our weekly update on the latest and greatest news and events straight to your inbox.