Do you need to create or modify spreadsheets using Microsoft Excel? In this program you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations. If you use computers but are new to Excel or don't have much experience with Excel, then this program is for you.

Overview

This program introduces you to the most important features of Microsoft Excel. You will learn how to design, format and print spreadsheets, how to create charts and how to develop formulas and functions.

Program Content

  • Entering and editing data
  • Moving around the Excel screen
  • Copying and moving data
  • Writing and applying formulae
  • Inserting commonly used functions
    • SUM and AVERAGE
    • MAX and MIN
    • COUNT
  • Formatting the spreadsheet
  • Printing the spreadsheet
  • Creating and printing charts.

Learning Outcomes

Participants should be able to:
  • Use the most important Excel commands
  • Design and construct spreadsheets
  • Use simple functions and formulae
  • Format and print spreadsheets
  • Create and print charts.
  • Program code 940
  • Duration 1 day
    Residential:No
  • Time 9:00 AM - 4:30 PM
  • Dates
    • 26 June, 2017
    • 24 July, 2017
    • 22 August, 2017
    • 19 September, 2017
    • 23 October, 2017
    • 28 November, 2017
    • 12 December, 2017
  • Location AIM WA Floreat
* Minimum numbers are required for program to proceed
Calculate your ROI

Estimate the potential returns from your investment in an AIM WA training program.

Go Calculate

Make a Booking

Non Member
$468
Professional Member
$398
Corporate Bronze
$398
Corporate Silver
$374
Corporate Gold
$351
Waitlist only
Limited spaces
Please contact AIM WA Client Services on (08) 9383 8000 for booking information.

EOFY discounted rates have been applied.
Valid until 30 June 2017

*Prices Include GST

More Excel Programs

  • Excel KPI Dashboards

    If you need to quickly and accurately make sense of your Company's raw data, this is for you. We introduce you to Key Performance Indicators (KPIs) and dashboard design processes, and help you build an interactive KPI Dashboard. You will learn how to handle raw data, use functions to create performance metrics, and build mini charts, pivot tables and pivot charts typically used in dashboards.

     
  • Excel Macros - Making life easier with macros

    Are you looking for opportunities to work smarter and not harder? Perhaps strengthening your MS Excel skills using macros is the next step. We all use macros every day, but they are designed by people who have never seen how you operate. What if we can teach you to automate your spreadsheets so that the macros work for you? Macros can eliminate error, reduce repetition in work and generally just make life a lot easier for you.

     
  • Masterclass Excel

    These highly personalised training sessions enable you to combine your advanced skills in Excel, Word, PowerPoint or Project with the expertise of one of our Master Trainers. Together you can work on a specific task or assignment from your workpla...

     
  • Excel Intermediate

    If you have used Microsoft Excel for some time and need to learn more, this program provides you with additional skills. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work with functions such as IF and VLOOKUP. To benefit from this program you should be a confident user of Excel.

     
  • Excel Macros (VBA) Introduction

    During this introduction to Microsoft Excel Macros you learn how to create and edit macros by writing VBA code using the Visual Basic Editor. We teach you the concepts of object oriented programming, how to build user-defined Excel functions and how to use events to trigger VBA procedures. This program is for those who have used the macro recorder and want to extend their knowledge.

     
  • Excel Advanced (A)

    This advanced program shows how to work with databases in Microsoft Excel (using filtering, sorting and subtotals). It introduces pivot tables, macros and hyperlinks and teaches logical, lookup, reference and statistical functions. If you are experienced in designing and modifying spreadsheets, can write formulas and have worked with IF and VLOOKUP functions, this is for you. This program follows on from AIM WA's Excel Intermediate program.

     
  • Excel Advanced (B)

    This second advanced program in Microsoft Excel introduces data analysis and explains goal seeking, scenario manager and solver. You will work with advanced functions, learn about arrays and functions and create interactive spreadsheets using on-sheet controls. If you have experience in Excel, can write formulas and have worked with IF and VLOOKUP functions, this program is for you. It follows on from AIM WA's Excel Advanced A.

     
  • Excel Macros (VBA) Advanced

    This program is for high-end users who want to make the most of the power of Microsoft Excel. It introduces programming techniques and concepts such as variables, scoping, importing data, passing values and debug techniques. If you have experience with the macro recorder and with programming to the level of AIM WA's Excel Macros (VBA) Introduction, you will benefit from this program.

     
  • Excel Visual Tools

    This program introduces additional skills to develop your knowledge of Microsoft Excel by focusing on pivot tables, charts, SmartArt diagrams and conditional formatting.

     
Make an Enquiry