Excel Tip: An alternative to using the AutoSum icon is pressing Alt + =.
Word, Excel, PowerPoint and Access Tip: Nudge a selected object (graphic, photo, text box etc) by pressing and continue holding down the Ctrl key while also pressing the appropriate arrow key. Each time the arrow key is pressed, the object will "nudge" in that direction.
|
- What is a Spreadsheet?
- Basics of Software Package
- Entering & Editing Data
- Cut, Copy & Paste (including Office Clipboard)
- Formulas & Functions (e.g. Vlookup, IF, Counts)
- Editing Worksheets
- Worksheet Properties
- Spell Check
- Printing (Print Preview, Page Break Preview)
- Page Set up
- Inserting and Formatting Headers/Footers
- Formatting Text and Cells (including Borders and Shading)
- Password Protecting Worksheets and Workbooks
- Find and Replace
- Sorting
- Comments
- Graphics & Objects (Drawing)
- Charts
- Paste Links
- Hyperlinks
- Range Names
- Creating, Revising Templates
- Conditional Formatting
- Data Validation
- Auditing Formulas
- Goal Seek/Solver
- Filtering
- List Boxes
- Macros
- Merging Workbooks
- Pivot Tables
- Data Tables
- Access/Word/PowerPoint: Importing/Exporting
- Creating, Revising Templates
|
|
