Learn: in:
» back to Search Results

Course rating of 3 Vendor rating of 4

In thiw course, learn the fundamentals of creating and working with formulas and functions.

  • Course Start Date: Dec. 6
  • Location: Virtual (Map)
  • Time: 11:30 am - 1:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 90 minutes
    11:30 AM - 1:00 PM EST
  • Delivery Method(s):Virtual Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

Course Outline

Learn the fundamentals of creating and working with formulas and functions. Start by building and copying simple formulas. Then learn to use functions such as SUM, AVERAGE, PMT, ROUND, TODAY, and NETWORKDAYS. Also understand the difference between relative and absolute cell references, create grand totals, and work with formulas that contain 3-D references.

Course Description

Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 300+ built-in Excel functions? Do you want to learn how to efficiently create worksheets that update automatically?

Attend this course if you want to:

Understand the difference between functions and formulas.
Understand formula operators and order of operation.
Learn how to use cell references.
Create and edit formulas.
Use a built-in function.
Use AutoSum to automatically sum data.
Sum subtotals to create a grand total.
Access other functions from the Function dialog box or the Formulas tab.
Understand the difference between and implications of relative and absolute references.
Round values for calculations.
Use date and time functions.
Create formulas that span across multiple workbook pages.
Prerequisites & Certificates

Comfortable with basic Excel capabilities.

Certificates offered

Certificate of Completion

Cancellation Policy
If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.

Map & Reviews
Elert & Associates Technology Training
[ View Provider's Profile ]

On Line Instructor Led
Your Home or Office
Your City, Your Province
Your Country   --- ---

No rating was given for items that didn't apply. The flow of the course was great. Questions were answered fully. Danielle was knowledgeable, spoke clearly, and at a ideal speed. She left time for questions after every worksheet and made sure everyone was ready before moving on to next topic.
Reviewed by 2014
6-December-2016 $68 Regular Price $85 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!

This course currently does not have any dates other than this one scheduled. Please call 1-877-313-8881 to enquire about future dates.

Not interested in this Course?

Tell us why:

This page has been viewed 26 times.