In thiw course, learn the fundamentals of creating and working with formulas and functions.
- 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 ]
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 2545 times.