Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4

The topics that will be discussed in this course include Overview of All the Relevant Tabs in the Ribbon, Work with Formulas and Functions, Analyzing the Data, Charting, and Save and Print.

Course Outline
Course Outline

Module 1: Understanding Formulas

  • What Is a Formula
  • Review Basic Concepts
  • Displaying Formulas in Cells
  • Relative and Absolute Cell References
Module 2: Understanding Functions
  • What Is a Function
  • What Are Arguments
  • Finding the Right Functions
  • Inserting Functions
Module 3: Overview Defining Functions And What They Do
  • If Functions
  • Trig Functions
  • Lookup Functions
  • Statistical Functions
  • Information Functions
  • Engineering Functions
  • Financial Functions
  • Excel If Functions
  • Nested Functions
  • Using Labels in Excel Formulas and Functions
  • Count Functions
  • Date Functions
  • Logical Functions
  • Math Functions
  • Text Functions
  • Rounding Number Functions
  • Excel 2003 Functions
  • Random Number Functions
Module 4: Formulas And Functions
  • Using the Autosum
  • Using the Insert Function
Module 5: Financial Functions
  • The Pmt Function
  • The Fv Function
  • The Nper Function
Module 6: Text Functions
  • Using the Concatenate Function
Module 7: Logical Functions
  • Using a Basic If Function
  • Using Nested If Function with And
  • Using Nested If Function with Or
Module 8: Date Functions
  • Using the Today Function
  • Calculating Differences Between Dates
Module 9: Lookup Functions
  • Using the Vlookup Function
  • Using the Hlookup Function
Module 10: Statistical Functions
  • Using the Counta Function
  • Using the Countif Function
  • Using the Countifs Function
Module 11: Auditing Formulas
  • Using the Formula Auditing Tools
Module 12: Working with Names and Ranges
  • What Are Range Names
  • Defining and Using Range Names
  • Defined Names Commands
  • Using Autocalculate
Module 13: Working with Array Formulas
  • What Are Array Formulas
  • Defining Basic Array Formulas
  • Using Functions Within Array Formulas
Module 14: Conditional Formatting and Rules
  • Using Conditional Formatting
  • Using Existing Rules
  • Creating New Rules
  • Managing Rules
Module 15: What-if Analysis
  • Using Goal Seek
  • Using Data Tables
Module 16: Working with Charts (optional)
  • Creating a Chart
  • Formatting the Data Series
  • Adding Data - Different Worksheets
  • Using a Secondary Axis
  • Changing Data Series Chart Types
  • Adding a Trendline
  • Changing the Type of Chart
  • Styling Charts with the Design Tab
  • Modifying Charts with the Layout Tab
  • Additional Styling with the Format Tab
  • Manipulating a Chart
  • Working with Gridlines
  • Formatting An Axis
  • Changing the Axis Scaling
Module 17: Lab

Prerequisites & Certificates

Certificates offered

Certificate of Completion

Cancellation Policy
For courses bought at the regular price 10 Business days are required for cancellations.
For courses bought at the 'last-minute' price - all Registration are final
Map & Reviews
CBIT Training Ottawa
[ View Provider's Profile ]


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

I would recommend this vendor, with cautions. The course content did not nearly cover everything listed in the course description. The course started late and finished early, the instructor did not follow the course materials at all, and many topics that were supposed to be covered were not. Hopefully they are in the course book and I will be able to work through it on my own. I haven't had time to go through the book yet, and we didn't use it in the course. The material that was presented was good, but the instructor's knowledge was limited.
Reviewed by 2012
The Teacher really explained every topic very well and kept us very interested. She was a wonderful teacher.
Reviewed by 2012
I registered for the Access level two after already taking the level one last week thinking that it would be a continuation of what I learned in level one. This was not the case, it was all the same material as in level one. I don't understand how this can happen at the same school. I felt that the level two was really a waste of my time and mostly money.
Reviewed by 2012
I found there was too much theory. Hard to follow the second day. Should be more theory day 1 and then plenty more exercises Day 2.
Reviewed by 2012
Location isn't the greatest, but I had a good instructor, great computers to work with and relevant exercises. I would go back for more courses.
Reviewed by 2012
The instructor was very knowledgeable and accommodating. The presentation material and CD was excellent.
Reviewed by 2012
Trainer was good. Gave explanation WHY things are done in specific order. Not just "do this, do that"
Reviewed by 2012
This is my second workshop with CBIT. The facilities and ammenities offered are exceptional. Administrative staff are very friendly, helpful and eager to assist. Course content and quality of instruction have more than met with my needs and expectations. I am very confident in their ability to provide quality programming and have already recommended them to others in my organization.
Reviewed by 2011
Course was fantastic and the instructor very knowledgeable and well organized. Due to a small class size, she was able to customize the course content to meet our individual training needs. In addition, CBIT provided each of us with the complete Org Plus manual which will be very handy as a reference tool back in the workplace. CBIT staff were welcoming and friendly - and served a hot breakfast at 10:00 am! There is also a fridge, microwave and break room avail. Not many great restaurants in the area, so better to pack your lunch. Overall, a great day.
Reviewed by 2011
We were provided a cd with a pdf copy of the manual for future reference which is great but no printed manual was provided to refer to during the course - this would have been helpful for learning.
Reviewed by 2011

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 934 times.