Skip To Content
Microsoft Excel 2019 Level 3 Advanced 04/05/2022 - 04/07/2022 is a Course

Microsoft Excel 2019 Level 3 Advanced 04/05/2022 - 04/07/2022

Apr 5 - Apr 7, 2022

Spots remaining: 9

$185 Enroll

Full course description

Location: 
Online Learning with a Real Live Instructor
An Online virtual classroom as easy as clicking a link provided by your instructor to attend ICCE Canvas (Big Blue Button) or MS Teams.

Days: Tuesday & Thursday

Dates: 04/05/2022-04/07/2022

Time:  9:00 AM- 12:30 PM

NOTE: e-books will be provided.

Description: Microsoft Excel 2019 Level 3-Advanced is the last class of a three part series.  Attending this course involves hands-on experience using Excel spreadsheets to automate tasks with Macros and parse through data with excel analysis tools. Students will learn advanced skills, such as construct advanced formulas, data validation, troubleshooting techniques, query external databases and analytical features.  

General Topics:  Data Tables, Advanced Data Management, Exporting & Importing Data, analytical Tools, Macros & Visual Basic

Prerequisites: Be familiar with the beginner and intermediate level functions of Excel. Suggested course: Microsoft Excel 2019 Level 2-Intermediate

NOTE: This course will map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2019. Objective coverage is marked throughout the course.

Students will benefit most from this course if they want to accomplish more analytical workplace tasks in Excel 2019, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist Excel Expert exam , this course will help  students to be fully prepared for the MOS exam.

Who should attend? 

Individuals who are thinking of learning the art of data science. Take this course if you are interested in the following career path: Data Analytics, Data Management, Database Administrator. 

 

Table of Contents

Chapter 1: Logical and Lookup Functions

  • Module A: Decision-making functions
  • Module B: Lookup and reference functions

Chapter 2: Advanced Formulas

  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays

Chapter 3: Special functions

  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions

Chapter 4: Importing and Exporting

  • Module A: The Power Pivot Data Model
  • Module B: Exporting data

Chapter 5: Analysis

  • Module A: What-if analysis
  • Module B: The Analysis Toolpak

Chapter 6: Macros and Forms

  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms

Career Pathway Next Steps: Certification and/or Courses to attend at ICCE:

  • MOS Excel Certification Bundle
  • MTA Certification for Python Programming
  • Microsoft Data Analyst Associate Certification
  • Introduction to SQL

For more information Contact Liz Steacker at 813-259-6508 or email esteacker@hccfl.edu

logo.png