Excel for Business – Data Handling and Analytics

by Australian Institute of Management Claim Listing

Everyday Excel is used extensively by businesses of all sizes to analyse data. Increasingly, individuals in many different roles are understanding the benefits of using data to organise and manipulate data to enable better decision-making.

$925

Contact the Institutes

Fill this form

Advertisement

Australian Institute of Management Logo

img Duration

1 Day

Course Details

Everyday Excel is used extensively by businesses of all sizes to analyse data. Increasingly, individuals in many different roles are understanding the benefits of using data to organise and manipulate data to enable better decision-making.

This one-day course builds on basic spreadsheeting skills that you have acquired in your workplace and helps you learn how to create a systematic and efficient approach to working with data in Excel.

You will learn how to prepare, name, sort, group, subtotal, filter, de-duplicate, chart, and analyse data for decision-making. Then you will apply your learning to real data from your workplace.

 

Is This Course Right For You?

This course is designed for those who have a functional knowledge of Excel, and may use Excel regularly but at a superficial level who understand the power of data to help decision making and want to enhance their skills.

 

Learning Outcomes

Upon completion of this course, you will be able to:

  • Navigate in Excel – Use shortcuts to move around in Excel quickly

  • Prepare and Sort data – Use Power Query to clean and transform data and tables

  • Name data ranges – Use named ranges to simplify formulas and referencing

  • Create list subtotals – Both single level and multi-level, learn to group and outline data

  • Filter data – By column and specific conditions, create lists; Use slicers and pivot charts

  • De-duplicate data – Identify and remove duplicates

  • Analyse data – Use Pivot tables, forecasting, Goal Seek, Solver, sensitivity analysis and scenario analysis

 

Delivery Mode

On-Campus Workshop – 1 day face-to-face workshops

Our Excel for Business – Data Handling and Analytics course is set in interactive classrooms at one of our five campuses across Australia: Sydney, Melbourne, Brisbane, Caberra, and Adelaide.

The benefits of studying in a classroom setting include being able to share first-hand experiences, ideas and questions with peers and our expert facilitators. You’ll study alongside like-minded people and strengthen your network.

 

Additional Information

Requirements

Students must bring their own:

  • PC or Mac

  • A working version of Excel (2016 or later). If your version of excel doesn’t have a feature, you can use the free web-version of Excel Online

  • Access to a personal or workplace Microsoft account (an email address and password that you use with Outlook.com, Hotmail, Office, OneDrive, Skype, Xbox, and Windows)

 

Pre-work

  • Explore the 6 provided EFB-DHA practice file (in myAIM) before attending the course

  • Bring real workplace examples to implement what you have learnt

 

What's Included?

  • Comprehensive course notes

  • Morning tea, lunch and afternoon tea

  • Internet Access

  • Adelaide Branch

    Level 6/76 Waymouth St, Adelaide

Check out more MS Excel courses in Australia

AMC Training Centre Logo

Microsoft Visio

Visualise, explore and effectively communicate through the use of diagrams, flow charts and drawings and create ‘real’ representation of your complex data that someone other then you can understand.

by AMC Training Centre [Claim Listing ]
Wall to Wall Computer Logo

Microsoft Word 2016 Essentials

Microsoft Word 2016 Essentials Training Courses are offered by Wall to Wall Computer.

by Wall to Wall Computer [Claim Listing ]
Corporate Training Solutions Australia Logo

Access Essentials

This practical hands-on course will enable you to understand the main concepts of databases and help you develop a database application. Training available on Microsoft Access 365, 2019, 2016 and 2013.  Select your version when making a booking.

by Corporate Training Solutions Australia [Claim Listing ]
Melbourne International Graduate College Logo

MOS Excel

By enrolling in this course, students would be able to expand their computer knowledge of Excel to produce effective excel workbooks with the accurate formula building techniques, formats and designs, protect worksheets, operate advanced data calculations and storing design PivotTables.

by Melbourne International Graduate College [Claim Listing ]
  • Price
  • Start Date
  • Duration
Wizard Logo

Microsoft Access Course

Discover how to manage data and information with easy. Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.

by Wizard [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy