Introduction
Learn the essential skills of using Microsoft Excel.
Once completed, students will be able to create Excel workbooks and worksheets, navigate around them, use time saving features such as AutoSum, AutoFill, create simple formulas and format worksheets.
Duration
1 Day
Pre-Requisites
We assume you have an understanding of Microsoft Windows. You will have an ability to work with multiple windows and navigate the desktop, as well as having an understanding of computer file storage (i.e. drives, files and folders).
Course Contents
Getting to Know Excel
- The Excel Workbook Screen
- Using the Ribbon
- Using Shortcut Menus
- Understanding Dialog Boxes
- Understanding the Quick Access
- Understanding the Status Bar
Creating a New Workbook
- Understanding Workbooks
- Typing Text, Numbers, Dates, Formulas
- Making Basic Changes
- Printing a Worksheet
- Selecting Ranges
- Understanding Cells and Ranges
- Selecting Contiguous Ranges
- Selecting Non Contiguous Ranges
- Using Special Selection Techniques
- Selecting Rows and Columns
- Creating an Input Range
- Understanding Data Editing
- Overwriting Cell Contents
- Clearing Cells
- Deleting Data
Filling Data
- Understanding Filling
- Filling a Series
- Filling a Growth Series
- Creating, Modifying, Deleting a Custom Fill List
Formulas and Functions
- Understanding Formulas
- Creating Simple Formulas
- Understanding Functions
- Using the SUM Function to Add
- Summing Non-Contiguous Ranges
- Creating More Complex Formulas
- What if Formulas
- Common Error Messages
Formula Referencing
- Absolute Versus Relative Referencing
- Relative Formulas
- Creating Absolute References
- Working With Live Preview
- Changing Font, Size, Colours, Formatting
- Using the Format Painter
Number Formatting Techniques
- Currencies
- Date Formats
- Clock and Calculated Time
Borders
- Understanding Borders
- Applying Borders to a Cell, Range
- Removing Borders
- Drawing and Erasing Borders
- Formatting the Drawing Pencil
Working With a Worksheet
- Changing the Worksheet View
- Viewing the Formula Bar
- Viewing Worksheet Gridlines
- Inserting, Deleting Cells Into a Worksheet
- Inserting Columns and Rows Into a Worksheet
Printing
- Previewing Before You Print
- Printing a Range
- Printing an Entire Workbook
- Print Options
Page Setup
- Understanding Page Layout
- Built in and Custom Margins
- Centring on a Page
- Changing Orientation and Paper Size
- Setting and Clearing the Print Area
- Using Page Break Preview
- Setting a Background
- Settings Rows as Repeating Print Titles
- Clearing Print Titles
- Printing Gridlines
- Printing Headings
- Scaling to a Percentage
- Fit to a Specific Number of Pages