Courseware for Excel expert
This course provides a hands-on experience working inside Excel Expert, that will show competency at an industry associate-level and is college and career ready. You will be able to demonstrate the correct application of the principal features of Excel Expert and complete tasks independently.
Designed to help you get certified
MSi’s courseware prepares you for the Microsoft Office Specialist Exam. The exam is a 50-minute exam that can be administered remotely by MSi or through a local testing center. Being certified as a Microsoft Office Specialist demonstrates you have the skills needed to get the most out of Office.
Includes
- 5 Chapters
- 23 Topics
- 29 Hands-on in application Practices activities
- 29 hands on in application timed quizzes
- 5 Hands on in application Projects
- Certificate of Completion
MSi is a Microsoft Certified Partner
Includes the following features
-
Learn Inside the Application!
You heard that right. Our innovative In-App Functionality allows students to learn directly within the actual program. MSi courses provide comprehensive step-by-step written and animated instructions to guide them along. What better way to learn than by doing? This is not a tedious video lecture course. Students won’t be watching along as someone else uses the software. MSi allows them to drive in the actual software. We believe this is a more engaging and effective way to learn.
-
E-textbook
Each course includes a complete e-textbook. The topics are chunked and embedded. Ideal for informing discussions or assigning homework.
-
Read-Along
Listen - a read-along feature designed to support auditory learners is available in every course. This feature is available at the top of every topic page. Simply click on the "play" icon and start listening.
-
Comprehensive Grade Book
Save valuable time by eliminating the need to create additional lessons. All MSi courses generate grades automatically from students as they complete knowledge checks, practice activities, quizzes, and projects. These grades are automatically entered into the MSi LMS (Learning Management System). You can easily import these grades into your district's grade book.
-
Assessments to Track Progress
Easily measure your students learning gains and identify any knowledge gaps. At the beginning of every chapter, there is a pre-assessment. Once students have completed the chapter there will be a post-assessment. You’ll see these scores immediately so you can proceed accordingly.
-
Focus Mode
To make it easier to concentrate, MSi offers a Focus Mode. This tool removes elements on the page that can be distracting. We’ve found this feature to be very helpful, particularly for visual learners.
-
Animated Instructions
Each course includes animated instructions allowing students to see each step of a lesson as they are working - a helpful reference tool.
-
Course Completion Badge
Share accomplishments! Upon completion of the course with a grade of 80% or higher, students are eligible for a course completion badge that is designed to be displayed on LinkedIn and other social media channels.
-
Course Completion Certificate
Showcase success! After completion of the course with a grade of 80% or higher, students are eligible for a printable course completion certificate.
Course Content
- Chapter 1: Learning Objectives
- Topic 1A: Enable, Disable and Copy Macros between workbooks
- Practice 1.1: Copy a Macro between workbooks
- Quiz 1.1: Copy a Macro between workbooks
- Topic 1B: References within Workbooks
- Practice 1.2: Create an External Reference
- Quiz 1.2: Create an External Reference
- Topic 1C: Protecting Workbooks and Worksheets
- Practice 1.3: Protect a Workbook
- Quiz 1.3: Protect a Workbook
- Topic 1D: Language Options
- Practice 1.4: Use Translate
- Quiz 1.4: Use Translate
- Topic 1E: Configure Formula Calculation Options
- Practice 1.5: Configure Calculation Options
- Quiz 1.5: Configure Calculation Options
- Project 1: Prepare Workbooks for Collaboration
- Chapter 2: Learning Objectives
- Topic 2A: Flash Fill
- Practice 2.1: Using Flash Fill
- Quiz 2.1: Using Flash Fill
- Practice 2.2: Using Fill Series
- Quiz 2.2: Using Fill Series
- Topic 2B: Data Validation
- Practice 2.3: Data Validation
- Quiz 2.3: Data Validation
- Topic 2C: Custom Number Formats
- Practice 2.4: Apply Custom Numbers
- Quiz 2.4: Apply Custom Numbers
- Topic 2D: Conditional Formatting
- Practice 2.5: Create a Custom Conditional Format
- Quiz 2.5: Create a Custom Conditional Format
- Topic 2E: Duplicate Records
- Practice 2.6: Removing Duplicate Values in a Table
- Quiz 2.6: Remove Duplicate Values in a Table
- Project 2: Data Validation
- Chapter 3: Learning Objectives
- Topic 3A: Nested Functions
- Practice 3.1: Use the IF formula
- Quiz 3.1: Use the IF formula
- Practice 3.2: Use the IFS formula
- Quiz 3.2: Use the IFS formula
- Topic 3B: The Switch Function
- Practice 3.3: Use the Switch formula
- Quiz 3.3: Use the Switch formula
- Topic 3C: SUMIF and SUMIFS Formula
- Practice 3.4: SUMIF Formula
- Quiz 3.4: SUMIF Formula
- Practice 3.5: SUMIFS Formula
- Quiz 3.5: SUMIFS Formula
- Topic 3D: AVERAGEIF and AVERAGEIFS Formula
- Practice 3.6: Using the AVERAGEIF Function
- Quiz 3.6: Using the AVERAGEIF Function
- Practice 3.7: Using the AVERAGEIFS Function
- Quiz 3.7: Using the AVERAGEIFS Function
- Topic 3E: The COUNTIF and COUNTIFS Function
- Practice 3.8: COUNTIF Formula
- Quiz 3.8: Using the COUNTIF Function
- Practice 3.9: COUNTIFS Formula
- Quiz 3.9: COUNTIFS Formula
- Project 3: Logical Formulas
- Chapter 4: Learning Objectives
- Topic 4A: Lookup References
- Practice 4.1: VLOOKUP
- Quiz 4.1: VLOOKUP
- Topic 4B: The MATCH Function
- Practice 4.2: Use the Match Function
- Quiz 4.2: Use the Match Function
- Topic 4C: Creating and editing a Macro
- Practice 4.3: Create a Macro
- Quiz 4.3: Create a Macro
- Practice 4.4: Run then Edit a Macro
- Quiz 4.4: Run then Edit a Macro
- Topic 4D: Consolidate Data
- Practice 4.5: Consolidate data
- Quiz 4.5: Consolidate data
- Project 4: Lookup Reference
- Chapter 5: Learning Objectives
- Topic 5A: Create Pivot Tables
- Practice 5.1: Create a New Pivot Table
- Quiz 5.1: Create a New Pivot Table
- Topic 5B: Insert Slicer
- Practice 5.2: Insert a Slicer
- Quiz 5.2: Insert a Slicer
- Topic 5C: Charts
- Practice 5.3: Insert a Histogram Chart
- Quiz 5.3: Insert a Histogram Chart
- Topic 5D: Pivot Charts
- Practice 5.4: Insert a Pivot Chart
- Quiz 5.4: Insert a Pivot Chart
- Project 5: Insert a Chart
Support you can depend on*
*Our exceptional customer support is always included. Fine print not needed.
At MSi, we are dedicated to your success. We want you to feel comfortable coming to us to ask questions. This is what we do for a living, and we love our job! Our helpful customer support team is based in the United States, friendly, and ready to assist. We are here to help you through the entire process. We’ll give you detailed instructions to enroll your students, set up your courses, and answer any questions you may have along the way. MSi takes pride in providing customer support you can depend on.
Knowledge Base
Quickly and easily find helpful articles that include videos.
Our searchable Knowledge Base includes an inventory of detailed instructions and other information.
Contact Us
Looking for something?
We will happily answer your questions and provide more information.
Get Support
Need help?
Open a support ticket and we will be there to help. Our team will get back to you ASAP. We look forward to assisting you.
WHAT OUR TEACHER'S SAY
MSi has it all. They can offer you everything. They offer the curriculum, They can give you everything every student needs.
Amanda Kagan
CTE Teacher