Excel Intermediate   (933)

Using Functions and More Advanced Spreadsheets

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.

Overview

This program provides you with further skills in Microsoft Excel. You will learn how to identify ranges with names, protect worksheets and files, apply functions, link worksheets, audit files and create templates.

Program Content

  • Review of basic worksheet development and charting
  • Relative and absolute cell referencing
  • Apply range names
  • Functions
    • If functions
    • VLookup
  • Cell comments or notes
  • Worksheet auditing and protection
  • Linking worksheets and workbooks
    • Copying and pasting formulae and data between worksheets
    • Formatting worksheets simultaneously
    • Linking information in different files
  • Creating templates
  • Basic sorting and filtering
  • Data validation
  • Conditional formatting.

Learning Outcomes

Participants should be able to:

  • Develop worksheets using specialised features and commands
  • Trace cells using worksheet auditing
  • Develop and modify multiple sheets
  • Link data from different files
  • Lock cells and protect an entire workbook
  • Create worksheet templates.
  • Program code 933
  • Duration 2 days
    Residential:No
  • Time 9:00 AM - 4:30 PM
  • Dates
    • 23 - 24 February, 2017
    • 29 - 30 March, 2017
    • 10 - 11 April, 2017
    • 27 - 28 April, 2017
    • 10 - 11 May, 2017
    • 25 - 26 May, 2017
    • 08 - 09 June, 2017
    • 27 - 28 June, 2017
    • 11 - 12 July, 2017
    • 25 - 26 July, 2017
    • 09 - 10 August, 2017
    • 23 - 24 August, 2017
    • 07 - 08 September, 2017
    • 20 - 21 September, 2017
    • 02 - 03 October, 2017
    • 26 - 27 October, 2017
    • 06 - 07 November, 2017
    • 20 - 21 November, 2017
    • 11 - 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
$995
Professional Member
$846
Corporate Bronze
$846
Corporate Silver
$796
Corporate Gold
$746
Waitlist only
Limited spaces
Please contact AIM WA Client Services on (08) 9383 8000 for booking information.

*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.

     
  • 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 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 Essentials

    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.

     
  • 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