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 BAF with MS Office 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
- Navigate in a document
- Enter, select, and edit text
- Create numbered and bulleted lists
- Use document views
- Save documents as different file types
- Create a table
- Build an effective resume in a table
- Select data in a table
- Format tables
- Apply table styles
- Print documents
- Work with columns and set margins
- Format text and apply styles
- Insert headers and footers
- Add footnotes and endnotes
- Insert citations and a bibliography
- Incorporate captions and a table of figures
- Insert comments and use Track Changes
- Create an eye-catching brochure
- Insert shapes in a document
- Add pictures, text boxes, WordArt, and special effects to a document
- Choose page setup features
- Communicate information with SmartArt
- Format the page background
- Wrap text around a document
- Print part of a document
- Build data sources
- Create main documents
- Perform a mail merge
- Deal with merge problems
- Generate envelopes and labels
- 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
- Create a new presentation
- Add text to slides
- Apply themes
- Add slides
- Control the indent of bulleted text
- Navigate a slide show
- Use Outline view to create, move, and delete slides and edit text
- Create a presentation from a Microsoft Word outline
- Format and align text and adjust character spacing and line spacing
- Use Slide Sorter view and Sections
- Print a presentation
- Add pictures, screenshots, and shapes to a presentation
- Remove backgrounds and apply artistic effects to slide images
- Add transition effects to a slide show
- Add animation to objects on a slide
- Add sound effects to transitions and animations
- Acquire and add audio to a presentation
- Acquire and add video to a presentation
- Edit movies and add movie effects
- Use slide show timings
- Loop a presentation endlessly
- Identify database objects and the functions they perform
- Identify table features
- Create database tables
- Identify and choose data types
- Sort and filter table records
- Import a data source
- Establish a relationship between two database tables
- Create basic forms
- Create forms using the Forms Wizard
- Modify forms using Layout View
- Modify forms using Design View
- Set properties for form sections and form controls
- Set the tab order of a form
- Create multiple item forms and split forms
- Create, save, and run select queries
- Create select queries using multiple tables
- Use simple query criteria
- Use AND and OR criteria in queries
- Use wildcard characters in query criteria
- Sort query results
- Create and format a calculated field
- Create basic reports using the Report tool
- Create reports with the Report Wizard
- Change field alignment and size in Layout View
- Change field properties
- Insert logos and dates
- Insert new fields
- Transfer information between Office apps
- Use Excel to create charts from Access
- Convert a Word outline to a PowerPoint presentation
- Present Excel charts in PowerPoint
- Use Outlook to send documents