Learn essential Excel skills with our Excel Basic Course in Perth, designed for beginners who want to build confidence and master the fundamentals. Whether you’re new to spreadsheets or need a refresher, this hands‑on course gives you the practical skills to work faster, smarter, and more accurately in Excel.
Who is this Course for?
-
Complete beginners
-
Office staff needing essential Excel skills
-
Job seekers wanting Excel proficiency
-
Administrators, coordinators, and support staff
-
Anyone who feels unsure using Excel
-
People transitioning into office‑based roles
-
Wanting to use Copilot but need a strong foundation in Excel Basics
Excel Course – What you will Learn
Basic to Intermediate = 6 Hours in 3 x 2 hour units or 2 x 3 hour units over different days.
Excel Best Practice in Perth
Getting Acquainted with Excel
1. The Excel Environment
2. The Title Bar
3. The Menu Bar
4. The Standard Toolbar
5. The Formatting Toolbar
6. The Ribbon
7. The Quick Access Toolbar
8. Scroll Bars
9. The Formula Bar
10. The Zoom Bar
11. Saving
12. Sheets
Using Ranges etc
1. Using Ranges
2. Selecting Ranges
3. Using AutoFill (Text, Numbers, Custom)
4. Sorting
5. Delete Duplicates
6. Filtering
7. Search & Replace
8. Format Painter
9. Flashfill
Inserting Images
1. Pictures
2. Online pictures
3. Shapes
4. Smart Art
Creating Formulas
1. Using Formulas
2. Formula Functions (+, -, *, /)
3. Using AutoSum
4. What is a Cross-Check
5. Average, Count Numbers, Count Text, Max, Min
6. Currency Conversion
7. Absolute Reference
8. Circular Reference
9. GST Calculations
10. Date Artithmetic
Building a “real” Spreadsheet
1. Putting all above into practice
2. Insert Comments
3. Printing
4. Protection
Co-Editing
Fast Track Computer Solutions helping 1000’s in WA since 1985! Call Ivor NOW on (08) 9275-9188.
Delivery Options
Onsite Training: You come to our office, or we come to your workplace anywhere in Perth.
One-on-One Training: Personalised coaching tailored to your exact skill level.
Online Training: Live instructor-led training via Teams, Google Meet etc.
Small Group Training: Ideal for teams wanting consistent Excel skills.