Course Summary

Spreadsheets are a vital tool in personal and business. They are particularly useful for calculations and for managing lists. Over time, Excel has also gained considerable strengths in charting, printing grids of data and even holding diagrams for presentations. 

This is a gently paced introduction to Excel fundamentals for people who have not previously been involved in work or roles that depend on Excel awareness and skills. We discuss how the program behaves when you type into it, the organisation of the menus and keyboard shortcuts, calculating with formulae. We will also discuss adding objects like Charts, Shapes, Textboxes.

We talk about the approaches to laying out and working with worksheets, calculating with formulae.

Who is this course for?

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

What should I bring on the day?

Please bring along a USB stick to save your work.

Where to next?

Continue your Microsoft Office training with our Honing Your Skills in Excel – Intermediate (Online) or Taking Excel Further – Advanced (Online) short courses

Course Sessions

Tuesday, 16th March - 4 classes


Session ID SRAX1102C
16 Mar - 6 Apr 9:00am - 12:30pm
Location CAE
Session Fees
$345 / $328 (conc)
Teacher
Ananda Sim

During the course you will cover topics such as:

  • Getting to know the Excel User Interface:
    • Most frequently used menu items in the Excel Ribbon
    • Managing the Quick Access Toolbar
    • The Right Click – Context Menu
    • Nifty and productive Function Keys
    • Switching between cell navigation vs cell editing
    • Take advantage of the three Workbook Views in Excel
  • The Excel file – formats, extensions, compatibility, features
  • Calculating with Excel
  • The different cell data types
  • Text, Numbers, Boolean
  • Dates stored as Numbers, as text
  • Numbers stored as Text
  • The three layers of an traditional Excel cell
  • How they affect subsequent calculation results
  • Controlling how Excel interprets them
  • The basics of Excel formula expressions
  • Absolute and Relative Addressing
  • Arithmetic and text operators in the expressions
  • Show Formulas, Trace Precedents, Dependents
  • Basic Worksheet Functions – SUM, COUNT, VLOOKUP
  • Knowing how to copy, paste, fill of fixed and automatically varied cell ranges and formats
  • Understanding that working with Excel falls into establishing, recognising, choosing models that are optimum for the task at hand and best use case
  • Working with tables of information
    • Converting a cell range to a Table and vice versa
    • Table Formatting
    • Sorting
    • Hiding and Showing relevant items (Filtering)
    • Searching
  • Basic Cell, Column, Row, Worksheet formatting
  • Excel specific techniques in printing – Print Area, Repeating Rows and Columns, Automatic
  • Fit to pages wide and tall, Gridlines, Headings
  • Excel charts – approach and mindset
  • Making notes in Excel with overlaid Text Boxes
  • Other overlaid Objects
  • Figuring out what to do
  • Reading the screen for visual clues and deducing how to resolve unexpected Excel behaviour
  • Microsoft keyword sensitive Suggested Actions
  • Official Microsoft Help
  • Third Party Help on the web
Last updated: January 19, 2021 04:50pm