Skip to main content

Post an event

Sign in

Disclaimer: Due to the current uncertainty regarding coronavirus, many events are being cancelled or postponed. Please contact the event organiser directly via the contact details on the listing if you are unsure.

Mangates presents

Excel Data Analysis in Finance1 Day Training in Melbourne

  • Fri 19th Mar 2021, 9:00 AM - 5:00 PM
  • Levels 31 &, 50/120 Little Collins St, Melbourne VIC 3000
  • Book Tickets
  • View Website

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



About this Event




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