Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

Master Microsoft Excel & VBA: From Beginner to Expert

This comprehensive course delivers over 38 hours of in-depth training, building your skills from fundamental Excel knowledge to advanced automation with VBA. It integrates content from our popular Mach 42 Productions Excel courses (1-11) and our IT careers course, providing a complete learning path.

What You'll Learn:

• Excel Fundamentals: Start with the basics – creating worksheets, mastering copy/paste, navigating the Excel ribbon, and proper document printing.
• Data Management: Quickly sort, find, and replace data within Excel. Learn to understand, write, audit, and utilize formulas, including Excel text functions, mathematical operators, and advanced functions like VLOOKUP – all demonstrated through practical examples and case studies.
• Data Visualization: Create compelling and informative charts, progressing from beginner-friendly bar and line charts to advanced automated charts like waterfall and funnel charts. Discover expert tips for crafting visually effective Excel charts.
• Pivot Tables Mastery: Gain a thorough understanding of Excel Pivot Tables – a powerful tool for data analysis and reporting that will dramatically improve your efficiency.
• Excel Reporting & Productivity: Implement essential tips to enhance your Excel reports, such as watermarking sheets and securing your spreadsheets using Excel's built-in security features.
• Excel VBA Programming: Learn Excel VBA from the ground up! Automate repetitive tasks, streamline data cleaning, and significantly boost your productivity with VBA. The course culminates in building practical, real-world macros you can use immediately. All source code is provided, along with assignments and tasks to test your knowledge. Over 7 hours of dedicated video lectures cover Excel VBA.
• Career Advancement: Receive valuable advice on showcasing your Excel skills on your CV/Resume and further advancing your IT career.

Course Features:

• Extensive Content: Over 38 hours of video lectures and learning materials.
• Practical Application: Hands-on exercises, assignments, and real-world case studies.
• Complete Workbooks: All Excel workbooks used in the lectures are provided.
• Supportive Community: Access to a course discussion forum, lecture quizzes, and ongoing support.

Benefits of Mastering Excel:

• Increased Productivity: Automate tasks and streamline workflows.
• Time & Cost Savings: Efficiently manage data and generate reports.
• Enhanced Career Prospects: Become a more valuable asset in today's data-driven workplace.
• Confidence: Gain the skills to confidently use one of the most widely used business tools.

Note: If you are currently enrolled in any of our existing Excel courses (1-11), please consider this course carefully to avoid redundancy. This course provides a comprehensive, advanced Excel skillset.