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