Formulas are part of the power of Excel! Formulas can be used for many needs from calculating values to combining text columns together as one and much more!
There are many categories of functions within Excel each with powerful benefits. The outline below lists the topics that you will cover in this hands-on four-hour workshop. A computer and textbook will be in place for each person.
The course will start off with a brief review of formula rules, creating and editing formulas, afterwards on to more in-depth formula creation.
- Formula rules
- Creating basic function formulas (SUM and AVERAGE)
- Relative versus Absolute cell referencing
- Editing formulas
- What are range names?
- Creating range names
- Using range names
- Editing range names
- CONCATENATE
- PROPER
- LOWER
- UPPER
A minimum knowledge in creating and modifying spreadsheets is required. Attendees must know how to insert rows, columns and cut, copy, and paste. |
