Shopping Cart – Checkout
Return to the Textbook Information Page
Contact Us
Access Technology Institute Copyright Notice
Introduction
Maximize the Microsoft Excel Window
Disable JAWS Virtual Ribbon Menus
Configure Excel
The Options Window
General Property Sheet
The Start Screen
Start Screen Layout
The Home Property Sheet
Home Property Sheet Controls
Manage Documents in the Documents List Box
New Property Sheet
Open Property Sheet
Recent
Shared with Me
OneDrive
This PC
Add a Place
Browse
Account
Feedback
Options
Close the Start Screen
The Microsoft Excel Display
The Title Bar
Quick Access Toolbar
Ribbon Tabs
Ribbon
Document Window
Status Bar
Open and Close the Ribbon
Ribbons
Note on Ribbon Tabs and Ribbon Terminology
Ribbon Tabs
Ribbon
Open Vs. Closed Ribbon
Exercise – The Display and Ribbon
Quick Access Toolbar
Add Commands to the Quick Access Toolbar
Remove Commands from the Quick Access Toolbar
Customize Ribbons
Open Ribbon Customization Options
Ribbon Terminology
The Customize Ribbon Property Sheet
Add Ribbon Commands to an Existing Ribbon Tab
Remove Commands from a Ribbon Group
Add a Ribbon Tab
Remove Custom Ribbon Tabs, Groups or Commands
Organize Ribbon Tabs, Groups and Commands
Hide and Show Ribbon Tabs
Reset Ribbon Customizations
Export Ribbon Configurations
Import Ribbon Configurations
Save or Cancel Ribbon Customizations
Access Custom Ribbon Tabs
Customize the Quick Access Toolbar
Exercise – Ribbon and Quick Access Toolbar
Workbooks and Worksheets
Workbooks
Worksheets
Rows, Columns, and Cells
Navigate a Worksheet
JAWS for Windows Cell Verbosity
Insert Cell Data
Insert Fractions
The Active Cell
Edit Cell Data
Delete Cell Data
Exercise: Workbooks, Worksheets, and Cells
Navigate and Read Text
Windows Text Navigation
Phonetic Character Reading on Pause
JAWS for Windows Desktop Reading Commands
JAWS for Windows Laptop Reading Commands
JAWS for Windows Say All
Adjust JAWS for Windows Speech Rate
Temporarily Adjust Speech Rate
Permanently Adjusting Speech Rate
Exercise – Navigate and Read Text
Manage Worksheet Elements
Create a Worksheet
JAWS for Windows Cell Lists
Select Cells, Rows, Columns, and Regions
Extend Row and Column Selection
Remove Selection
Select Non-Contiguous Regions and Cells
Read Selected Cells
JAWS for Windows Selection Verbosity
Insert Cells, Rows, Columns and Worksheets
Insert Cells
Insert Rows and Columns
Insert a single row or column
Insert Multiple Rows or Columns
Insert a Worksheet
Navigate Excel Worksheets
Rename a Worksheet
Column and Row Titles
Configure JAWS for Windows Title Reading
Insert Additional Data
Delete Worksheet Elements
Delete Cells
Delete Rows and Columns
Delete a single row or column
Delete multiple Rows:
Delete a Worksheet
Exercise: Manage Worksheet Elements
Manage Cell Text
Cropped Text
Manual Carriage Return
Wrap Cell Text
Adjust Column Width and Row Height
Adjust column width
Adjust Row Height
Autofit
Exercise: Manage Cell Text
Hide Rows, Columns, and Worksheets
Unhide Worksheets, Columns and Rows
Unhide a Worksheet
Unhide Columns and Rows
Exercise Hide and Unhide Data, Formulas and Functions
Formulas
Edit Formulas
Reference Cell Addresses in Formulas
Functions
Exercise: Hide and Unhide Data; Formulas and Functions
Absolute and Relative Values
Row and Column Totals
Assign Totals Cells
Row or Column Total JAWS for Windows Keyboard Commands
Read Column or Row Totals with JAWS for Windows
Clear Column or Row Totals
Format Cells
The Format Cells Dialog
Format Numbers
Format Numbers in the Format Cells Dialog
Jaws for Windows Number Format Alerts
Number Format Keyboard Accelerators
Format Numbers in Your Worksheet
Align Cell Data
Align Cell Data in the Format Cell Dialog
Align Cell Data in the Home Ribbon
Windows Alignment Keyboard Accelerators
Font Attributes
The Format Cell Dialog Font Property Sheet
Open the Font Dialog
Font Configuration Controls
Font Attribute Keyboard Accelerators
Home Ribbon Font Attribute Commands
Say Cell Font and Attributes with JAWS for Windows
Cell Borders
Format Cell Dialog Border Property Sheet
Add Borders in the Home Ribbon
Cell Border Keyboard Accelerators
Describe Cell Borders with JAWS for Windows
JAWS for Windows Cell Border Indication
Cell Colors
Format Cell dialog Fill Property Sheet:
Home Ribbon Fill Color Split Button
Removing Cell Formatting
Insert the Date or Time
Exercise: Cell Formats
Hyperlinks
Insert a Hyperlink
Link to a Web Page
Link to an Email Address
Link to Another Document
Open a Linked Document in a Target Frame (Internet Only)
Edit a Hyperlink
Remove a Hyperlink from Text
Activate a Hyperlink
Delete a Hyperlink
Read a Hyperlink with JAWS for Windows
JAWS for Windows Hyperlink Detection
JAWS for Windows Links List
Exercise: Hyperlinks
Databases
Open the Database Form
Navigate Records in the Database Form Dialog
Search Database Records
Delete a Record
Filter a Database
JAWS for Windows Filtered Columns and Rows Detection
Exercise: Databases
Named Cells, Ranges and Tables
Name a Cell or Cell Range
Format a Table
Create a Named Constant
Define a Formula Name
Select a Named Cell, Named Range or Table in Go To
Manage Cell and Table Names
Reference Names in Formulas
Exercise: Named Cells, Ranges, and Tables
JAWS for Windows Custom Summary Labels
Create a Custom Summary Label
View Custom Summary Labels
Organize Custom Summary Labels
Rename a Custom Summary Label
Delete a Custom Summary Label
Delete All Worksheet Custom Summary Labels
Exercise: JAWS for Windows Custom Summary Labels
JAWS for Windows Monitor Cells
Configure Monitor Cells
Read Monitor Cells
Configure Monitor Cell Title Reading
List Monitor Cells
Clear Monitor Cells
Exercise: JAWS for Windows Monitor Cells
Merge Cells
Center and Merge
Exercise: Merge
Excel Autofill
Input the Same Data into a Cell Range
Input a Series of Values
Fill a Growth Trend
Flash Fill
Exercise: Autofill and Flash Fill
Quick Analysis
Formatting Property Sheet
Charts Property Sheet
Totals Property Sheet
Table and Sparklines Property Sheets
Conditional Formatting
Highlight Cell Rules
Top/Bottom Rules
Data Bars
Color Scales
Icon Sets
Create New Formatting Rules
New Formatting Rule Dialog
Manage Custom Rules
Clear Conditional Formatting
Go To Dialog Special Options
JAWS Conditional Formatting Alert
Goal Seek
Sort a Data Region
Microsoft Excel Find and Replace Dialog
Open Find and Replace Dialog Property Sheets
Find
Replace property Sheet
Exercise: Find and Replace
Charts
JAWS for Windows Charts List
Read a Chart with JAWS for Windows
Edit a Chart
Chart Design Ribbon
Chart Format Ribbon
Pivot Tables
Insert Pivot Tables in Quick Analysis
Navigate a Pivot Tables
Change Pivot Table Column Contents
Shopping Cart – Checkout
Return to the Textbook Information Page