In thiw course, learn the fundamentals of creating and working with formulas and functions.
- Course Start Date: Oct. 25
- Location: Virtual
- Time: 4:00 pm - 5:30 pm (Note on end times)
- Duration: 90 minutes
4:00 PM - 5:30 PM EST
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.
- Delivery Method(s):Virtual Instructor Led
- Discount Seats Available:2
- Category:Microsoft Excel Training
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.
- 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.
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.
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 --- ---
Registration for this course has been closed.
This course may be available on a different date listed below.
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 7 times.