VTC Legacy
Home / Business Applications

Excel and Big Data

by Lauri Sowa
92 lessons20 chapters7 hReleased 201513 free
Start the free chapter

Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected.rnrnLearn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools.rnrnUnderstand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports.rnrnThis course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.

Course content

Introduction2 lessons
What is Big Data?5 lessons
Reviewing the Basics6 lessons
Pivot Tables5 lessons
PowerPivot6 lessons
Working with PowerPivot DAX3 lessons
Dynamic Charting5 lessons
Interpreting and Summarizing Data7 lessons
Matching Functions5 lessons
Functions for Manipulating Text3 lessons
Data Cleaning4 lessons
Arrays4 lessons
Macros9 lessons
VBA6 lessons
Custom Functions4 lessons
Auditing and Other Features4 lessons
Analysis Tools5 lessons
Scenarios4 lessons
Dashboards4 lessons
About the Author1 lessons