Excel Intermediate to Advanced Training flexible and tailored for you.

Excel Intermediate to Advanced Training Course
excel intermediate to advanced course img1

This Course Has A Prerequisite

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, sorting and filtering,  knowledge to build a useful spreadsheet.

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP and XLOOKUP, and learn techniques to expedite your workflow. Split and join text, create dropdown menus (data validation). Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. Learn how to use Use of Tables and Slicers and Co-Pilot. At the end of this class, you’ll unlock powerful techniques that will help you complete tasks more quickly, more efficiently and securely.

See our Course Outline - 6 hours in 3 x 2 hour units or 2 x 3 hour units on different days.

SUMMARIZING DATA
• Advanced Subtotals
• Formatting the Subtotal Rows
• Adding and Copying with Subtotals
• Consolidating Data
• Introducing the SUMIF Command
• Working with the SUMIF Command
• Looking at AutoSum Tricks
• Utilizing Fill Handle Tricks

WORKING WITH PIVOT TABLES

• Creating a Pivot Table
• Rearranging Fields in a Pivot Table
• Explaining the Report Layout Options
• Using the Report Filters Feature
• Using Top 10 & Date Filters
• Handling Blank Cells
• Drilling Down in the Pivot Table
• Sorting a Pivot Table
• Formatting a Pivot Table
• Creating Custom Formats
• Explaining the Grouping Options
• Adding Formulas to a Pivot Table
• Changing a Calculation in a Pivot Table
• Replicating a Pivot Table
• Counting with a Pivot Table

CHARTING IN EXCEL
• Charts Refresher
• Moving, Sizing & Copying Charts
• Formatting Charts
• Formatting a Series
• Exploring the Home & Format Ribbons
• Deciding What Chart Format to Use
• Show a Time Series with Column or Line Charts
• Using Combination Charts
• Using Line Chart Accessories
• Using Bar Charts to Show Comparisons
• Using Component Charts
• Using Correlation Charts
• Exploring Other Charts
• Chart Lies Revealed & Advanced Chart Types
• Creating a Custom Layout

GETTING VISUAL
• Using Conditional Formatting
• Using Advanced Conditional Formatting
• Highlighting, Sorting & Filtering Columns
• Using SmartArt Functions
• Using Different SmartArt Graphics

CREATING POWERFUL FORMULAS
• Auditing Formulas
• Shrinking the Formula Bar
• Understanding Errors
• Joining Text Columns
• Using Custom Formatting Codes
• Pasting Values
• Using Paste Special
• Breaking Apart Text
• Flashfill
• Converting Text to Numbers
• Using Date Functions
• Using the VLOOKUP and HLOOKUPFunction
• Using the Convert Function
• Looking at Interesting but Obscure Functions
• Using the Rand Function
• Using rounding Formulas
• Ranking & Sorting Formulas

TIPS & TRICKS

• Showing Off New Tips in Excel (Eg: Focus Cell)
• Tips for Handling Worksheets
• Best Practice
• Validating Data
• Grouping
• Multi-Sheet and Dashboard
• Modelling Eg: Costing Sheet, Budgeting, Manhour tracking and Any model that may be useful

                 Fast Track Computer Solutions in WA & Australia Wide, since 1985!

Call Ivor Now on (08) 9275-9188 or email ivor@perthsoftware.com

Click on the Orange button, top right, to book or for more info. This flexible course is 1-on-1 face-to-face, or your Group, in 2 or 3 Hour units, to suit your schedule. We can work on your spreadsheets, and conduct the training via Teams, Zoom, etc.

Your trainer, Ivor, is one of the most Senior Excel Trainers in WA and Australia Wide.

To further enhance your spreadsheet skills, explore our full range of Excel resources and tutorials here.

  • Best Practice
  • Named Ranges
  • Sorting and Filtering by colour
  • Multilevel sort
  • Cross Checks
  • Statisitical formulas – Avg, Count, Max, Min
  • Rounding, Ceiling, Floor
  • Flashfill
  • Conditional Formating
  • Data Validation
  • V and H Lookup
  • Tables
  • Pivot Tables
  • Charts and Graphs
  • Specialized Formula – Sumif, Countif, Filter, Unique, Sort
  • Introduction to Power Query
  • Introduction to Macros
  • Any special requests

📍 PROUDLY SERVING PERTH & SURROUNDING SUBURBS

  • Perth CBD
  • West Perth
  • East Perth
  • South Perth
  • Fremantle
  • Stirling
  • Osborne Park
  • Joondalup
  • Wanneroo
  • Wangara
  • Mandurah
  • Bunbury
  • Malaga
  • Welshpool
  • Henderson
  • Rockingham
  • Victoria Park
  • Cockburn
  • Belmont
  • Northbridge
  • North Perth
  • Spearwood
  • Bibra Lake
  • Subiaco
  • Forrestdale
  • Bayswater
  • Morley
  • Bassendean
  • Kalamunda
  • Armadale
  • Perth Airport
  • O’Connor
And more across Western Australia

🌍 NATIONAL & INTERNATIONAL TRAINING

Major Hubs:

  • Sydney
  • Melbourne
  • Brisbane
  • Perth
  • Adelaide
  • Darwin
  • Hobart
  • Newcastle
  • Gold Coast
  • Cairns
  • Port Hedland
  • Kalgoorlie

Serving All States & Territories:

  • WA
  • NT
  • QLD
  • NSW
  • ACT
  • VIC
  • TAS
  • SA

✈ INTERNATIONAL CONSULTING:

New Zealand & Singapore