
Excel and Big Data
by Lauri Sowa
Start the free chapterMicrosoft 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
- Getting Started with Macros5:481 credit or ad
- Enhancing Usage and Automation4:051 credit or ad
- Absolute vs Relative5:091 credit or ad
- Viewing the Macro in VBA4:291 credit or ad
- Invoking macros with Form controls5:181 credit or ad
- Forms continued6:341 credit or ad
- Option Buttons3:011 credit or ad
- Security2:311 credit or ad
- R1C1 Reference4:221 credit or ad