Basic - Working With Excel Worksheets


• Insert Cells, Rows and Columns
• Delete Cells, Rows and Columns
• Find and Replace
• Go To Command
• Spell Check
• Selecting entire rows
• Selecting entire columns
• Selecting an entire table range.
• Indenting
• Choosing fill colors
• Choosing Borders
• Merging Cells
• Difference between Currency and Accounting (alignment purposes)
• Format Painter
• Aligning Cell Content
• Add Borders and Colors to Cells
• Change Column Width and Row Height
• Hide or Unhide Rows and Columns

Sort and Filter
• Basic Sorts
• Custom Sorts
• Filter

Printing
• Page Properties and Printing from Print Preview
• Page Set up Dialog Box
o Create Custom Headers and a Footers
o Set Page Margins (Check show Margins)
o Change Page Orientation
• Page Layout Tab
    o Orientation
    o Margins
    o Print Area
    o Print Titles
    o Set Page Breaks
• Print from Office Button
    o Print a Range
    o Print Sheet, or multiple sheets at once
• Printing Formulas