-
Work with the Ribbon and ScreenTips
-
Use the Quick Access Toolbar
-
Move from sheet to sheet in a workbook
-
Rename, insert, move, copy, and delete a sheet
-
Change the default number of sheets
-
Enter text and numbers in cells
-
Use AutoComplete and enter information in a selected range
-
Replace and edit cell contents
-
Use the Undo and Redo commands
-
Create, open, save, and close a workbook
-
Use the Go To command
-
Select data using the mouse and keyboard
-
Change worksheet views
-
Enter a formula using cell references
-
Edit a formula and understand the Order of Operations
-
Use the “Insert Function” dialog box
-
Use the Function Library
-
Use Formula AutoComplete
-
Use the AutoSum button and drop-down list
-
Use the Trace Error button
-
Use the AutoFill feature
-
Resize columns and rows
-
Change a cell reference in a formula to absolute or mixed
-
Insert and delete cells, rows, and columns
-
Hide columns, rows, and a worksheet
-
Move, copy, and paste data
-
Use the Paste Options button and Paste List
-
Collect and paste multiple items
-
Split a window and freeze panes
-
Create, view, show, hide, edit, print, and delete Comments
-
Format cells and cell contents
-
Draw, apply, and erase borders
-
Copy formatting using Format Painter
-
Apply cell styles and themes
-
Print preview and change page orientation
-
Change margins and center data on a page
-
Create headers and footers
-
Insert and remove a page break
-
Use Page Break Preview
-
Print row or column titles on every page
-
Print data and scale printed output
-
Set and clear a print area
-
Exit
Excel
