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
  • Name and Reference Cells
  • Protect Data
  • Templates
  • Advanced Functions
  • Create Charts
  • Create Tables
  • Work with Data Series
Outline
  • Section 1 - Templates
    • Opening a Template
    • Downloading a Template
    • Using a Template
    • Creating a Template
  • Section 2 - Security
    • Protecting your Workbook
    • Protecting your Worksheets
    • Unlocking Cells
  • Section 3 - Managing Tables
    • What is a Table?
    • Creating Tables
    • Modifying Tables
    • What is the Total Row?
    • What are Records and Fields?
    • Adding Fields by Inserting Columns
    • Adding Records by Inserting Rows
    • Quickly Adding Records to a Data Table
    • Deleting Records or Fields
    • Sorting Data in a Table
    • What is an AutoFilter?
    • Custom AutoFilters
    • Using an Advanced Filter
    • Copying Filtered Records
    • Filtering with Wildcard Characters
    • Validating Your Data
  • Section 4 - Charts
    • Creating a Chart
    • Formatting a Chart
    • Modifying Charts with the Layout Ribbon
    • Manipulating a Chart
    • Enhancing a Chart with Shapes and Graphics
    • Changing the Type of Chart
    • Changing the Source Data
    • Working with the Chart Axis and Data Series
    • Saving a Chart as a Template
  • Section 5 - Getting The Most Out Of Your Data
    • Using Automatic Outlining
    • Displaying and Collapsing Levels
    • Grouping Data Manually
    • Creating Subtotals
    • Linking Workbooks
    • What Are Range Names?
    • Defining and Using Range Names
    • Selecting Nonadjacent Ranges
  • Section 6 - Lists
    • Using Financial Functions (PMT)
      Using the IF Function
      Working with Nested Functions

Prerequisites & Certificates
Pre-Requisites

Microsoft Excel 2007/2010 Level 1 or equivalent experience

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
 
Maybe two day instead of one day. A lot to go over in one day.
Reviewed by 2015
Instruction seemed rather disjointed. Instructor's focus could have been better, along with his preparation. First off he couldn't get the projector to work, then couldn't find the examples he wanted to show. When asked a question, he veered off topic and then it was difficult to get back on track.
Reviewed by 2013
I did note body odour of presenter was strong. Only critisism I have. Everything else was excellent.
Reviewed by 2011
Excellent Excel 2 course, Alan is a very good instructor. I would take additional courses.
Reviewed by 2011
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 2576 times.