Spreadsheet Skills and Business Analysis
Description: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.
Course Content: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
Online Courses:Course materials are accessed online, and all assignments must be submitted online. Optional course readings may be available but do not include the self-check assignments or graded assignments.
Notes: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.
No Materials required for this course!