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.

ms-office-specialist.jpg

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

MSi is a Microsoft Certified Partner

ms-partner.jpg

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

K-12 Specific Features

Students self enroll and register using an easy to use token registration key provided to teachers. Students are automatically added to period groups.

Password reset options are emailed to teachers to allow teachers to reset a student’s password.

Grade reporting allows students and teachers to view grades.  Includes a comprehensive gradebook which allows grades that can be exported  to a CSV or Excel file.  Grades can be imported  into your district or institutions gradebook.

Classes are branded for the institution or  instructor with a custom logo.

 

Focused on the industry certification domain objectives.

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