Intermediate Excel Course Perth
Truly the ULTIMATE Intermediate Excel Course in Perth. World Class Intermediate Excel Training that teaches students how to drive and manage spreadsheets with ease.
Intermediate Excel Course Summary
Our Excel Essentials (Intermediate Excel Course) unlocks important skills used in modern business. Students will learn to build more complex formulas as well as control conditional formats. Finally, Tables and Charts are dealt with in detail. Click here to get an full overview of our Intermediate Excel Course.
COURSE DETAILS
Click to view details about this Training Course
COURSE DATES
View our available Public & Virtual Course Training Dates
COURSE PRICING
Check out our amazing Public & Virtual Course pricing
REMOTE TRAINING
You can also attend Virtually (Remotely). Learn how it works
Intermediate Excel Course Details
Learn more about our Intermediate Excel Training and find links to booking options.
Outline: Intermediate Excel Course
You can learn more about our Excel Essentials (Intermediate Excel Course), by drilling down on the topics below.
Formula Design
- Formula Order of Operations
- SUM / AVERAGE / MAX / MIN / COUNT(A)
- Calculate Percentages
- Absolute and Relative Referencing
- Advanced Paste Options
- IF function and Nesting
Enhance & Revise Workbooks
- Named Ranges
- Cell Styles
- Move, Copy and Group worksheets
- Calculate and link across sheets & books
- 3D Formulae
- TODAY, NOW, EDATE
- Conditional Formats
- Data Validation
- Subtotals
- Format as Table
- Flash Fill
Charts and Sparklines
- Pie, Column, Bar & Line charts
- Scale & Print Charts
- Edit & Format Charts
- Create & Edit Sparklines
Overview
The knowledge gained from this course includes design, formula nesting and cross workbook calculations. What’s more, Conditional formats and Table concepts are also covered. Last but not least, this course uncovers the secrets to building Charts and Graphs.
Audience & Duration
This one day course (9am to 4pm WST) is an Intermediate Excel Course, that will suit people who are comfortable with Excel, but who want to improve their mid-level or basic Excel skills.
Course Outcome
Course attendees learn to structure sheets, build nested IF formulas and apply Conditional Formatting. Furthermore, students will learn about Excel Tables. Additionally, students will gain skills to link data and perform calculations across sheets and workbooks. By the end of this course, students should also have the skills to manage charts.
Course Attendance
There are a number of ways to attend our Excel Intermediate Course. Most commonly, Public, Virtual and Workplace Courses, as well as online Courses are the preferred delivery methods for this course.
Public and Virtual Excel Courses
We often run Intermediate Excel Courses at our venue in Perth, which can also be attended virtually (via ZOOM or Teams), from anywhere in Australia.
Workplace Intermediate Excel Training
We also offer Workplace Training for companies. This means that we can run courses at your venue, or you can come to ours. With workplace courses, we supply laptops (with no rental fees), and can also cater for virtual students at the same time.
Custom Excel Training
In addition to our Intermediate Excel Course, we also offer many other Training Courses for Excel, as well as custom Excel Training.
Online Intermediate Excel Courses
In addition to our Intermediate Excel Training in Perth, we also offer the option to attend courses via our online training portal.
Public & Virtual Dates
Here are the currently posted dates for our Intermediate Excel Training in Perth.
Virtual & Public Pricing
TRAINING UPDATES
Course Specials
We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.
We now also accept Afterpay. You can select this option when completing your course booking online.
Microsoft Excel Consulting Perth, Australia
Not only does Mobile MOUSe offer the best Excel Training in Perth. But we also offer tailored Excel support for any type of spreadsheet.
Our Perth based Microsoft Excel Support is world class, due to our years of experience and expertise.
Get Excel Support today !!!
Microsoft Excel Courses
In addition to our Intermediate Excel Course, here are our related Microsoft Excel Courses for Perth and Australia.
BASIC EXCEL TRAINING COURSE
Learn more about our Excel New Users (Basic Excel Course). Virtual Classes are also available.
INTERMEDIATE EXCEL TRAINING COURSE
More about our Intermediate Excel Training Course. Virtual Classes are also available.
ADVANCED EXCEL TRAINING COURSE
Discover our Excel Expert (Advanced Excel Course). Virtual Classes are also available.
EXCEL FORMULA WORKSHOP COURSE
Learn about our Excel Formulas Course (Advanced). Virtual Classes are also available.
EXCEL DASHBOARDS COURSE
Discover our Excel Dashboards Course (Advanced). Virtual Classes are also available.
VBA (MACROS) EXCEL COURSE
Click to learn about our Excel VBA Course (Advanced). Virtual Classes are also available.
EXCEL POWER QUERY COURSE
Info on our Excel Power Query Course (Advanced). Virtual Classes are also available.
EXCEL POWER PIVOTS COURSE
More on our Excel Power Pivot Training Course (Advanced). Virtual Classes are also available.
In Business Since
Students Trained
Avg Student Score (out of 10)
Pricing From
Intermediate Excel Course Inclusions
All Mobile MOUSe Excel Courses have the following course inclusions…
IN-HOUSE (Our Venue)
Excel Courses at our venue include…
- State of the Art Training Venue
- Face to Face Courses
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Refreshments and Snacks (Free)
- Free Parking
- Best Trainers
- Very Affordable Training
- An Amazing Training Day 🙂
ONSITE (Your Venue)
Workplace Training includes these features…
- Training Laptops (no rental fees)
- Face to Face Training
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Projection Equipment
- Cables & Power Boards
- Best Trainers
- Very Affordable Training
- An Amazing Training Day 🙂
Courses Online (Self Paced)
Online Excel Courses, also include…
- Online Portal
- Same Classroom Trainers
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Best Trainers
- Very Affordable Training
- Learn at Your Own Pace