Full course description
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: Monday & Wednesday
Time: 6:00 PM- 9:30 PM
NOTE: e-books will be provided to download from Canvas.
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
- PCAP Certification for Python Programming
- Microsoft Data Analyst Associate Certification
- Introduction to SQL
For more information Contact Liz Steacker at 813-259-6508 or email firstname.lastname@example.org