Excel 2016 Intermediate Training Course for Computer Trainers

Office 2016 Training MaterialsExcel 2016 Training Materials

Excel 2016 Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a Page(S)
  • Visually Checking Your Calculations
  • Displaying Gridlines When Printing
  • Printing Titles on Every Page
  • Printing Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Zooming the View
  • Printing Options
  • Setting the Number of Copies to Print
  • Selecting a Printer
  • Selecting Individual Worksheets or the Entire Workbook
  • Selecting Which Pages to Print
  • Single or Double Sided Printing
  • Collation Options
  • Page Orientation
  • Paper Size
  • Margins
  • Scaling
  • Printing

Excel 2016 Functions and Formulas

  • Getting Help with Functions
  • Nested Functions
  • Consolidating Data Using a 3-D Reference Sum Function
  • Mixed References within Formulas

Excel 2016 Time & Date Functions

  • Inserting the Current Time and Date
  • Today Function
  • Now Function
  • Day Function
  • Month Function
  • Year Function

Excel 2016 Mathematical Functions

  • Round Function
  • Rounddown Function
  • Roundup Function

Excel 2016 Logical Functions

  • If Function
  • And Function
  • Or Function

Excel 2016 Mathematical Functions

  • Sumif Function

 

Excel 2016 Statistical Functions

  • Count Function
  • Counta Function
  • Countif Function
  • Countblank Function
  • Rank Function

Excel 2016 Text Functions

  • Left Function
  • Right Function
  • Mid Function
  • Trim Function
  • Concatenate Function

Excel 2016 Financial Functions

  • Fv Function
  • Pv Function
  • Npv Function
  • Rate Function
  • Pmt Function

Excel 2016 Lookup Functions

  • Vlookup Function
  • Hlookup Function

Excel 2016 Database Functions

  • Dsum Function
  • Dmin Function
  • Dmax Function
  • Dcount Function
  • Daverage Function

Excel 2016 Named Ranges

  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions

Excel 2016 Cell Formatting

  • Applying Styles to a Range
  • Conditional Formatting
  • Custom Number Formats

Manipulating Worksheets within Excel 2016

  • Copying or Moving Worksheets between Workbooks
  • Splitting a Window
  • Hiding Rows
  • Hiding Columns
  • Hiding Worksheets
  • Un-Hiding Rows
  • Un-Hiding Columns
  • Un-Hiding Worksheets

Excel 2016 Templates

  • Using Templates
  • Creating Excel Templates
  • Editing Excel Templates

Paste Special Options within Excel 2016

  • Using Paste Special to Add, Subtract, Multiply & Divide
  • Using Paste Special ‘Values’
  • Using Paste Special Transpose Option

 

Excel 2016 Intermediate Training Course for Computer Trainers
Rate this post