Excel Hands-On Exercises
Download All Excel Exercises (Zipped File)
Or download individually:
- 0001 How to Open and Close Spreadsheets
- 0002 How to Insert and Delete Tabs
- 0003 How to Move, Rename, and Copy Tabs (Worksheets)
- 0004 How to to Switch Between Tabs (Worksheets)
- 0005 How to Switch Between Spreadsheets (Workbooks)
- 0006 How to Move to the Beginning and End of Your Spreadsheet
- 0007 How to Select Entire Rows or Columns
- 0008 The Fastest Way to Move Around a Spreadsheet
- 0009 How to Use Find
- 0010 How to Select Non-Adjacent Cells
- 0011 How to Go To Any Cell and Use Special Cells
- 0012 How to Zoom In or Out
- 0013 How to Freeze Headers
- 0014 How to Clear Cell Contents
- 0015 How to Insert and Delete Cells, Rows, and Columns
- 0016 The Best Way to Format Cells
- 0017 How to Change Number Formats
- 0018 How to Align Cells
- 0019 How to Wrap Text (PC Only)
- 0020 How to Add and Remove Borders
- 0021 How to Change Column Width and Row Height
- 0022 How to Copy and Paste Column Widths
- 0023 How to Highlight Cells (Change Background Color) (PC Only)
- 0024 How to Change Font, Font Size, and Font Color (PC Only)
- 0025 How to Add a New Line Inside a Cell
- 0026 How to Copy and Paste Formatting
- 0027 How to Undo and Redo Like a Boss
- 0028 The Least Known and Most Helpful Formatting Shortcut
- 0029 How to Hide and Unhide Rows and Columns
- 0030 How to Group and Ungroup Rows and Columns
- 0031 How to Format Multiple Tabs (Worksheets)