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

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

• 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

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

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.

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 2019) installed 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.

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.

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:

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.

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
© 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
© 2023
Print Color: Full Color