Skip to main content

City of Madison


Microsoft Excel 1: Beginner- Functions & Formulas

Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 450+ 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.

No upcoming dates for this event