Microsoft Excel Beginners Course 302 Training Manual & Workbook – Creating and Editing Spreadsheets

Original price was: $49.00.Current price is: $19.00. inc GST

This Training Manual and Workbook contains step-by-step tasks using Microsoft Excel for training case studies based on real world scenarios including.

  • Instant download in PDF format (33 pages)
  • Based on real world case studies
  • Includes 8 practice Excel exercise files
  • Course Content for Excel Beginners Certificate
  • Upgrade path to Full course
  • Skills on budgeting, sales reports, database files & costings


You’ll have sales reports, database, household budgets and other exercise files to work with to learn these skills.

  • Selecting information: Understanding the mouse cursors used within Excel, how to select cells, columns and rows and multiple ranges of information, how to select cells using the keyboard.
  • Copy and Paste: Drag and drop, cut, copy and paste in a worksheet and from one worksheet to another and even between different software programs.
  • Editing cells: Typing and entering information, editing existing information and entering the changes, using the status bar information, escaping out of cells.
  • Changing column width and row height for single and multiple columns as well as making all the columns the same width and using AutoFit.
  • Database: Creating a simple database, understanding simple database structure (ideal knowledge for mail merge with Microsoft Word), inserting and deleting columns, using Undo and Redo options.
  • Autofill: Automatically fill numbers, dates, number patterns, days, months and years and much more. The fast way to insert sequential numbers and words.
  • Understanding date formatting (this forms the basis for future calculations based on date format).