Basic spreadsheet skills focusing on features in MS Excel such as basic functions, logic and reference functions, statistical functions, what-if analysis, and charting to solve complex business problems. No technical background is necessary.
Students must have access to Microsoft Excel and Microsoft Access to complete this course. There is an additional $69.99 fee for the required course material, MyEducator.com: Prometheus Series.
Lesson 1: Excel Basics
Lesson 2: Formulas and Functions
Lesson 3: Logic and Reference Functions
Lesson 4: Date, Time, and Text Functions
Lesson 5: Charting
Lesson 6: Modeling Basics
Lesson 7: Advanced Modeling
Lesson 8: Statistics
Lesson 9: No content
Lesson 10: Optimization Analysis
Lesson 11: Storing Data in Access