Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 5


Topics included in this 1 day course: Getting Acquainted with Excel; Creating Basic Workbooks; Using Ranges; Creating Formulas; Copying & Pasting Formulas; Columns and Rows; Formatting Worksheets; Worksheet Tools; Setting Worksheet Layout; Printing...


 
Course Outline
Chapter 1 – Getting Acquainted with Excel
1.1.    About Excel
1.2.    The Excel Environment – 2010
1.3.    The Excel Environment – 2007
1.4.    Title Bar
1.5.    The Ribbon
1.6.    The “File” Tab and Backstage View – 2010 Only
1.7.    The Microsoft Office Button – 2007 Only
1.8.    The Scroll Bars
1.9.    The Quick Access Toolbar
1.10.    The Formula Bar
1.11.    The Workbook Window
1.12.    The Status Bar
1.13.    The Workbook View Buttons
1.14.    The Zoom Slider
1.15.    The Mini Toolbar
1.16.    Keyboard Shortcuts

Chapter 2 – Creating Basic Workbooks
2.1     Creating New Workbooks – 2010 Only
2.2.    Creating New Workbooks – 2007 Only
2.3.    Saving Workbooks – 2010 Only
2.4.    Saving Workbooks – 2007 Only
2.5.     Closing Workbooks
2.6.    Opening Workbooks- 2010 only
2.7.     Opening Workbooks - 2007
2.8.     Selecting Cells
2.9.    Entering Text into Cells
2.10.    Entering Numbers into Cells
2.11.    AutoComplete
2.12.    Pick from Drop-Down List
2.13.    Using the “Window” Command Group
2.14.    Switching to Full Screen View
2.15.    Working with Excel File Formats

Chapter 3 – Using Ranges
3.1.    Selecting Ranges
3.2.     Ranged Data Entry
3.3.    Using Auto-Fill

Chapter 4 – Creating Formulas
4.1.    Ranged Formula Syntax
4.2.    Simple Formula Syntax
4.3.    Writing Formulas
4.4.    Using AutoSum
4.5.    Inserting Functions
4.6.    Editing a Range
4.7.    Formula AutoCorrect
4.8.    AutoCalculate

Chapter 5 – Copying & Pasting Formulas
5.1.    Relative References and Absolute References
5.2.    Cutting, Copying and Pasting Data
5.3.    AutoFilling Cells
5.4.    The Undo Button
5.5.    The Redo Button

Chapter 6 – Columns and Rows
6.1.    Selecting Columns and Rows
6.2.    Adjusting Column Width and Row Height
6.3.    Hiding and Unhiding Columns and Rows
6.4.    Inserting and Deleting Columns and Rows

Chapter 7 – Formatting Worksheets
7.1.     Formatting Cells
7.2.    The Format Cells Dialog Box
7.3.    Clearing All Formatting from Cells
7.4.    Copying All Formatting from Cells to Another Area

Chapter 8 – Worksheet Tools
8.1.    Moving between Worksheets
8.2.    Selecting Multiple Worksheets
8.3.    Inserting and Deleting Worksheets
8.4.    Renaming Worksheets
8.5.    Colouring Worksheet Tabs
8.6.    Copying or Moving Worksheets

Chapter 9 – Setting Worksheet Layout
9.1.     Using Page Break Preview
9.2.    Using the Page Layout View
9.3.     The Page Setup Dialog Box

Chapter 10 – Printing Worksheets
10.1    Previewing and Printing Worksheets – 2010 only
10.2.    Using Print Preview-2007 only
10.3.    Printing Worksheets-2007 only

Chapter 11 – Helping Yourself
11.1.    Using Excel Help







Prerequisites & Certificates
Pre-Requisites

Certificates offered

Certificate of completion


Cancellation Policy
A full 5 business days notice is required to change or cancel any course date.
Map & Reviews
Grade Learning Markham
[ View Provider's Profile ]

Reviews
 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1595 times.