Excel 2007 Functions and Formulas

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.

Additional Details

Pre-Requisites

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   --- ---

Reviews

 

   

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 Linda H. 2011