These instructions are meant to be a general guide. Your steps may differ, depending on web browser used, version of web browser, any zipping software installed on the computer, and other factors.
Microsoft Internet Explorer / Edge:
A window will open, asking what you want to do with the file.
Google Chrome or Mozilla Firefox
After completing step 1, the file should begin downloading to your computer. You may see the file in the lower-left corner of the browser window. The file is saved to the location specified in your settings for downloads (often the Downloads folder).
Unzip the Files
A pop-up box opens to show the progress. When the files are unzipped, the pop-up box will close and the files will be available in the location you specify.
Remember, there’s usually more than one day to do something on the computer. If you prefer a different method, feel free to use it.
Mastery Series Excel 2021
Back
- Describe similarities and differences among 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
- 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
- Use formulas to perform calculations
- Rearrange data on a worksheet
- Manage multiple worksheets
- Create formulas with functions
- Use AutoSum
- Use relative and absolute cell references in formulas
- Define names for cells and ranges
- Use names in formulas
- Insert charts
- Use chart tools to modify charts
- Move and size charts
- Edit chart data
- Add images to a worksheet
- Apply conditional formatting
- 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
- 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
- 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
- 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
- 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
- Create formulas using lookup functions
- Use the Outline feature
- Create subtotals
- Use the Quick Analysis tool
- Manage data using a table
- Create a custom filter
- Name a table
- Use structured references in a formula
- Create sparklines
- 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
- Change the macro security settings
- Create macros to automate tasks
- Run macros
- Create macro buttons to run macros quickly
- 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
- Create hyperlinks for navigation
- Insert comments
- Add alt text to objects
- Inspect your workbook for issues
- Create forms
- Protect your workbook