In this Big Data Analytics with Excel training course, expert author Guy Vaccaro teaches you how to manage large quantities of data with Excel. This course is designed for users that are already familiar with Excel and how to navigate a workbook and manage worksheets.
You will start by learning basic data manipulation, then jump into learning about data cleansing, including removing duplicate records, replacing text, and merging and splitting data columns. From there, Guy will teach you about Excel tables, pivot tables, charts, and pivot charts. This video tutorial also covers Power Query, Power Map, and Power Pivot. Finally, you will learn how to use Goal Seek and Solver, as well as learn about data analysis tools.
Once you have completed this computer based training course, you will have learned everything you need to know to effectively manage large quantities of data with Excel. Working files are included, allowing you to follow along with the author throughout the lessons.
Course Curriculum
1. Introduction | |||
1.1. Introducing Excel Big Data | 00:00:00 | ||
1.2. About The Author | 00:00:00 | ||
1.3. Using The Working Files | 00:00:00 | ||
1.4. How To Access Your Working Files | 00:00:00 | ||
2. Basic Data Manipulation | |||
2.1. Fixing Headers For Screen And Print | 00:00:00 | ||
2.2. Sorting Data | 00:00:00 | ||
2.3. Filtering Data | 00:00:00 | ||
2.4. Add A Chart In A Second | 00:00:00 | ||
3. Data Cleansing | |||
3.1. Starting Out The Cleaning Process | 00:00:00 | ||
3.2. Removing Duplicate Records | 00:00:00 | ||
3.3. Changing The Case | 00:00:00 | ||
3.4. Replacing Text Method Part – 1 | 00:00:00 | ||
3.5. Replacing Text Method Part – 2 | 00:00:00 | ||
3.6. Removal Of Non Printing Characters And Spaces | 00:00:00 | ||
3.7. Numbers Standardized On Import And Export | 00:00:00 | ||
3.8. Dealing With Date And Time Issues | 00:00:00 | ||
3.9. Merging And Splitting Data Columns | 00:00:00 | ||
3.10. Rearranging Columns And Rows | 00:00:00 | ||
3.11. Comparing Multiple Datasets | 00:00:00 | ||
4. Excel Tables | |||
4.1. Creating A Table | 00:00:00 | ||
4.2. Formatting Made Easy | 00:00:00 | ||
4.3. Managing Rows And Columns | 00:00:00 | ||
4.4. Sorting And Filtering Table Data | 00:00:00 | ||
4.5. Using The Totals Row | 00:00:00 | ||
4.6. Adding A Calculated Column | 00:00:00 | ||
4.7. Adding Charts And Pivot Tables Using Table Data | 00:00:00 | ||
4.8. Data Entry And Editing Through A Form | 00:00:00 | ||
4.9. Filtering Using The Slicer | 00:00:00 | ||
4.10. Advanced Filtering | 00:00:00 | ||
4.11. External Data As A Table Source | 00:00:00 | ||
5. Pivot Tables | |||
5.1. Introducing Pivot Tables | 00:00:00 | ||
5.2. Recommended Pivot Tables | 00:00:00 | ||
5.3. Use Named Ranges And Rename Column Headings | 00:00:00 | ||
5.4. Change The Data Function And Format The Numbers | 00:00:00 | ||
5.5. Moving And Or Removing A Pivot Table | 00:00:00 | ||
5.6. The Report Filter Option | 00:00:00 | ||
5.7. Sorting And Filtering By Pivot Table Columns | 00:00:00 | ||
5.8. Refreshing A Pivot Table | 00:00:00 | ||
5.9. Drilldown Behind Pivot Table Numbers | 00:00:00 | ||
5.10. Using Pivot Table Styles | 00:00:00 | ||
5.11. Use Of Multiple Fields In Rows And Columns | 00:00:00 | ||
5.12. Grand And Sub Totals | 00:00:00 | ||
5.13. Filtering Columns And Rows Within A Pivot Table | 00:00:00 | ||
5.14. Exploring Additional Options | 00:00:00 | ||
5.15. Using The Data Slicer | 00:00:00 | ||
5.16. Connecting To A SQL Server Database | 00:00:00 | ||
5.17. Using External Connection Files | 00:00:00 | ||
6. Charts | |||
6.1. Creating And Using Charts | 00:00:00 | ||
6.2. Using Trendlines | 00:00:00 | ||
6.3. Dynamic Named Ranges | 00:00:00 | ||
6.4. Creating A Forecast Sheet | 00:00:00 | ||
6.5. Plotting On Two Axis | 00:00:00 | ||
7. Pivot Charts | |||
7.1. Creating A Pivot Chart | 00:00:00 | ||
7.2. Altering Chart Design And Location | 00:00:00 | ||
7.3. Filtering And Hiding Elements | 00:00:00 | ||
8. Power Query | |||
8.1. Introducing Get And Transform The New Power Query | 00:00:00 | ||
8.2. Making The Most Of The Query Editor | 00:00:00 | ||
8.3. Using The Query Editor To Group Or Combine | 00:00:00 | ||
8.4. Using An Odata Feed And Merging Data | 00:00:00 | ||
8.5. Using Google Sheets As Your Source Data | 00:00:00 | ||
8.6. Connecting To Using And Combining Webpage Data | 00:00:00 | ||
8.7. Connecting To And Using Data From Facebook | 00:00:00 | ||
8.8. SQL Server Data Connections | 00:00:00 | ||
8.9. Get And Transform Data From Multiple Files In A Folder | 00:00:00 | ||
9. Power Map | |||
9.1. Activating And Creating Your First 3D Power Map | 00:00:00 | ||
9.2. A Simple Map Alternative To 3D Power Map | 00:00:00 | ||
9.3. Tours Scenes And Layers | 00:00:00 | ||
9.4. Create A Tour And Customize A Layer | 00:00:00 | ||
9.5. Displaying Additional Data With Additional Layers | 00:00:00 | ||
9.6. Adding And Animating Scenes | 00:00:00 | ||
9.7. Filtering Data Within A Layer And Scene | 00:00:00 | ||
9.8. Customization Options | 00:00:00 | ||
9.9. Exporting Images And Videos Of Your 3D Map Tour | 00:00:00 | ||
10. Power Pivot | |||
10.1. Introducing Power Pivots | 00:00:00 | ||
10.2. Importing Data And Adding Additional Data To The Data Model | 00:00:00 | ||
10.3. Adding Tables To The Data Model And Creating Relationships | 00:00:00 | ||
10.4. Powerpivot Pivotstables And Pivotcharts | 00:00:00 | ||
10.5. Adding Calculated Fields To Your Data Model | 00:00:00 | ||
10.6. Measures And KPIs In Your Powerpivot | 00:00:00 | ||
11. Goal Seek And Solver | |||
11.1 Use Goal Seek To Carry Out What If Analysis | 00:00:00 | ||
11.2. Installing And Uninstalling Solver | 00:00:00 | ||
11.3. Use Solver To Carry Out What If Analysis | 00:00:00 | ||
11.4. Using Scenarios | 00:00:00 | ||
11.5. Adding Constraints To Solver | 00:00:00 | ||
12. Data Analysis Tools | |||
12.1. Introducing The Analysis Toolpack | 00:00:00 | ||
12.2. Calculating And Graphing The Moving Average | 00:00:00 | ||
12.3. Creating A Histogram With A Bell Curve | 00:00:00 | ||
13. The End | |||
13.1. Sharing Your Big Data | 00:00:00 | ||
13.2. Resume | 00:00:00 |
Course Reviews
No Reviews found for this course.