Microsoft Excel 2016 – Level 1

This is our most popular course. After taking our 1-day Excel 2016 training course, you will be able to create workable spreadsheets that convey concise, up-to-the-minute data and look good doing it.

What We Cover:

• The RIBBON

•  

• The Quick Access Toolbar

  • How to customize it for faster, more efficient use

• The FILE tab: what’s on it; how to use it

• Formulas: keyboard vs mouse

  • =SUM

  • =MAX

  • =MIN

  • =AVERAGE

  • =COUNT

  • =COUNTA

• Formatting

  • Selecting multiple, random ranges

  • shading

  • text font

  • text colour

  • vertical alignment

  • wrapping text

  • text orientation

  • borders

• Selecting cells or ranges (5 shortcuts)

• Copy

• Move

• Drag & Drop

• The amazing Fill button

  • The FILL HANDLE performs two tasks, depending on the contents of the original cell: it copies the contents of the cell (i.e., an equation or text) or completes a SEQUENCE (i.e., days of the week or months of the year).
    How to use and manipulate the pre-programmed lists (days of the week, months of the year)
    How to create your own custom fill lists (for your most often-used column and row headings)
    Using the Fill Handle to quick-copy data and formulas

• Flash Fill

• Data alignment

• Merge & Centre

• Inserting/deleting columns/rows

• Adjusting column widths efficiently

• Using the Format Painter efficiently

• Proper spreadsheet layout

• Understanding BEDMAS (Proper Order of Operations)

• Understanding and using ABSOLUTE cell addresses

• The Freeze Panes function`

• Print preview

• Printing

• Repeating headings at the top of each printout page

• Using the Conditional Formatting function

  • You can have data formatted based on conditions that you specify. This function is particularly useful for worksheets that show financial figures (black = positive, red = negative), test results (results change color based on their value), or any time you want to highlight data that falls within a certain value.

• Basic charts/graphs

• Introduction to IF equations (if time)