Excel Introduction
Short course
In Cardiff
Description
-
Type
Short course
-
Location
Cardiff (Wales)
-
Duration
1 Day
This course introduces the skills necessary for productive development of workbooks. It includes tasks to explore Excel, create simple formulas, copy and move data, and print worksheets. The student will also learn how to work with ranges and use the Office Assistant, basic workbook skills and page set up.
Facilities
Location
Start date
Start date
About this course
Before attending this course, students must have: Knowledge and experience in using a Windows environment
Reviews
Course programme
Overview
This course introduces the skills necessary for productive development of workbooks. It includes tasks to explore Excel, create simple formulas, copy and move data, and print worksheets. The student will also learn how to work with ranges and use the Office Assistant, basic workbook skills and page set up.
Examination information
This course helps prepare delegates for the ECDL Module 4 - Spreadsheets examination and the Microsoft Office Specialist Excel Proficient examination
Prerequisites
Before attending this course, students must have:
Knowledge and experience in using a Windows environment
Course outline
Module 1 - Exploring Excel
Using the Interface
Working with Worksheets
Using the Task pane
Changing Toolbar and Menu Options
Module 2 - Using Basic Workbook Skills
Selecting a Cell
Scrolling
Entering Text and Numbers
Data Shortcuts
Module 3 - Working with Ranges
Using Ranges
Selecting Ranges
Using AutoFill Features
Module 4 - Creating simple Formulas
Entering Formulas
Using Functions
AutoSum
Checking Errors
Module 5 - Copying and Moving Data
Copying/ Cutting and Pasting
Using the Clipboard Task Pane
Creating an Absolute Reference
Module 6 - Printing
Previewing a Worksheet
Printing a range
Module 7 - Using Page Set Up
Setting Margins
Creating Headers and Footers
Module 8 - Formatting Numbers
Using Number Formats
Module 9 - Formatting Text
Formatting Cell Text
Wrapping Text
Aligning Text
Module 10 - Working with Columns and Rows
Changing Width and Height
Adjusting Automatically
Inserting and Deleting Rows and columns
Module 11 - Formatting Cells
Formatting Borders and Colours
Clearing Formats
Using the Format Painter
Module 12 - Using Automatic Formatting and Styles
Using the Automatic Formatting Features
Creating a Style
Merging Styles
Module 13 - Using Large Worksheets
Increasing Magnification
Splitting the Window
Freezing Panes
Module 14 - Using Paste Special
Working with Paste Special
Performing mathematical Operations
Excel Introduction