Byron Employment

Byron Employment. Over 113,202 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $335.00

Course Overview

Do you need to:

  • Create different types of spreadsheets
  • Summarise large amounts of data in tables or lists
  • Analyse and problem solve using data
  • Ask What-if? questions
  • Search for data

Prerequisites

A sound knowledge of the topics covered in our Intermediate Excel – Manipulating Data or similar experience.

Delivery

Classroom

Duration

1 day

Locations

  • Public Schedule - Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney
  • Group Bookings - all States and Territories across Australia

Learning Outcomes

You should be able to:

  • Differentiate between different types of spreadsheets such as General Ledger, Database and Analysis
  • Use PivotTables to summarise large amounts of data in lists or tables to spot comparisons or trends such as monthly sales figures
  • Use the solver, goal seek and scenario manager to analyse different problem solving situations such as maximising profit margins
  • Record and edit macros to automate repetitive tasks such as formatting, sorting lists or adding subtotals
  • Assign macros to toolbar buttons and menus to make access more convenient

Course Content

Spreadsheet Modelling

  • Spreadsheet fundamentals
  • General Ledger Structure
  • Database Tables
  • Analysis Spreadsheets

Pivot Tables

  • Creating a Pivot Table
  • Editing Data in a Pivot Table
  • Adding and deleting rows, columns or Page
  • Fields
  • Formatting a Pivot Table
  • Creating a PivotTable from data in a different
  • Workbook
  • Pivot Charts

Data Tables

  • One input Data Table
  • Two Variable Data Table

Analysis Tools

  • Using Goal Seek and Solver
  • Using more than One Variable cell
  • Reports
  • Solver Options
  • Scenario Manager

Advanced Databases

  • List or database
  • Using the Data Form
  • Specifying Criteria
  • Importing data from an external Data Source
  • Using the Query Wizard
  • Updating and editing Query Results

Introduction to Visual Basic for Applications

  • Recording, running and editing macros

Assigning Procedures to Objects

  • Using the Visual Basic Toolbar
  • Assigning a macro to Worksheet and toolbar buttons
  • Adding macro commands to menus
  • Attaching custom toolbars to Workbooks
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 6162 2929
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 6162 2929 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search