Microsoft Excel: Formulas
Description: Excel has hundreds of functions and nobody knows them all, but spend some time and learn to create more powerful formulas.
Students will dive into decision making functions like if() and lookup() and make Excel work for them! Students will also explore efficient use of multiple sheets in a workbook, creating multi-sheet and multi-workbook formulas. Students will learn about: if() functions, lookup() functions, conditional formatting, and using multiple worksheets in a workbook.
1.Course objectives.
a.To provide the class with an exploration of spreadsheet design.
b.To develop computer and spreadsheet literacy.
c.To address the class’ questions.
2.Schedule
a.9:00 Registration
b.9:30 Morning session
c.12:00 Departure
3.Handouts available in Adobe Portable Document Format (PDF) for download at www.crowleycomputers.com/handouts.htm
…
Download Microsoft Excel: Formulas.pdf
