Excel 1 | Free Workplace Education

Start Date: Tuesday, September 19th
Time: Tuesday 5:30 pm -9:30 pm
Location: Virtual via Zoom
Cost: Free
Prerequisite: Must be currently employed in a Nova Scotia Business and have basic computer skills.

Course Description

Learning Outcomes:

  • Exploring the screen, standard toolbar and ribbon tools
  • Creating templates
  • Customizing using editing tools
  • Copying and pasting options
  • Applying autofill

Standard Topics: (all of this content must be delivered as a part of this program)

  • Building and using spreadsheets
  • Creating and using formulas
  • Formatting and printing data
  • Charting and graphing

Mandatory Core Concepts

  • Formulas – sum, min, max, average, autosum, cell reference, absolute reference, general calculations, and formulas between sheets
  • Formatting – date, accounting, numbers, currency, and percentages

Printing – single sheet, portion of sheet, all sheets, fit to page, page break preview, and lock headings at top of printouts on multiple sheets