Boost Your Skills
in Microsoft Excel 365/2021
In-depth coverage of Excel 365 and 2021, including preparation for MOS certification.
Certain exercises require you to use starting files. Download those here.
Feeling stuck on an exercise? Download the full solutions guide for this book.
Learning Objectives
- Describe similarities and differences between Office 2021 for the desktop, Microsoft 365, and Office Online
- Identify uses of cloud storage
- Identify parts of the Office user interface
- Use the spelling checker and other review features
- Identify Office features available through Backstage view
- Use the Office Clipboard
- Format text in Office applications
- Search for Help within Office applications
- Capture a screen in an Office application
Learning Objectives
- Enter data into a worksheet
- Navigate a workbook
- Format a worksheet
- Apply number and date formats
- Enter a series of related data
- Print a worksheet
- Adjust the view with Zoom tools
Learning Objectives
- Use formulas to perform calculations
- Rearrange data on a worksheet
- Manage multiple worksheets
Learning Objectives
- Create formulas with functions
- Use AutoSum
- Use relative and absolute cell references in formulas
- Define names for cells and ranges
- Use names in formulas
Learning Resources
Videos
Self-Assessment
Learning Objectives
- Insert charts
- Use chart tools to modify charts
- Move and size charts
- Edit chart data
- Add images to a worksheet
- Apply conditional formatting
Learning Resources
Videos
Self-Assessment
Learning Objectives
- Create a template
- Start a workbook from a template
- Change worksheet view options
- Sort and filter data
- Create IF functions
- Apply data validation rules
- Use the Scale to Fit printing options
- Create and modify tables
Learning Resources
Videos
Self-Assessment
Learning Objectives
- Apply and customize themes
- Create and use cell styles
- Apply cell borders and fill
- Create custom number formats
- Customize the page setup
- Edit document properties
Learning Objectives
- Identify date serial numbers
- Apply custom date formatting
- Enter times
- Create functions using dates
- Perform date and time calculations
- Create customized conditional formatting rules
- Edit rules using the Conditional Formatting Rules Manager
Learning Objectives
- Create financial functions
- Create one-variable and two-variable data tables
- Use the What-If Analysis tools to create scenarios
- Adjust input values using Goal Seek
Learning Objectives
- Use functions to format text
- Create conditional functions using IF and IFS criteria
- Create formulas using nested functions
- Find and correct errors in formulas
- Use 3-D cell references in formulas
Learning Objectives
- Create formulas using lookup functions
- Use the Outline feature
- Create subtotals
- Use the Quick Analysis tool
Learning Objectives
- Manage data using a table
- Create a custom filter
- Name a table
- Use structured references in a formula
- Create sparklines
Learning Objectives
- Create PivotTables
- Modify and format PivotTables
- Apply a filter to a PivotTable
- Insert a slicer to filter a PivotTable
- Create a calculated field
- Create PivotCharts
Learning Objectives
- Change the macro security settings
- Create macros to automate tasks
- Run macros
- Create macro buttons to run macros quickly
Self-Assessment
Learning Objectives
- Import data from various sources
- Consolidate data from multiple sheets into one sheet
- Create a series of data using different methods
- Chart trends and save chart templates
- Use additional functions for lookups and logic
Self-Assessment
Learning Objectives
- Create hyperlinks for navigation
- Insert comments
- Add alt text to objects
- Inspect your workbook for issues
- Create forms
- Protect your workbook