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 resume. Imagine being recognized as an Excel expert in your field, driving efficiency and making data-driven decisions.

By submitting this form, I consent to the use of my contact information as described in the Terms of Use and Privacy Policy.

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.