VTC Legacy
Home / Project Management

Analytics in Excel

by Lauri Sowa
99 lessons20 chapters6.9 hReleased 201515 free
Start the free chapter

In today's world, we must navigate through a sea of data and simplify it into decisions for growth, problem solving, and success. By learning the data-analysis techniques and features of Microsoft excel we can master the fast growing world of Analytics.rnrnMicrosoft Excel is the most common analysis software on the market today, but few users are aware of its full powers. In this advanced course, users will master the tasks necessary in order to handle today's complex data sets, including data validation, data analysis, charting, and design. rnrn* Learn how to use Excel and your data to support decision makingrn* Master functions and calculations that streamline your analysisrn* Simplify statistics through the use of Excels analysis featuresrn* Learn to automate repetitive tasks and quickly spot patternsrn* Translate your analysis into meaningful charts and graphs

Course content

Introduction2 lessons
Analytics for Decision Making8 lessons
Excel Tools5 lessons
Data Validation5 lessons
Charts and Graphs6 lessons
Trend lines4 lessons
Tables and Ranges6 lessons
Understanding Plugins and Add Ins3 lessons
Data Analysis Tools5 lessons
What if Analysis8 lessons
Data Tables4 lessons
Pivot Tables6 lessons
Conditional statements5 lessons
Dashboards4 lessons
Automation6 lessons
Report Writing7 lessons
Presenting Data8 lessons
Comments and Review4 lessons
Review2 lessons
About the Author1 lessons