Excel 2016 Tips, Tools, and Timesavers

excel 2013 iconCourse Length

Three hours

 Prerequisites

Excel 2016 Introduction or equivalent experience

 Course Description

This course highlights 82 features for editing, formatting, printing, & customizing Excel. The tips included will give a “back door” approach to accomplishing tasks quickly & efficiently.

 Course Topics

  • Add color to worksheet tabs
  • Create multiple lines within a cell
  • Resize the formula bar
  • Format selected data within a cell
  • Format cell content as text
  • Enter telephone numbers, social security numbers, and zip codes
  • Use a custom format to enter dates
  • Use a screentip to display cell contents
  • Fill cell(s) the width of a column
  • Fill nonadjacent cells with the same entry
  • Enter data by picking from a drop-down list
  • Add an AutoCorrect entry
  • Use autofill, the autofill options button, reverse the autofill action, and automatically fill down a column
  • Use Flash Fill
  • Create a linear series
  • Filter records for unique values and copy to another location
  • Remove duplicates
  • Add a picture as a sheet background
  • Use Smart Lookup
  • Insert a picture to appear as a watermark
  • AutoSum multiple columns or rows
  • View the range finder
  • Paste link a picture of cell(s)
  • Select a large range
  • Specify where to move the cell pointer after Enter
  • Insert a worksheet using a keyboard shortcut
  • Insert and delete row(s) or column(s) using a keystroke
  • Move to a different worksheet
  • Select all, adjacent, and nonadjacent worksheets
  • Customize the Quick Access Toolbar
  • Print multiple worksheets with consecutive page numbers
  • Select the same range on several worksheets
  • Work with multiple worksheets at the same time
  • Select cells with special criteria
  • Copy and paste visible data
  • Fill across worksheets
  • Create a hyperlink to another workbook
  • Display/hide formulas in cells
  • Insert cut or copied cells
  • Use the Quick Analysis button
  • Paste from clipboard using Enter
  • Delete and clear cells
  • Move data without replacing
  • Transpose rows and columns
  • AutoFit columns or rows
  • Color cells with a custom pattern
  • Copy formats multiple times
  • Add a double underline
  • Rotate cell contents
  • Jump to or select to the last filled cell
  • Name cell(s), move to named cell(s), and create names using existing titles
  • Insert a range name from a list into a formula
  • Paste all range names in a workbook
  • Filter by selection
  • Insert the path, filename, and worksheet name
  • Customize the Status Bar
  • Search for a function
  • Select cells with a quick keystroke
  • Limit entry to whole positive numbers
  • Select cells where data validation is used
  • Create a quick chart on a separate worksheet
  • Drag and drop cells between worksheets in the same workbook
  • Protect part of a worksheet and unprotect entire worksheet
  • Open multiple workbooks simultaneously
  • Compare two workbooks side by side
  • Copy sheets between workbooks
  • Pin a file to the Recent list
  • Hide and unhide a workbook
  • Use Page Break Preview
  • Join text and currency
  • Show/hide screen elements
  • Customize the Ribbon

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.