$614.97 – $819.97

Multiple Dates

Excel Data Analysis in Finance1 Day Training in Singapore

Actions and Detail Panel

From $614.97

Event Information

Share this event

Date and Time

Location

Location

Regus Singapore

77 Robinson Rd, 34 Floor

Singapore , Maritime Southeast Asia. 68896

Singapore

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description
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

Share with friends

Location

Regus Singapore

77 Robinson Rd, 34 Floor

Singapore , Maritime Southeast Asia. 68896

Singapore

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved