Microsoft Excel Training Courses – 1-on-1 or Your Team at Fast Track Computer Solutions.

Australia’s Original Excel Trainer, since 1982!

In the fast-paced world of business and data analysis, proficiency in Microsoft Excel is not just an advantage—it’s a necessity. At Fast Track Computer Solutions, we understand the critical role Excel plays in today’s professional landscape. That’s why, over 40 years, we have been committed to providing the most comprehensive and effective Microsoft Excel training courses available. In this article, we’ll delve into the key aspects of our courses, offering a sneak peek into the knowledge and skills you’ll gain to supercharge your Excel capabilities and advance your carreer.

Click here for our Main Excel Page

excel training courses perth

Why Microsoft Excel?

Excel’s Ubiquity in Business

Microsoft Excel is more than just a spreadsheet tool; it’s a powerful software program that empowers professionals across various industries. From finance to marketing, and from data analysis to project management, Excel serves as the backbone of countless business operations. Its versatility makes it a must-have skill for individuals and organizations alike.

Enhance Productivity

Mastering Excel unlocks the potential to streamline tasks and save valuable time. Whether it’s automating complex calculations, creating visually appealing charts, or organizing data efficiently, Excel provides the tools needed to work smarter, not harder.

Our Famous Microsoft Excel Training Courses.

1. Excel Essentials

In our Excel Essentials course, we lay the foundation for your Excel journey. You’ll learn the fundamental functions, formulas, and techniques required to create and manipulate spreadsheets with ease. From basic data entry to formatting and cell referencing, this course is perfect for beginners and those looking to reinforce their core Excel skills.

2. Advanced Excel Techniques

For those seeking to elevate their Excel proficiency, our Advanced Excel Techniques course is the ideal choice. Dive deep into advanced functions, pivot tables, and data analysis. Discover how to unleash the full potential of Excel for data visualization and decision-making.

3. Excel for Business

Excel isn’t just about numbers; it’s about making informed business decisions. Our Excel for Business course equips you with the skills to solve real-world problems. You’ll explore scenario analysis, financial modeling, and data-driven insights, empowering you to drive strategic initiatives in your organization.

What Sets Us Apart?

Expert Instructors

Our courses are led by industry experts with extensive experience in using Excel in practical settings. They’ll guide you through real-world examples and share invaluable tips and tricks to help you excel in your professional journey.

Hands-On Learning

We believe in learning by doing. Our courses are designed to be interactive, ensuring you get ample hands-on practice. You won’t just learn the theory; you’ll apply it to real Excel projects, cementing your knowledge.

Customized Training

At Fast Track Computer Solutions, we understand that one size doesn’t fit all. That’s why we offer customized training solutions to meet your specific needs. Whether you’re an individual looking to upskill or an organization seeking to train your team, we’ve got you covered.

Excel Certificate

Upon completing our courses, you’ll receive our Excel certificate. This certificate is a testament to your proficiency in Excel, giving you a competitive edge in the job market.

Conclusion

In today’s competitive landscape, mastering Microsoft Excel is a game-changer. At Fast Track Computer Solutions, we’re committed to empowering individuals and organizations with the Excel skills they need to succeed. Join our Excel training courses, and unlock a world of opportunities. Get started today and take the first step towards Excel mastery.






Don’t miss out on the chance to excel in your career. Enroll in our Microsoft Excel training courses now, and let us help you outrank the competition.





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





Excel Basic Course Outline





Fundarmentals = 6 Hours





Excel Best Practice





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





Our Intermediate to Advanced Excel 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, flashfill, 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. At the end of this class, you’ll unlock powerful techniques that will help you complete tasks more quickly, more efficiently and securely.  





Click on 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 Australia.





    

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






Testimonials:





I have recently finished my Basic Excel, Word and Outlook course with Ivor.





I needed a refresh before entering back into Administration. I learnt so much and I am really looking forward to putting everything into practice.





Ivor’s one-on-one training is amazing. I did my Excel training over 3 days, Word and Outlook over 2 days. I found this to be so much more beneficial than a one day course as I could really soak up all the information I was being taught. Ivor was great and worked at a pace I could really keep up with.





I walked away from my training each day feeling really confident with my newly learnt skills. I applied for a job while I was in training with Ivor and I was able to secure this new role. I am thrilled!!!





I could not recommend Fast Track Computer Solutions enough! I will be back to do my Advanced Excel with him in the coming Months and look at all other courses I have not done with him to keep upskilling.





Thank you so much Ivor for sharing your incredible knowledge. 
Emma Lee – Office Administrator, writes on 04/08/21: