Course Overview

Become a Microsoft Office Specialist with our Excel Associate (Office 2019) Certification training at TBC.

Whether you’re a professional seeking to improve your data management skills, an analyst needing advanced Excel proficiency, or anyone looking to stand out in today’s job market, this course is for you.

Our ‘Excel Associate’ course covers essential Excel functions, data analysis tools, and advanced features of Office 2019. You’ll gain hands-on experience and the knowledge required to pass the Microsoft Office Specialist certification exam.

Completing this course not only improves your Excel skills but also adds a valuable credential to your résumé. Imagine being recognized as an Excel expert in your field, driving efficiency and making data-driven decisions.

By clicking “Course Fee,” you confirm that you accept our Terms of Use.

Competencies

Course Breakdown

  1. Manage the worksheet environment including printing, navigating, and personalizing.

  2. Create and manipulate cell data.
  3. Format cells and apply cell styles.
  4. Manage worksheets and workbooks including formatting and grouping worksheets and manipulating window and workbook views.
  5. Apply basic and conditional formulas using order of evaluation, relative and absolute references, and named ranges.
  6. Analyze and organize data using sort, filter, and conditional formatting.
  7. Develop visual representations of data using a variety of tools such as charts, clip art, SmartArt, and WordArt.
  8. Facilitate effective sharing of worksheet data with other.

  • Navigate and manipulate data by entering, editing, and copying it within cells, and using various formulas and functions like AutoSum to perform calculations.
  • Formatting tools allow for customization of values, fonts, alignment, column widths, and the addition of colors, borders, and conditional formatting for enhanced presentation. Additionally, you can manage worksheet views, printing options, rename or remove worksheets, and check spelling for accuracy.

  • Use Excel’s Quick Analysis Tool to enter formulas, construct logical formulas with functions like IF and AND, and apply functions such as ROUND and COUNTA for statistical analysis.
  • They will also master chart creation and manipulation techniques including planning, resizing, formatting, and summarizing data trends using tools like sparklines and pie charts.

  • Acquire skills to effectively manage workbook data in Excel, including creating and formatting tables, adding, deleting, and sorting table data, using formulas, filters, and lookups within tables, and summarizing and validating table data.
  • You will also learn techniques to view and arrange worksheets, protect and save workbooks, insert hyperlinks, and group worksheet data for efficient organization and distribution.

  • Gain proficiency in planning and executing data exchange processes, including importing text files, database tables, and data from other workbooks or Access databases into Excel.
  • Additionally, they will learn to link worksheet data to external documents like Word and PowerPoint, as well as insert graphic files directly into Excel worksheets for enhanced data analysis and presentation.

  • Learn to effectively manage macros in Excel, from planning and recording to enabling, running, and editing them, as well as assigning keyboard shortcuts and buttons for efficient execution.
  • Additionally, you will explore advanced worksheet management techniques such as creating and applying templates, importing HTML data, customizing AutoFill lists, working with themes, cell comments, and encrypting workbooks for enhanced security.

  • Use Excel’s Flash Fill to separate data and text functions to format it, while also learning to perform conditional summing, value finding, and formula construction using named ranges.
  • You will then explore what-if analysis techniques, including Scenario Manager, data tables, Goal Seek, Solver, and data modeling with tools like Power Pivot, to make informed decisions and projections based on various scenarios.

Badge

Upon successful completion of a TBC Micro-Credential, you’ll be awarded an interactive Moodle badge, acknowledging your achievement in completing the course and mastering new skills and competencies. This badge serves as a dynamic representation to your success, empowering you to showcase it across various platforms, including your LinkedIn profile, résumé, emails, and more, thereby elevating your professional standing.

This badge is interactive. Clicking on it grants viewers access to your comprehensive record, ensuring the authenticity of your training and enabling them to identify the skills you’ve acquired and the course content you’ve mastered.

Available Course Dates

Class Dates Class Schedule Facilitator Number of Classes Enroll Now
September 14 –  September 28
(3 Saturdays )
9 AM – 4 PM
To Be Announced
3 Classes
(18 Hours Total)
Enroll Now
Class Dates Class Schedule Facilitator Number of Classes Enroll Now
October 05 –  October  19
(3 Saturdays )
9 AM – 4 PM
To Be Announced
3 Classes
(18 Hours Total)
Enroll Now
Class Dates Class Schedule Facilitator Number of Classes Enroll Now
November 02 –  November  16
(3 Saturdays )
9 AM – 4 PM
To Be Announced
3 Classes
(18 Hours Total)
Enroll Now
Class Dates Class Schedule Facilitator Number of Classes Enroll Now
December 07 –  December 21
(3 Saturdays )
9 AM – 4 PM
To Be Announced
3 Classes
(18 Hours Total)
Enroll Now
Class Dates Class Schedule Facilitator Number of Classes Enroll Now
January 04 –  January 18
(3 Saturdays )
9 AM – 4 PM
To Be Announced
3 Classes
(18 Hours Total)
Enroll Now
Class Dates Class Schedule Facilitator Number of Classes Enroll Now
February 01 –  February 15
(3 Saturdays )
9 AM – 4 PM
To Be Announced
3 Classes
(18 Hours Total)
Enroll Now