New!

Learn-by-Doing: Microsoft 365 Series (Level 2)

A Visual Approach to Learning Advanced Microsoft Word and Excel Skills

   
video Watch Textbook Video Overview
   
  • Level 1: 100% Aligned to the MOS Expert Certification Exams
  • Individual Level 2 titles available for purchase: Word | Excel
  • Click here for Learn-by-Doing: Microsoft 365 Series (Level 1)
  • This title is included in our eReadiness.com Bundle Subscription.
   
Description

The Learn-by-Doing: Microsoft 365 Series (Level 2) uses a graphical, screenshot-based approach to support students in mastering the advanced tools and features of Microsoft 365, including Word and Excel. Students already familiar with the basics of Word and Excel will explore advanced skills—such as creating custom design elements, using macros, and working with PivotTables—in an illustrated, step-by-step format, helping them gain valuable workplace skills and master these essential business applications.

 

These textbooks have been 100% aligned to the skills assessed in Microsoft Office Specialist (MOS) Expert Certification Exams and are endorsed by Certiport, the leading provider of certification exams. An important industry-leading certification, MOS offers students a resume booster in addition to valuable skills for success in both careers and the classroom. Even if certification isn't the goal, Learn-by-Doing: Microsoft 365 (Level 2) will prepare your students for success in the modern world.

 

For Learn-by-Doing: Microsoft 365 Series (Level 1) click here.


Watch Video Overview

Features
  • Series includes Word and Excel
  • Certification prep for Microsoft Office Specialist Expert Exams
  • Over 75 hands-on lessons covering advanced Microsoft 365 skills
  • Skills Mastery Assessments measure students' ability to demonstrate the skills introduced in each section
Table of Contents

Learn-by-Doing: Microsoft 365 - Word (Level 2)

Unit 1 Managing Documents and Templates

Lesson 1.1 Customizing Common Tools

Lesson 1.2 Managing Version History

Lesson 1.3 Combining and Comparing Document Changes

Lesson 1.4 Linking to Other Documents

Lesson 1.5 Working with Template Files

Lesson 1.6 Restrict Document Editing

Lesson 1.7 Managing Language Settings

Lesson 1.8 Translating Text

Unit 2 Using Advanced Editing and Formatting Features

Lesson 2.1 Using Advanced Search Queries

Lesson 2.2 Using Paste Options

Lesson 2.3 Controlling Line Numbering

Lesson 2.4 Applying Hyphenation

Lesson 2.5 Setting Paragraph Pagination

Lesson 2.6 Creating New Styles

Lesson 2.7 Modifying Styles

Unit 3 Creating Custom Document Elements

Lesson 3.1 Using Building Blocks

Lesson 3.2 Working with Themes

Lesson 3.3 Managing Index Entries

Lesson 3.4 Creating a Table of Figures

Lesson 3.5 Managing Bibliography Sources

Unit 4 Using Advanced Word Features

Lesson 4.1 Using Fields

Lesson 4.2 Building Forms

Lesson 4.3 Recording and Running Macros

Lesson 4.4 Modifying and Copying Macros

Lesson 4.5 Using Mail Merge

Lesson 4.6 Creating Custom Envelopes

Lesson 4.7 Creating Custom Labels

 

Learn-by-Doing: Microsoft 365 - Excel (Level 2)

Unit 1 Managing Workbook Options

Lesson 1.1 Managing Version History

Lesson 1.2 Collaborating Using Comments

Lesson 1.3 Translating Data

Lesson 1.4 Creating External References

Lesson 1.5 Protecting Your Data

Unit 2 Using Advanced Editing and Formatting Features

Lesson 2.1 Filling Data in a Series

Lesson 2.2 Using Custom Number Formats

Lesson 2.3 Setting Data Validation

Lesson 2.4 Outlining Data

Lesson 2.5 Using Conditional Formatting

Lesson 2.6 Recording and Running Macros

Lesson 2.7 Modifying and Copying Macros

Unit 3 Creating Custom Document Elements

Lesson 3.1 Using Logical Functions

Lesson 3.2 Building Nested Formulas

Lesson 3.3 Testing for Multiple Conditions

Lesson 3.4 Using Conditional Functions

Lesson 3.5 Using the LET Function

Lesson 3.6 Using Lookup Functions

Lesson 3.7 Working with Dates and Times

Lesson 3.8 Consolidating Data

Lesson 3.9 Performing What-If Analysis

Lesson 3.10 Performing Financial Calculations

Lesson 3.11 Using Functions to Sort and Filter Data

Unit 4 Using Advanced Word Features

Lesson 4.1 Creating Advanced Charts

Lesson 4.2 Creating More Advanced Charts

Lesson 4.3 Generating and Modifying PivotTables

Lesson 4.4 Configuring PivotTable Value Fields

Lesson 4.5 Creating PivotCharts

 

MOS Certification Information

The Learn-by-Doing: Microsoft 365 Series (Level 2) is 100% aligned to the skills assessed in Microsoft Office Specialist (MOS) Expert Certification Exams and is endorsed by Certiport, the leading provider of certification exams. MOS is an industry-leading certification allowing students to demonstrate their mastery of the full functionality of Microsoft 365 apps for future success in the classroom and the workplace.

What is Microsoft 365?

Microsoft 365 is a subscription service providing users with a suite of the some of the most commonly used productivity applications, including Word, Excel, PowerPoint, and more. In contrast to a one-time purchase of an individual application (such as Microsoft Word 2019installed on a user’s computer, Microsoft 365 provides access to the most up-to-date versions of each application with the latest features and updates as soon as they’re released. In addition, users can take advantage of cloud storage and online collaboration features via OneDrive, providing one central online location to save and manage work.

 

To help users create and share documents across all devices, Microsoft 365 also includes online, web-based versions of Word and other key applications. Files saved to OneDrive can either be opened from the desktop application to access all of Word’s robust features, or using a streamlined online version optimized for the web. However OneDrive files are accessed, Word’s AutoSave feature ensures that all changes made to your files are reflected in real time and available to all your collaborators.

FREE Online Instructor and Student Resources

The Free Online Instructor and Student Resources for the Learn-by-Doing: Microsoft 365 Series (Level 2) are housed on eReadiness.com.

 

Online Instructor and Student Resources Include:

  • Lesson Source Files
    • Files containing the initial text or data required to begin each lesson are provided.
  • Lesson Answer Keys
  • Student Resource Files
    • Supplemental files provide the resources students need to complete lessons involving importing objects from external documents.
  • Skills Mastery Assessments and Answer Keys
    • Skills Mastery Assessments measure students' ability to demonstrate the Microsoft 365 skills introduced in each Part of the book.
eTextbook License Information

Transferable eTextbook Student License: One license is required per student per term within a given school year. Once a term is completed, licenses can be reused. The number of licenses required is equal to the maximum number of students using an eTextbook within one term. See example below:

Example to Determine Number of eTextbook Licenses Required
  Semester 1
Student Enrollment
Semester 2
Student Enrollment
eTextbook Licenses
Required
Course A 60 30 60
Course B 90 90 90

Minimum: A minimum purchase of 15 licenses is required.

Term: Licenses are valid for 5 years (transferable term to term).

Instructor Resources: Included FREE for unlimited number of instructors; 5-year access.

Format/Delivery: eTextbook is delivered in PDF format. The eTextbook and student/instructor resources can be uploaded to any LMS or accessed through eReadiness.com.

License Pricing: Pricing is determined by the number of licenses purchased. If the number of licenses you require exceeds the quantity displayed, call or email for volume pricing.

Specifications

Grade: 9-12

Learn-by-Doing: Microsoft 365 Series (Level 2) (eTextbook 5 Yr. Student License) - 15-49 Licenses
ISBN: 9781626896093
Author: The Development Team at B.E. Publishing and John DeCarli
© 2023
Print Color: Full Color

Learn-by-Doing: Microsoft 365 Series (Level 2) (eTextbook 5 Yr. Student License) - 50-99 Licenses
ISBN: 9781626896093
Author: The Development Team at B.E. Publishing and John DeCarli
© 2023
Print Color: Full Color

Purchase Options (eTextbook Format Only)

Item # Item Name ISBN Qty. Unit Price Total
TB-M365-S2-ET-1 Learn-by-Doing: Microsoft 365 Series (Level 2) (eTextbook 5 Yr. Student License) - 15-49 Licenses 9781626896093 $110.95
TB-M365-S2-ET-2 Learn-by-Doing: Microsoft 365 Series (Level 2) (eTextbook 5 Yr. Student License) - 50-99 Licenses Call or email for 100 or more licenses. 9781626896093 $88.95
Product Total: $0.00