Course Description:
Learn Excel from the comfort of your office or home.
Do you have a need to create calculations in a spreadsheet but just don't know where to start? Have you struggled creating basic formulas yourself? If so, this class is for you!
This two-hour Live Instructor-led course will give you the fundamentals for creating formulas in Excel and will include many shortcuts for building formulas. This course is good for anyone that needs to understand and create formulas.
Prerequisites
A basic knowledge of Excel.
Course Outline:
- Create basic formulas
- Build a formula using functions
- Use the autosum button
- Calculate data on another worksheet or workbook
- Use autofill with formulas
- Use absolute vs. relative cell references
- Create a multiple sheet formula