If you have used Microsoft Excel for some time and need to learn more, this Perth-based Intermediate Excel training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.

Overview

This hands-on Intermediate Excel course lays the foundations for building a stronger, more advanced understanding of Microsoft Excel and will coach you to be confident with Microsoft Excel functions commonly used in the workplace. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work interactively with functions such as IF and VLOOKUP.

To benefit from this short course, you should be a confident user of Microsoft Excel. This course 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.

If you are experienced in creating and modifying spreadsheets, and can work with basic formulas and functions, the Intermediate Excel training course will help you to build additional skills in the software.

Who Will Benefit

This course enables participants to improve their efficiency by learning ways to better analyse, organise and present data using Excel spreadsheets.

This course is particularly useful if you need to:

  • Use more complex formulas and functions
  • Use sophisticated formatting techniques in worksheets
  • Filtering, sorting, and grouping data or subsets of data
  • Work interactively with IF and VLOOKUP functions
  • Link worksheets or work with multiple worksheets
  • Present concise visual reports of complex data

Content

The Intermediate Excel course offers the following training content:

  • Use Excel time savers
  • Create advanced charts and sparklines
  • Attach comments to cells
  • Create efficient formulas with functions, relative and fixed cell references and range names
  • Troubleshoot formulas with worksheet auditing
  • Use data validation for data accuracy
  • Work with multiple worksheets
  • Create calculations across worksheets and workbooks
  • Protect cells, worksheets and workbooks
  • Create worksheet templates.

Learning Outcomes

After completion of the Intermediate Excel course participants will 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.
Course Number
933
Skill Level
Intermediate
Dates
    Make a Booking
    Duration

    2 Days

    Time
    Location

    AIM WA Floreat

    * Minimum numbers are required for course to proceed

    Similar Courses

    Excel - Advanced Macros with VBA Programming

    This course 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 introductory programming, you will benefit from this course.

    Excel - Advanced

    This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.

    Excel - Formulas and Functions

    This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

    Excel - Advanced Functions

    This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

    Excel - Power Query

    With Power Query, discover, connect to and import data into Microsoft Excel. Then, using PowerPivot, remodel and enhance the imported data by writing queries through Power Query M language.

    Excel - Essentials

    Do you need to create or modify spreadsheets using Microsoft Excel? In this course 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 course is for you.

    Microsoft - Power BI Desktop - Level 1

    Transform raw data into useable visualisations to gain more comprehensive insight into your organisation.  

    Microsoft - Power BI Desktop - Level 2

    If you have attended Power BI Desktop - Level 1, this course will build on your existing knowledge and introduce you to more advanced DAX (Data Analysis Expressions). 

    Excel - PivotTables and PivotCharts

    This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.

    Excel - Data Analytics

    Descriptive, predictive and prescriptive analytics are interrelated, helping companies make the most out of their data. Excel is a tool that can be used for analysis; to collect, clean, transform and analyse data and generate reports.

    Excel - Macros with VBA Programming

    This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.

    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.