MSi Courseware for MS Excel Expert 2019

LEARN IN APP

$79.95

Add to wishlistAdded to wishlistRemoved from wishlist 0

Category: Tag:

This course provides a hands-on experience working inside Excel, 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 and complete tasks independently.

Add your review
ms-office-expert

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 Expert demonstrates you have advanced skills needed to get the most out of Office. 

Includes

MSi is a Microsoft Certified Partner

Microsoft Certified Parner

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

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.

MSi Courseware for MS Excel Expert 2019
MSi Courseware for MS Excel Expert 2019

$79.95

MSi
Logo
Reset Password