Microsoft Excel for Beginners, 1-Day Course in Melbourne

Course Code: EXLBEG

Duration: 1 Day

Overview

This one-day training course is tailored to meet the needs of people new to Excel. Pick up useful shortcuts while learning the basics of creating, calculating formatting and printing spreadsheets using Microsoft Excel. Learn through demonstration and hands-on activities based on real-world situations. This course focuses on developing neat, accurate and well-developed Excel spreadsheets using good design and documentation principles.

Audience

This course is designed for people who are either new to Excel, or who want to fill in gaps and gain confidence and independence using Excel. Upon completion of the course, participants should be able to produce formatted spreadsheets containing basic formulas and functions, budgets and well-designed print copies.

Prerequisites

No prior knowledge of Microsoft Excel is required; however participants need to have general mouse and keyboard skills and an understanding of personal computers and the Windows operating system.

Module List

• Module 1: Basics of Excel

• Module 2: Create a New Workbook

• Module 3: Working with Workbooks

• Module 4: Edit a Workbook

• Module 5: Learning Formulas and Functions

• Module 6: Selecting Cell Ranges

• Module 7: Copying Data in Excel

• Module 8: Special Pasting in Excel

• Module 9: Moving Data in Excel

• Module 10: Font Formatting in Excel

• Module 11: Applying Borders in Excel

• Module 12: Cell Alignment in Excel

• Module 13: Format Rows and Columns

• Module 14: Format Numbers

• Module 15: Formatting Techniques for Numbers

• Module 16: Page Setup in Excel

• Module 17: Printing

Click here for the full 'Excel for Beginners' course outline