Updated 2012.03.02
Editing cells
- Enter text, dates, and numbers
- Clear cell content
- Edit cell content
- Go to a specific cell
- Insert and delete selected cells
- Work with series (AutoFill)
- Enter formulas using arithmetic operators (+, -, *, /, ^)
Formatting cells
- Format text: font name, font size, font style (bold, italic, underline), font color
- Set border style, color, and size
- Set fill color
- Set cell horizontal alignment
- Set cell vertical alignment
- Set text rotation
- Set cell indentation
- Turn text wrap on/off
- Merge and center cells
- Apply cell styles
- Clear cell formats
- Apply conditional formatting
- Increase/decrease the number of displayed decimal places in a number
Formatting worksheets
- Modify size of rows and columns
- Insert and modify the header (file name, page number, total pages, etc.)
- Insert and modify the footer
Page layout and printing
- Set the margins for a worksheet
- Set the page orientation for a worksheet
- Set print area, clear a print area
- Set print titles and options (gridlines, print quality, row & column headings)
- Set the scaling for a worksheet before printing
Working with worksheets & workbooks
- Insert and delete rows and columns
- Hide and unhide rows and columns
- Freeze and unfreeze rows and columns
- Move between worksheets in a workbook
- Rename a worksheet
- Insert and Delete worksheets
- Move and copy worksheets
- Create formulas that use 3D references
- Print and preview multiple worksheets
Inserting Objects
- Insert, move, format, and delete pictures, clipart, shapes, SmartArt, screenshots, text boxes, and WordArt
Charts
- Create a chart (bar, column, pie, or line)
- Modify the text in a chart (titles, legend)
- Format the text in a chart (titles, legend)
- Change colors of chart components (bars, columns, pie segments, lines, grid lines, background, etc.)
- Print a chart
Formulas & Functions
- Use both absolute & relative references
- Use AutoSum
- Use the Formulas ribbon to insert a function
- Use basic arithmetic functions: AVERAGE, SUM, COUNT, MIN, MAX, SUMIF, COUNTIF
- Use basic financial functions: FV, PMT,
PV, RATE, NPER
- Use basic logical functions: IF, AND,
OR, NOT
- Use basic date and time functions: NOW,
TODAY, DATE, MONTH, DAY, YEAR, WEEKDAY
- Use basic database functions: DSUM, DAVERAGE, DCOUNT, DMIN, DMAX
- Use lookup functions: HLOOKUP, VLOOKUP
- Add and delete a named range
- Use a named range in a formula
Data
- Perform single and multi-level sorts
- Apply data filters (AutoFilter, Advanced Filter)
- Create pivot tables
- Create pivot charts
- Use Goal Seek
- Import data from text files (use the text import wizard)
- Import from other applications (use the "text to columns" feature)
- Import a table from an HTML file
Miscellaneous
- Use a template to create a new workbook
- Customize a toolbar
- Create a macro using the macro recorder
- Assign a macro to a command button