Course Overview
This complete Microsoft Excel course from beginner to advance is your one-stop training guide to mastering Excel 2019. Whether you’re starting fresh or want to sharpen your current skills, this course covers everything from the basics to advanced features. It’s ideal for those who want to build confidence and become more efficient using spreadsheets in their day-to-day work.
The course begins with a quick look at new features in Excel 2019, including powerful functions like IFS, TEXTJOIN, and SWITCH. Then, it takes you through three skill levels:
Beginner Level: Learn the Excel interface, enter data, create formulas, apply formatting, and print worksheets.
Intermediate Level: Explore functions, filters, charts, pivot tables, slicers, and conditional formatting.
Advanced Level: Dive into data validation, 3D references, macros, forecasting, lookup tools, goal seek, and more.
With this Microsoft Excel complete course, you will gain hands-on knowledge and real-world skills that are highly valued across many job sectors.
Learning Outcomes
- Use Excel confidently from beginner to advanced level.
- Navigate the Excel 2019 user interface with ease.
- Enter, manage, and format spreadsheet data accurately.
- Create and use formulas and functions effectively.
- Build, filter, and sort large datasets efficiently.
- Design and edit a range of chart types and visuals.
- Create and analyse PivotTables and PivotCharts.
- Apply data validation, conditional formatting, and macros.
- Forecast trends using Goal Seek, scenarios, and data tables.
- Use lookup functions and external references to streamline tasks.
Who Is This Course For
This course is for anyone who uses or wants to use Excel in their work or personal life. It suits beginners, office workers, students, job seekers, business owners, and even professionals needing a refresher. Whether you need to analyse sales, manage budgets, create reports, or improve productivity, this complete Microsoft Excel course is made for you.
Eligibility Requirements
There are no formal requirements to take this course. You just need access to a computer with Microsoft Excel installed and a desire to learn. It’s suitable for complete beginners and those looking to improve their current Excel knowledge.
Entry Requirements
- Age Requirement: Applicants must be 16 or older, making the course accessible to both young learners and adults.
- Academic Background: No prior qualifications required, open to all backgrounds.
- Language Proficiency: A good understanding of English is essential, as all lessons are in English.
- Numeracy Skills: Basic writing and numeracy skills are needed to follow the course content.
Career Path
After completing this course, you’ll be well-equipped for roles that require strong Excel skills. These include careers in data analysis, finance, administration, accounting, marketing, and project management. Excel is a top tool used by professionals across all sectors worldwide.
Course Curriculum
Microsoft Excel 2019 New Features
Beginner Level
Intermediate Level
Advanced Level
Certification
Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post.
Accreditation
All of our courses, including this Microsoft Excel Complete Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.
Course fee
R 14999
R 2000
STUDENT PAYMENT PORTAL
ENROLLMENT_FORM
Key Features of This Course
. Accredited by CPDQS
. Instant e-certificate and hard copy dispatch by next working day
. Fully online, interactive course with audio voiceover
. Self-paced learning and laptop, tablet, smartphone-friendly
. 24/7 Learning Assistance.
Next Steps:
- Download enrollment form, fill it out and send it to events@snhseminars.co.za
- Training department will send you enrollment confirmation upon receiving your signed enrollment form
- Click on the student payment portal on this course and make a payment (100% secure and safe”)
- Once the payment is made, the training department will automatically receive your POP and send you login credentials, and you can start learning after logging into the portal.
- Enjoy it and good luck!
