Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4

Learn the fundamentals of creating and working with formulas and functions. Start by building a simple formula and move to more advanced functions such as SUM, PMT, and IF. Also, create formulas that contain 3-D references.

Course Outline

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.

  • Type formulas that contain functions directly in a cell.

  • Copy formulas to other cells.

  • Understand the difference between and implications of relative and absolute references.

  • Create logical (if/then) statements.

  • Create formulas that span across multiple workbook pages.

This course can ALSO be taught one-on-one or as a private, dedicated virtual classroom - call 877-313-8881 for more information.
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 ]

The trainer explained everything in a simple way and gave us the right amount of time to try everything ourselves as well. She had a friendly attitude and also paused from time to time to ask us if we had any questions. All in all a good experience.
Reviewed by 2012
I liked the virtual training. So much easier to fit into my schedule. Did miss the interaction though. There were very little questions asked in both this one and the Powerpoint one. In the Excel presentation, I really liked that the trainer muted everyone. This wasn't the case with the power point one. There were baby noises in the background. Very disruptive and inconsiderate.
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 2289 times.