Microsoft Excel 2016 – Level 1

by CTC Computer Training Claim Listing

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.

$175

Contact the Institutes

Fill this form

Advertisement

CTC Computer Training Logo

img Duration

1 Day

Course Details

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)

  • Toronto Branch

    3090 Riverdale Drive, Toronto

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy