New!

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

A Visual Approach to Learning Advanced Microsoft Excel Skills

   
video Watch Textbook Video Overview
   
   
Description

Learn-by-Doing: Microsoft 365 - Excel (Level 2) uses a graphical, screenshot-based approach to support students in mastering the advanced tools and features of Microsoft Excel. Students already familiar with the basics of Excel will explore advanced skills—such as using lookup and reference functions, performing data analysis, and working with PivotTables—in an illustrated, step-by-step format, helping them gain valuable workplace skills and master this essential business application.

 

This textbook has been 100% aligned to the skills assessed in Microsoft Office Specialist (MOS) Expert Certification Exam and is 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 - Excel (Level 2) will prepare your students for success in the modern world.

 

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


Watch Video Overview

Features
  • Over 35 engaging, hands-on lessons covering advanced Excel skills
  • Certification prep for Microsoft Office Specialist Expert Exam
  • Skills Mastery Assessments measure students' ability to demonstrate the skills introduced in each section
Table of Contents

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.


Microsoft 365 Excel (Level 2) Correlations

 

FREE Online Instructor and Student Resources

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

 

Online Instructor and Student Resources Include:

  • Lesson Source Files
    • Files containing the initial 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 Excel skills introduced in each Part of the book.
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 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. Throughout this text, students will learn about saving files to OneDrive and working with Word as a component of Microsoft 365.

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 - Excel (Level 2) (eTextbook 5 Yr. Student License) - 15-49 Licenses
ISBN: 9781626896086
Author: The Development Team at B.E. Publishing and John DeCarli
© 2023
Print Color: Full Color

Learn-by-Doing: Microsoft 365 - Excel (Level 2) (eTextbook 5 Yr. Student License) - 50-99 Licenses
ISBN: 9781626896086
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-E2-ET-1 Learn-by-Doing: Microsoft 365 - Excel (Level 2) (eTextbook 5 Yr. Student License) - 15-49 Licenses 9781626896086 $68.95
TB-M365-E2-ET-2 Learn-by-Doing: Microsoft 365 - Excel (Level 2) (eTextbook 5 Yr. Student License) - 50-99 Licenses Call or email for 100 or more licenses. 9781626896086 $54.95
Product Total: $0.00