Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Microsoft Office Excel contains powerful tools to help you analyze, manage, and share critical business data. Our latest version also lets you work more efficiently in teams, while helping to protect and control access to sensitive information.


 
Course Outline
Microsoft Office Excel contains powerful tools to help you analyze, manage, and share critical business data. Our latest version also lets you work more efficiently in teams, while helping to protect and control access to sensitive information.

Objectives
  • Navigate worksheets, document windows, and the application window
  • Manage and manipulate Excel files
  • Edit data
  • Work with ranges
  • Create simple formulas
  • Use built-in Excel functions
  • Cut, copy, and paste data
  • Format column width, row height, fonts, styles, borders and shading, data type and alignment
  • Print worksheets
Outline
  • Section 1 - Getting Started
    • What is Microsoft Excel 2010?
    • Opening Microsoft Excel
    • Exploring the Excel User Interface
    • Closing Excel
    • Using the Help Screen
    • About Online Help
    • About Offline Help
  • Section 2 - Spreadsheet Basics
    • The Zoom Feature
    • Moving Around a Worksheet
    • Selecting Cells
    • Columns, Rows, and Ranges
    • Entering and Deleting Data
    • Using Undo and Redo
    • AutoFill and Complete
    • Dragging and Dropping Cells
    • Cut, Copy, and Paste Cells
    • Insert and Delete Cells, Rows, and Columns
    • What Are Smart Tags?
    • The Error Option Button
    • The AutoFill Option Button
    • The Paste Option Button
    • Setting Smart Tag Options
    • Creating a New Workbook
    • Opening a Workbook
    • Saving a Workbook
    • About Excel File Types
    • Closing a Workbook
  • Section 3 - Functions and Formulas
    • Basic Mathematical Operators
    • Working with Basic Formulas
    • Using Formulas with Multiple Cell References
    • Relative and Absolute Cell References
    • Fixing Formula Errors
    • Displaying and Printing Formulas
    • What are Functions?
    • Finding the Right Function
    • Some Useful and Simple Functions
    • Using AutoSum
  • Section 4 - Editing Your Workbook
    • Changing the Size of Rows or Columns
    • Adjusting Cell Alignment
    • Rotating Text
    • Creating Custom Number and Date Formats
    • The Format Painter
    • Cell Merging and AutoFit
    • Adding Patterns and Colors
    • Adding Borders
    • Working with Styles
  • Section 5 - Viewing your Workbook
    • Using the View Ribbon
    • Using Normal View
    • Using Full Screen View
    • Using Page Layout View
    • Page Break Preview
    • Managing a Single Window
    • Creating a New Window
    • Freezing a Pane
    • Managing Multiple Windows
    • Switching Between Open Workbooks
    • Arranging Workbooks
    • Comparing Workbooks Side by Side
    • Synchronous Scrolling, Resetting a Window, and Saving a Workspace
  • Section 6 - Printing Your Spreadsheet
    • Opening Print Preview
    • Using the Print Preview Ribbon
    • Quick Printing
    • The Print Dialogue
    • Using Page Setup

Prerequisites & Certificates
Pre-Requisites

* A thorough understanding of the Windows operating environment * Strong mouse and keyboard ability

Certificates offered

Certificate of Completion


Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
Map & Reviews
On Track Computer Training
[ View Provider's Profile ]

Reviews
 
Other students slowed down the course, not the instructors fault.
Reviewed by 2013
Instructor was extremely patient and understanding with a room full of different levels. He explained well and added humour to a long day - thank you!
Reviewed by 2013
Only suggestion I would make it that more time should be spent on some aspects to ensure everyone has a complete grasp of the concepts. Some attendees had difficulty in keeping up with the instructor's coverage of the material.
Reviewed by 2013
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 2810 times.