Microsoft Excel 2019

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Unlock the full potential of Microsoft Excel with our Microsoft Excel 2019 Training Course, designed to take you from a beginner to an advanced-level user. This comprehensive course equips you with the skills to master Excel’s powerful features, improving your productivity and data management expertise.

Whether you’re new to Excel or looking to refine your skills, this course covers everything you need to know, from data entry and formatting to complex formulas and data analysis tools. With a focus on practical, real-world applications, you’ll gain the confidence to use Excel in personal and professional settings.

Course Highlights

  • Excel Basics: Learn to navigate and customize the Excel interface.
  • Worksheet Management: Create, manage, and format worksheets efficiently.
  • Functions and Formulas: Master essential and advanced formulas for data analysis.
  • Data Visualization: Generate professional charts and graphs to communicate insights effectively.
  • Advanced Tools: Dive into data validation, conditional formatting, pivot tables, and macros for enhanced functionality.

 

By the end of this course, you’ll have a well-rounded understanding of Excel 2019’s capabilities, empowering you to handle complex tasks with ease.

Note: While this course prepares learners for the Excel 2019 Certification exam, the decision to pursue formal certification with an industry body lies with the participant.

The Microsoft Excel 2019 Certification exam is designed to validate your proficiency in the application. The key objectives covered by the certification include:

  • Managing worksheets and workbooks
  • Applying custom data formats and layouts
  • Creating advanced charts and tables
  • Utilizing formulas and functions for complex calculations
  • Analyzing and organizing data using PivotTables and PivotCharts
  • Automating tasks using macros and VBA

This certification is governed by Microsoft, ensuring that your skills are recognized globally.

Show More

What Will You Learn?

  • Navigating the Excel Interface: Understand the ribbon, menus, and tools to streamline your workflow.
  • Efficient Data Management: Enter, format, and organize data with ease.
  • Chart and Graph Creation: Design and customize visuals to effectively present data.
  • Mastering Functions and Formulas: Use key formulas like Autosum, COUNT, and AVERAGE to analyze data.
  • Multi-Workbook Proficiency: Work seamlessly across multiple worksheets and workbooks.
  • Data Validation and Structured References: Ensure accuracy and consistency in your data.
  • Conditional Formatting and PivotTables: Highlight key insights and analyze data dynamically.
  • Task Automation with Macros and VBA: Save time by automating repetitive tasks.

Course Content

Introduction

  • Welcome
  • Learning Outcomes
  • Microsoft Certification

Curriculum Outline

Specialist Training Platform
Description: A starter guide on accessing course content and resources, including helpful demo videos.

Your Certificate

Free Wellbeing Membership
Purchase any do skills course & receive a free do life wellbeing membership for 6 months valued at over R500!

Student Ratings & Reviews

No Review Yet
No Review Yet