Torrent Contents Size: 27.65 GB
Maven Analytics - Excel Specialist
|
|
Excel MO-201 Exam Prep
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
1. About the MO-201 Exam
|
|
1. Exam Structure Video
|
|
|
2. Objective Domains - Skills Measured Video
|
|
|
3. Exam Interface - Scheduling Video
|
|
|
4. Helpful Resources Video
|
|
|
|
2. The Course Project
|
|
1. Course Project Intro Video
|
|
|
2. The Airbnb Dataset Video
|
|
|
|
3. Advanced Formulas - Macros
|
|
1. Objective Domain Intro Video
|
|
|
10. The COUNTIF-SUMIF-AVERAGEIF Functions Video
|
|
|
11. COUNTIFS-SUMIFS-AVERAGEIFS for Multiple Criteria Video
|
|
|
12. The MINIFS - MAXIFS Functions Video
|
|
|
13. Excel Date Values - Formatting Video
|
|
|
14. PRO TIP- Converting Text to Dates Video
|
|
|
15. The TODAY - NOW Functions Video
|
|
|
16. YEAR-MONTH-DAY - HOUR-MINUTE-SECOND Video
|
|
|
17. WEEKDAY- WORKDAY - NETWORKDAYS Video
|
|
|
18. Recording a Macro Video
|
|
|
19. Modifying - Deleting Macros Video
|
|
|
2. Fixed vs. Relative References Video
|
|
|
20. PRO TIP- Adding Form Controls Video
|
|
|
21. Lookup Functions Video
|
|
|
22. The VLOOKUP - HLOOKUP Functions Video
|
|
|
23. The INDEX Function Video
|
|
|
24. The MATCH Function Video
|
|
|
25. Combining INDEX - MATCH Video
|
|
|
26. Approximate Match Lookups Video
|
|
|
27. The PMT - NPER Functions Video
|
|
|
28. Scenario Manager Video
|
|
|
29. Consolidate Data Video
|
|
|
3. Explicit vs. Structured References Video
|
|
|
30. Goal Seek Video
|
|
|
31. Formula Auditing Video
|
|
|
4. Logical Operations Video
|
|
|
5. The IF Function Video
|
|
|
6. Nested IF Functions vs. The IFS Function Video
|
|
|
7. The NOT - “--” Operators Video
|
|
|
8. The AND-OR Operators Video
|
|
|
9. The SWITCH Function Video
|
|
|
|
4. Manage - Format Data
|
|
1. Objective Domain Intro Video
|
|
|
10. Formula-based Conditional Formatting Video
|
|
|
11. Managing Conditional Formatting Rules Video
|
|
|
12. PRO TIP- Hiding Values to Create Heatmaps Video
|
|
|
2. Custom Number Formats Video
|
|
|
3. Data Validation Video
|
|
|
4. Group - Ungroup Data Video
|
|
|
5. Subtotals - Totals Video
|
|
|
6. Removing Duplicates Video
|
|
|
7. Auto Fill - Flash Fill Video
|
|
|
8. Advanced Fill Series Options Video
|
|
|
9. Conditional Formatting Video
|
|
|
|
5. Advanced Charts - Tables
|
|
1. Objective Domain Intro Video
|
|
|
10. Modifying Pivot Table Views Video
|
|
|
11. -Summarize Values By- Options Video
|
|
|
12. -Show Values As- Calculations Video
|
|
|
13. Analyze - Design Tabs Video
|
|
|
14. Report Layouts - Options Video
|
|
|
15. Number Formatting Video
|
|
|
16. Sorting - Filtering Video
|
|
|
17. Slicers - Timelines Video
|
|
|
18. Grouping Text Fields Video
|
|
|
19. Grouping Numerical Fields Video
|
|
|
2. Box - Whisker Chart Video
|
|
|
20. Grouping Date Fields Video
|
|
|
21. Calculated Fields Video
|
|
|
22. Calculated Items Video
|
|
|
23. Pivot Charts Video
|
|
|
24. Pivot Chart Formatting Video
|
|
|
25. Expanding - Collapsing Pivot Charts Video
|
|
|
3. Histogram Video
|
|
|
4. Filled Map Video
|
|
|
5. Combo Chart Video
|
|
|
6. Tree Map - Sunburst Chart Video
|
|
|
7. Waterfall Chart Video
|
|
|
8. Funnel Chart Video
|
|
|
9. Creating a Pivot Table Video
|
|
|
|
6. Workbook Options - Settings
|
|
1. Objective Domain Intro Video
|
|
|
10. Language Options Video
|
|
|
2. Enabling Macros Video
|
|
|
3. Copying Macros to Other Files Video
|
|
|
4. Linking Data Across Workbooks Video
|
|
|
5. Protecting Worksheets - Cell Ranges Video
|
|
|
6. Protecting - Encrypting Workbooks Video
|
|
|
7. Recovering Workbooks Video
|
|
|
8. Managing Comments Video
|
|
|
9. Formula Calculation Modes Video
|
|
|
|
7. Practice Test
|
|
1. Practice Test Intro Video
|
|
|
3. Practice Test Structure Video
|
|
|
4. SOLUTION- Project 1 Video
|
|
|
5. SOLUTION- Project 2 Video
|
|
|
6. SOLUTION- Project 3 Video
|
|
|
7. SOLUTION- Project 4 Video
|
|
|
8. SOLUTION- Project 5 Video
|
|
|
9. SOLUTION- Project 6 Video
|
|
|
|
8. Feedback Survey - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Excel Pro Tips- Analytics
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
1. Analytics Tips
|
|
1. Introduction Video
|
|
|
10. CUBE Functions Video
|
|
|
11. Monte Carlo Simulation Video
|
|
|
12. Advanced Optimization with Solver Video
|
|
|
13. Analysis ToolPak -Preview- Video
|
|
|
2. Quick Analysis Tools Video
|
|
|
3. Scenario Manager Video
|
|
|
4. Optimization with Goal Seek Video
|
|
|
5. Basic Forecasting Video
|
|
|
6. Outlier Detection Video
|
|
|
7. Automated Data Tables Video
|
|
|
8. Power Query Tools Video
|
|
|
9. Data Modeling 101 Video
|
|
|
|
2. Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Excel Pro Tips- Data Visualization
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
1. Visualization Tips
|
|
1. Introduction Video
|
|
|
10. Goal Pacing with Gauge Charts Video
|
|
|
11. Highlighting Time Periods Video
|
|
|
12. Dynamic Source Ranges Video
|
|
|
13. Interactive Form Controls Video
|
|
|
2. Chart Properties -Move - Size- Video
|
|
|
3. Hidden Chart Source Data Video
|
|
|
4. Filled Maps -Excel 2016-- Video
|
|
|
5. Customizing Charts to Tell a Story Video
|
|
|
6. Adding Sparklines Video
|
|
|
7. Custom Chart Templates Video
|
|
|
8. Heat Maps with Color Scales Video
|
|
|
9. Analyzing Distribution with Histograms Video
|
|
|
|
2. Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Excel Pro Tips- Formatting
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
1. Formatting Tips
|
|
1. Introduction Video
|
|
|
10. Zip Codes - Phone Numbers Video
|
|
|
11. Grouping Columns - Rows Video
|
|
|
12. Formatting Errors with IFERROR Video
|
|
|
13. Converting Text to Date Values Video
|
|
|
14. Formula-Based Formats Video
|
|
|
15. Advanced Number Formats Video
|
|
|
2. Formatting Shortcuts Video
|
|
|
3. Snap to Grid Video
|
|
|
4. Hiding Workbook Elements Video
|
|
|
5. Format Painter Video
|
|
|
6. Color - Border Design Video
|
|
|
7. Freezing Panes Video
|
|
|
8. Center Across Selection Video
|
|
|
9. Invisible Text Formatting Video
|
|
|
|
2. Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Excel Pro Tips- Formulas
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
1. Formula Tips
|
|
1. Introduction Video
|
|
|
10. Hyperlinking Between Worksheets Video
|
|
|
11. -Fuzzy Match- Lookups Video
|
|
|
12. Random Selection with OFFSET - RANDBETWEEN Video
|
|
|
13. Combining INDEX - MATCH Video
|
|
|
14. Matching Items Between Lists Video
|
|
|
15. Counting Duplicates with SUMPRODUCT Video
|
|
|
16. Many-to-Many Lookups Video
|
|
|
2. Manual vs. Automatic Calculation Video
|
|
|
3. Formula Line Breaks Video
|
|
|
4. Converting Units of Measurement Video
|
|
|
5. Real-Time Tools with TODAY - NOW Video
|
|
|
6. Formula Auditing Tools Video
|
|
|
7. Pivot-Style Reports with Formulas Video
|
|
|
8. Counting Words in a Cell Video
|
|
|
9. Dependent Drop-Downs with INDIRECT Video
|
|
|
|
2. Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Excel Pro Tips- Pivot Tables
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
1. PivotTable Tips
|
|
1. Introduction Video
|
|
|
10. Showing Empty Items Video
|
|
|
11. Configuring Slicers - Timelines Video
|
|
|
12. Conditional Formatting Video
|
|
|
13. Removing - Reviving Source Data Video
|
|
|
14. Adding Custom Sort Lists Video
|
|
|
15. Solve Order - List Formulas Video
|
|
|
2. Customizing the Field List Video
|
|
|
3. Autofitting Column Width Video
|
|
|
4. Outline - Tabular Layouts Video
|
|
|
5. Counting Non-Numerical Fields Video
|
|
|
6. Grouping Dates Video
|
|
|
7. Enabling Multiple Filters Video
|
|
|
8. Grouping Values Video
|
|
|
9. Adding Value Calculations Video
|
|
|
|
2. Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Excel Pro Tips- Productivity
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2. Course Structure & Outline
|
|
|
3. Setting Expectations Video
|
|
|
|
1. Productivity Tips
|
|
1. Introduction Video
|
|
|
10. Splitting Text to Columns Video
|
|
|
11. Synchronous Scrolling Video
|
|
|
12. Extracting Unique Values Video
|
|
|
13. Named Range - Table References Video
|
|
|
14. Protecting Cells - Formulas Video
|
|
|
15. Multi-Level Row - Column Sorting Video
|
|
|
16. Advanced Filter Criteria Video
|
|
|
2. Customizing the Footer Video
|
|
|
3. CTRL Shortcuts Video
|
|
|
4. ALT Key Tips Video
|
|
|
5. -Go To- Special Options Video
|
|
|
6. Removing Blank Rows Video
|
|
|
7. Data Validation Drop-Downs Video
|
|
|
8. Autofill - Flash Fill Video
|
|
|
9. Customizing the Ribbon Video
|
|
|
|
2. Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Maven Analytics - DATA PLAYGROUND (Test & Work Assignment)
|
|
120 years of Olympic History
|
|
|
Airline Flight Delays
|
|
|
Inc 5000 Companies
|
|
|
Jordan & LeBron Career Stats
|
|
|
Madrid Daily Weather
|
|
|
Marketing Campaign Results
|
|
|
Movie Ratings
|
|
|
NYC Traffic Accidents
|
|
|
New Year's Eve Resolutions
|
|
|
Online Chess Games
|
|
|
S&P 500 Stock Prices
|
|
|
Shark Attacks
|
|
|
Spotify Top 100
|
|
|
UFO Sightings
|
|
|
Wine Tasting
|
|
|
World Cup
|
|
|
|
Microsoft Excel- Charts - Graphs
|
|
0. Orientation - Benchmark Assessment
|
|
1. Welcome to the Course- Text
|
|
|
|
1. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
2. Data Visualization Best Practices
|
|
1. Key Data Viz Principles - the 10-Second Rule Video
|
|
|
2. The Good- the Bad- and the Ugly Video
|
|
|
3. The 3 Key Questions Video
|
|
|
|
3. Customizing Charts in Excel
|
|
1. Chart Elements- Layouts- Colors - Styles Video
|
|
|
2. Chart Formatting Options Video
|
|
|
3. Changing Chart Types - Adding a Secondary Axis Video
|
|
|
4. Creating- Modifying - Applying Custom Templates Video
|
|
|
|
4. Mastering Basic Charts - Graphs
|
|
1. Bar - Column Charts Video
|
|
|
10. HOMEWORK- Pies- Donuts - Race Tracks Text
|
|
|
11. Scatter Plots Video
|
|
|
12. Bubble Charts Video
|
|
|
13. HOMEWORK- Scatter Plots - Bubble Charts Text
|
|
|
14. Box - Whisker Charts -Office 365-2016-- Video
|
|
|
15. HOMEWORK- Box - Whisker Charts Text
|
|
|
16. Tree Maps - Sunburst Charts -Office 365-2016-- Video
|
|
|
17. HOMEWORK- Tree Maps - Sunburst Charts Text
|
|
|
18. Waterfall Charts -Office 365-2016-- Video
|
|
|
19. Funnel Charts -Office 365-2016-- Video
|
|
|
2. HOMEWORK- Bar - Column Charts Text
|
|
|
20. HOMEWORK- Waterfall - Funnel Charts Text
|
|
|
21. Radar Charts Video
|
|
|
22. HOMEWORK- Radar Charts Text
|
|
|
23. Stock Charts Video
|
|
|
24. HOMEWORK- Stock Charts Text
|
|
|
25. Heat Maps Video
|
|
|
26. HOMEWORK- Heat Maps Text
|
|
|
27. Surface - Contour Charts Video
|
|
|
28. HOMEWORK- Surface - Contour Charts Text
|
|
|
29. Geo-Spatial Maps with Power Map Video
|
|
|
3. Histogram - Pareto Charts -Office 365-2016-- Video
|
|
|
30. HOMEWORK- Power Map Text
|
|
|
31. Basic Combo Charts Video
|
|
|
32. HOMEWORK- Combo Charts Text
|
|
|
33. Sparklines Video
|
|
|
34. HOMEWORK- Sparklines Text
|
|
|
4. HOMEWORK- Histogram - Pareto Charts Text
|
|
|
5. Line Charts - Trendlines Video
|
|
|
6. HOMEWORK- Line Charts - Trendlines Text
|
|
|
7. Area Charts Video
|
|
|
8. HOMEWORK- Area Charts Text
|
|
|
9. Pies- Donuts - Race Tracks Video
|
|
|
|
5. Next-Level Data Visualization Exercises
|
|
1. Setting Expectations Video
|
|
|
10. DEMO- Dynamically Highlighting a Data Series Video
|
|
|
11. DEMO- Building a Custom Pacing Chart Video
|
|
|
12. DEMO- Designing a Custom Gauge Chart Video
|
|
|
13. DEMO- Visualizing a Percentage Using Array Functions Video
|
|
|
2. DEMO- Custom Image Overlay Charts Video
|
|
|
3. DEMO- Adding Binary Values to Highlight Date Ranges Video
|
|
|
4. DEMO- Automation with OFFSET- COUNTA - Named Ranges Video
|
|
|
5. DEMO- Adding Scroll - Zoom Functionality with Form Controls Video
|
|
|
6. DEMO- Animating Changes Over Time Video
|
|
|
7. DEMO- Building a Dynamic Dashboard -Part 1- Video
|
|
|
8. DEMO- Building a Dynamic Dashboard -Part 2- Video
|
|
|
9. DEMO- Value-Based Dynamic Formatting Video
|
|
|
|
7. Final Assessment - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Microsoft Excel- Formulas - Functions
|
|
0. Orientation - Benchmark Assessment
|
|
1. Welcome to the Course- Text
|
|
|
|
1. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
|
10. Bonus Functions
|
|
1. Introduction Video
|
|
|
2. The INDIRECT Function Video
|
|
|
3. The HYPERLINK Function Video
|
|
|
4. WEBSERVICE - FILTERXML Demo- Weather Underground Video
|
|
|
5. WEBSERVICE - FILTERXML Demo- Open Weather Map Video
|
|
|
|
12. Final Assessment - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
2. Excel Formulas 101
|
|
1. Introduction Video
|
|
|
10. PRO TIP- Data Validation Video
|
|
|
11. Congrats- You-re a Developer- Video
|
|
|
13. HOMEWORK- Formulas 101 Video
|
|
|
2. Formula Syntax Video
|
|
|
3. Fixed - Relative References Video
|
|
|
4. Common Error Types Video
|
|
|
5. Formula Auditing- Trace Precedents - Dependents Video
|
|
|
6. Formula Auditing- Evaluate Formula - Error Checking Video
|
|
|
7. Ctrl Shortcuts Video
|
|
|
8. Function Shortcuts Video
|
|
|
9. Alt Key Tips Video
|
|
|
|
3. Conditional - Logical Operators
|
|
1. Introduction Video
|
|
|
2. Anatomy of the IF Statement Video
|
|
|
3. Nested IF Statements Video
|
|
|
4. AND-OR Operators Video
|
|
|
5. NOT vs. ---- Video
|
|
|
6. Fixing Errors with IFERROR Video
|
|
|
7. Common IS Statements Video
|
|
|
9. HOMEWORK- Logical Operators Video
|
|
|
|
4. Statistical Functions
|
|
1. Introduction Video
|
|
|
10. PRO TIP- Data Profiling with COUNT - SUMPRODUCT Video
|
|
|
12. HOMEWORK- Statistical Functions Video
|
|
|
2. Basic Statistical Functions Video
|
|
|
3. SMALL-LARGE - RANK-PERCENTRANK Video
|
|
|
4. RAND-- - RANDBETWEEN Video
|
|
|
5. The SUMPRODUCT Function Video
|
|
|
6. SUMPRODUCT Demo Video
|
|
|
7. COUNTIFS-SUMIFS-AVERAGEIFS Video
|
|
|
8. DEMO- Building a Basic Dashboard Video
|
|
|
9. Combining COUNTIF - SUMPRODUCT Video
|
|
|
|
5. Lookup-Reference Functions
|
|
1. Introduction Video
|
|
|
10. The MATCH Function Video
|
|
|
11. Using INDEX - MATCH Together Video
|
|
|
12. Combining MATCH with VLOOKUP Video
|
|
|
13. UPDATE- VLOOKUP Correction Video
|
|
|
14. SNEAK PEEK- XLOOKUP -Office 365 Only- Video
|
|
|
15. DEMO- Building Dashboards with XLOOKUP Video
|
|
|
16. Selecting List Items with CHOOSE Video
|
|
|
17. The OFFSET Function Video
|
|
|
18. Combining OFFSET with COUNTA Video
|
|
|
19. DEMO- Using OFFSET to Create a Dynamic Scrolling Chart Video
|
|
|
2. Working with Named Arrays Video
|
|
|
21. HOMEWORK- Lookup-Reference Functions Video
|
|
|
3. ROW-ROWS - COLUMN-COLUMNS Video
|
|
|
4. VLOOKUP-HLOOKUP Video
|
|
|
5. Joining Data with VLOOKUP Video
|
|
|
6. Fixing Errors with IFERROR - VLOOKUP Video
|
|
|
7. VLOOKUP Reference Array Options Video
|
|
|
8. Approximate Match Lookups Video
|
|
|
9. The INDEX Function Video
|
|
|
|
6. Text Functions
|
|
1. Introduction Video
|
|
|
11. HOMEWORK- Text Functions Video
|
|
|
2. UPPER-LOWER-PROPER - TRIM Video
|
|
|
3. The CONCATENATE Function --- Video
|
|
|
4. LEFT-MID-RIGHT - LEN Video
|
|
|
5. TEXT-VALUE Video
|
|
|
6. SEARCH-FIND Video
|
|
|
7. Categorizing Data with IF-ISNUMBER-SEARCH-- Video
|
|
|
8. Combining RIGHT- LEN- and SEARCH Video
|
|
|
9. SUBSTITUTE Video
|
|
|
|
7. Date - Time Functions
|
|
1. Introduction Video
|
|
|
10. DEMO- Designing a Sample Budget Pacing Tool Video
|
|
|
12. HOMEWORK- Date - Time Functions Video
|
|
|
2. DATEVALUE Video
|
|
|
3. Date Formatting - Fill Series Video
|
|
|
4. TODAY---NOW-- Video
|
|
|
5. YEAR-MONTH-DAY - HOUR-MINUTE-SECOND Video
|
|
|
6. The EOMONTH Function Video
|
|
|
7. The YEARFRAC Function Video
|
|
|
8. WEEKDAY- WORKDAY - NETWORKDAYS Video
|
|
|
9. The DATEDIF Function Video
|
|
|
|
8. Formula-Based Formatting
|
|
1. Introduction Video
|
|
|
2. Creating- Editing - Managing Formula-Based Rules Video
|
|
|
3. Highlighting Every Other Row Using the MOD Function Video
|
|
|
4. Formatting Cells Based on the Value of Another Cell Video
|
|
|
5. Formatting Cells Using Statistical Functions Video
|
|
|
6. Formatting Cells Using Text Functions - Logical operators Video
|
|
|
8. HOMEWORK- Formula-Based Formatting Video
|
|
|
|
9. Array Formulas
|
|
1. Introduction Video
|
|
|
10. Returning the -X- Largest Values in a Range Video
|
|
|
11. Counting Characters Across Cells Video
|
|
|
12. Creating a -MAX IF- Array Formula Video
|
|
|
13. -MAX IF- with Multiple Criteria Video
|
|
|
14. Using the Double Unary Operator ------ Video
|
|
|
16. HOMEWORK- Array Functions Video
|
|
|
2. READ ME- Array Formulas are Changing- Text
|
|
|
3. Rules of Array Functions Video
|
|
|
4. Pros - Cons of Array Functions Video
|
|
|
5. Vertical- Horizontal- and 2-Dimensional Array Constants Video
|
|
|
6. Using Array Constants in Formulas Video
|
|
|
7. Named Array Constants Video
|
|
|
8. The Transpose Function Video
|
|
|
9. Linking Data Between Sheets- Array vs. Non-Array Comparison Video
|
|
|
|
|
Microsoft Excel- Pivot Tables - Pivot Charts
|
|
0. Orientation - Benchmark Assessment
|
|
1. Welcome to the Course- Text
|
|
|
|
1. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Getting to Know the IMDb Movie Database Video
|
|
|
4. Setting Expectations Video
|
|
|
|
2. PivotTable 101
|
|
1. Why PivotTables- Video
|
|
|
11. Removing - Reviving Data from Cache Video
|
|
|
12. How PivotTables ACTUALLY Work Video
|
|
|
14. HOMEWORK- PivotTable 101 Text
|
|
|
2. Structuring Your Source Data Video
|
|
|
3. Inserting Your First PivotTable Video
|
|
|
4. IMPORTANT- Add to Data Model Text
|
|
|
5. Navigating the Field List Video
|
|
|
6. KNOWLEDGE CHECK- Manipulating PivotTable Views Text
|
|
|
7. PivotTable Options- -Analyze- - -Design- Video
|
|
|
8. Selecting- Clearing- Moving - Copying Pivots Video
|
|
|
9. Refreshing - Updating Pivots Video
|
|
|
|
3. PivotTable Formatting
|
|
1. Number Formatting Video
|
|
|
10. HOMEWORK- PivotTable Formatting Text
|
|
|
2. PRO TIP- Automatically Formatting Empty Cells Video
|
|
|
3. Table Layouts - Styles Video
|
|
|
4. PRO TIP- Using Tabular Tables to Create New Source Data Video
|
|
|
5. Customizing Headers - Labels Video
|
|
|
6. Conditional Formatting Video
|
|
|
7. PRO TIP- Data Bars with Invisible Text Video
|
|
|
8. Advanced Conditional Formatting Video
|
|
|
|
4. Sorting- Filtering - Grouping
|
|
1. Sorting Options Video
|
|
|
10. Breaking Out Report Filter Pages Video
|
|
|
12. HOMEWORK- Sorting- Filtering - Grouping Text
|
|
|
2. PRO TIP- Incorrect Alphabetical Sorting Video
|
|
|
3. Label Filters - Manual Selections Video
|
|
|
4. PRO TIP- Label Filters with Wildcards Video
|
|
|
5. Value Filters Video
|
|
|
6. PRO TIP- Enabling Multiple Filters Video
|
|
|
7. Grouping Data Video
|
|
|
8. PRO TIP- Automatic Date Grouping Video
|
|
|
9. Using Slicers - Timelines to Filter Data Video
|
|
|
|
5. Calculated Values- Fields - Items
|
|
1. -Summarize Values By- Options Video
|
|
|
10. KNOWLEDGE CHECK- Show Values As Text
|
|
|
11. Inserting Calculated Fields Video
|
|
|
12. Calculations in Pivots vs. Raw Data Video
|
|
|
13. PRO TIP- Calculating Using Counts -Part 1- Video
|
|
|
14. PRO TIP- Calculating Using Counts -Part 2- Video
|
|
|
15. Inserting a Calculated Item -use with caution-- Video
|
|
|
16. The Solve Order - List Formulas Tools Video
|
|
|
18. HOMEWORK- Calculated Values- Fields - Items Text
|
|
|
2. PRO TIP- Avoiding the -Count Of- Trap Video
|
|
|
3. -Show Values As- Calculations Video
|
|
|
4. Show Values As- % of Column-Row Video
|
|
|
5. Show Values As- % of Parent Video
|
|
|
6. Show Values As- Difference From Video
|
|
|
7. Show Values As- Running Total Video
|
|
|
8. Show Values As- Rank Video
|
|
|
9. Show Values As- Index Video
|
|
|
|
6. Pivot Charts
|
|
1. Intro to PivotCharts Video
|
|
|
10. Applying Slicers - Timelines to Multiple Charts Video
|
|
|
11. Building a Dynamic Dashboard Video
|
|
|
13. HOMEWORK- Pivot Charts Text
|
|
|
2. Pivot Chart Demo- Column Chart Video
|
|
|
3. Pivot Chart Demo- Pie - Donut Charts Video
|
|
|
4. Pivot Chart Demo- Clustered Bar Chart Video
|
|
|
5. PRO TIP- Prevent Charts from Resizing with Cells Video
|
|
|
6. Changing Chart Types on the Fly Video
|
|
|
7. Pivot Chart Demo- Stacked Area Chart Video
|
|
|
8. Pivot Chart Layouts - Styles Video
|
|
|
9. Moving Pivot Charts to New Sheets Video
|
|
|
|
7. PivotTable Case Studies
|
|
1. Setting Expectations Video
|
|
|
10. HOMEWORK- Stock Market Data Text
|
|
|
11. Baseball Team Stats Video
|
|
|
12. HOMEWORK- Baseball Team Stats Text
|
|
|
13. San Diego Burrito Ratings Video
|
|
|
14. HOMEWORK- San Diego Burrito Ratings Text
|
|
|
15. Daily Weather Conditions Video
|
|
|
16. HOMEWORK- Daily Weather Conditions Text
|
|
|
17. Spartan Race Facebook Posts Video
|
|
|
18. HOMEWORK- Spartan Race Facebook Posts Text
|
|
|
19. Apple App Data Video
|
|
|
20. HOMEWORK- Apple App Data Text
|
|
|
21. Wine Tasting Scores Video
|
|
|
22. HOMEWORK- Wine Tasting Scores Text
|
|
|
3. U.S. Voters -2012- Video
|
|
|
4. HOMEWORK- U.S. Voters -2012- Text
|
|
|
5. San Francisco Salaries Video
|
|
|
6. HOMEWORK- San Francisco Salaries Text
|
|
|
7. Shark Attack Records Video
|
|
|
8. HOMEWORK- Shark Attack Records Text
|
|
|
9. Stock Market Data Video
|
|
|
|
9. Final Assessment - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Microsoft Excel- Power Query- Power Pivot - DAX
|
|
0. Orientation - Benchmark Assessment
|
|
1. Welcome to the Course- Text
|
|
|
|
1. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2. IMPORTANT- Versions - Compatibility Video
|
|
|
3. Introducing the Course Project Video
|
|
|
4.DOWNLOAD%3a Course Resources
|
|
|
5. Setting Expectations Video
|
|
|
|
2. Intro to -Power Excel-
|
|
1. The -Power Excel- Workflow Video
|
|
|
2. -The Best Thing to Happen to Excel in 20 Years- Video
|
|
|
3. When to use Power Query - Power Pivot Video
|
|
|
5. HOMEWORK- Intro to -Power Excel- Text
|
|
|
|
3. Power Query
|
|
1. Introduction Video
|
|
|
10. PRO TIP- Creating a Rolling Calendar Video
|
|
|
11. Adding Index - Conditional Columns Video
|
|
|
12. Grouping - Aggregating Data Video
|
|
|
13. Pivoting - Unpivoting Video
|
|
|
14. Modifying Workbook Queries Video
|
|
|
15. Merging Queries Video
|
|
|
16. Appending Queries Video
|
|
|
17. Connecting to a Folder of Files Video
|
|
|
18. Power Query Best Practices Video
|
|
|
2. Meet Power Query -aka -Get - Transform-- Video
|
|
|
20. HOMEWORK- Power Query Text
|
|
|
3. The Query Editor Video
|
|
|
4. Data Loading Options Video
|
|
|
5. IMPORTANT- Updating Locale Settings Text
|
|
|
6. Basic Table Transformations Video
|
|
|
7. Text-Specific Tools Video
|
|
|
8. Number-Specific Tools Video
|
|
|
9. Date-Specific Tools Video
|
|
|
|
4. Data Modeling 101
|
|
1. Introduction Video
|
|
|
10. Relationship Cardinality Video
|
|
|
11. Connecting Multiple Data Tables Video
|
|
|
12. Filter Direction Video
|
|
|
13. Hiding Fields from Client Tools Video
|
|
|
14. Defining Hierarchies Video
|
|
|
15. Data Model Best Practices Video
|
|
|
17. HOMEWORK- Data Modeling 101 Text
|
|
|
2. Meet Excel-s -Data Model- Video
|
|
|
3. Data vs. Diagram View Video
|
|
|
4. Database Normalization Video
|
|
|
5. Data Tables vs. Lookup Tables Video
|
|
|
6. Relationships vs. Merged Tables Video
|
|
|
7. Creating Table Relationships Video
|
|
|
8. Modifying Table Relationships Video
|
|
|
9. Active vs. Inactive Relationships Video
|
|
|
|
5. Power Pivot - DAX 101
|
|
1. Introduction Video
|
|
|
10. Understanding Filter Context Video
|
|
|
11. Step-by-Step Measure Calculation Video
|
|
|
12. RECAP- Calculated Columns vs. Measures Video
|
|
|
13. Power Pivot Best Practices Video
|
|
|
15. HOMEWORK- Power Pivot - DAX 101 Text
|
|
|
2. Creating a -Power- PivotTable Video
|
|
|
3. Power Pivots vs. -Normal- Pivots Video
|
|
|
4. Intro to Data Analysis Expressions -DAX- Video
|
|
|
5. Calculated Columns Video
|
|
|
6. Intro to DAX Measures Video
|
|
|
7. Creating Implicit Measures Video
|
|
|
8. Creating Explicit Measured -AutoSum- Video
|
|
|
9. Creating Explicit Measures -Power Pivot- Video
|
|
|
|
6. Common DAX Functions
|
|
1. Introduction Video
|
|
|
10. HOMEWORK- Logical - Text Functions Text
|
|
|
11. The CALCULATE Function Video
|
|
|
12. Adding Filter Context with Filter -Part 1- Video
|
|
|
13. Adding Filter Context with Filter -Part 2- Video
|
|
|
14. Removing Filter Context with ALL Video
|
|
|
15. HOMEWORK- CALCULATE- FILTER - ALL Text
|
|
|
16. Joining Data with RELATED Video
|
|
|
17. Iterator --X-- Functions- SUMX Video
|
|
|
18. Iterator --X-- Functions- RANKX Video
|
|
|
19. HOMEWORK- Iterator Functions Text
|
|
|
2. DAX Formula Syntax - Operators Video
|
|
|
20. Basic Date - Time Functions Video
|
|
|
21. Time Intelligence Formulas Video
|
|
|
22. HOMEWORK- Time Intelligence Text
|
|
|
23. Speed - Performance Considerations Video
|
|
|
24. DAX Best Practices Video
|
|
|
3. Common DAX Function Categories Video
|
|
|
4. Basic Math - Stats Functions Video
|
|
|
5. COUNT- COUNTA- DISTINCTCOUNT - COUNTROWS Video
|
|
|
6. HOMEWORK- Math - Stats Functions Text
|
|
|
7. Logical Functions -IF-AND-OR- Video
|
|
|
8. SWITCH - SWITCH-TRUE- Video
|
|
|
9. Text Functions Video
|
|
|
|
7. Wrapping Up
|
|
1. Introduction Video
|
|
|
2. Data Visualization Options Video
|
|
|
3. Sneak Peek- Power BI Video
|
|
|
|
9. Final Assessment - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Microsoft Excel- VBA - Macros
|
|
0. Orientation - Benchmark Assessment
|
|
1. Welcome to the Course- Text
|
|
|
|
1. Course Intro
|
|
1. Course Structure - Content Video
|
|
|
2. Important Compatibility - Setup Information Video
|
|
|
3. Getting to Know the Project Files Video
|
|
|
4.DOWNLOAD%3a Course Resources
|
|
|
5. Setting Expectations Video
|
|
|
|
10. Looping in VBA -Controlling the Flow of Code-
|
|
1. Overview- Looping in VBA Video
|
|
|
10. Activity- Document all Comments in Workbook in a Sheet Text
|
|
|
11. Project- Document all Comments in Workbook in a Sheet Video
|
|
|
12. Key Takeaways- Looping in VBA Video
|
|
|
2. For Next Counter Loops Video
|
|
|
3. For Next Nested Loop Video
|
|
|
4. For Next Reverse Loop -Delete Filtered-Hidden Rows- Video
|
|
|
5. Do Until - Do While Loop Video
|
|
|
6. Practical Example of Do Loop -with Inputbox- Video
|
|
|
7. Find Method for Quicker Lookup Results Video
|
|
|
8. Find Method with Do Loop - Multiple Matches Video
|
|
|
9. Add a Timer to Test - Speech to Inform Video
|
|
|
|
11. Working with Arrays
|
|
1. Overview- Working with Arrays in VBA Video
|
|
|
2. One Dimensional Arrays Video
|
|
|
3. Dynamic Arrays Video
|
|
|
4. Preserving Dynamic Arrays Video
|
|
|
5. Two Dimensional Arrays Video
|
|
|
6. Variant Arrays- Quick Method to Write to Cells Video
|
|
|
7. Activity- Create a New Worksheet per Company with Specific Information Text
|
|
|
8. Project- Create a New Worksheet per Company with Specific Information Video
|
|
|
9. Key Takeaways- Arrays Text
|
|
|
|
12. Working with Files- Folders - Text Files
|
|
1. Overview- Working with Folders - Files Video
|
|
|
2. DIR Function- Check if Files or Folders Exist Video
|
|
|
3. GetOpenFileName Method- User Selects a File Video
|
|
|
4. FileDialog Property- Loop Inside a Folder Video
|
|
|
5. Create CSV File from Data in Excel Video
|
|
|
6. Printing - Writing to Text Files for More Control Video
|
|
|
7. Activity- Export Data to Text file Text
|
|
|
8. Project- Export Data to Text file Video
|
|
|
9. Key Takeaways- Files - Folders Text
|
|
|
|
13. Excel Tables- Formulas - Pivot Tables
|
|
1. Overview- -Pivot- Tables - Formulas Video
|
|
|
2. Using Excel Formulas in VBA Video
|
|
|
3. Excel Tables- Use the Right Syntax Video
|
|
|
4. Pivot Tables - VBA- What you Need to Know Video
|
|
|
5. Activity- Update Existing Formulas with VBA by Adding IFERROR Text
|
|
|
6. Project- Update Existing Formulas with VBA by Adding IFERROR Video
|
|
|
7. Key Takeaways- -Pivot- Tables - Formulas Text
|
|
|
|
14. Main Project -2- Sales Regional Reporting Tool
|
|
1. What You-ll Learn in this Project Video
|
|
|
10. Key Takeaways- VBA-based Excel Tools Video
|
|
|
11. Second Milestone Completed- Text
|
|
|
2. Project Overview- Regional Sales Reporting Tool Video
|
|
|
3. Importing Data from Multiple Files using MultiSelect Video
|
|
|
4. Setting up a Template as the Basis for Different Reports Video
|
|
|
5. Exporting Reports as Excel files Video
|
|
|
6. Fine-tuning Report Export Procedure Video
|
|
|
7. Setting up Automatic Export of Text File Video
|
|
|
8. Track the List of Tasks Completed with VBA Video
|
|
|
9. Final Touches - Creating Interface to Hide Specific Tabs with a Password Video
|
|
|
|
15. Interacting with Other Applications -Word- PowerPoint etc.-
|
|
1. Overview- Interacting with Other Applications Video
|
|
|
2. PDF- Save Specific Sheets as a PDF File Video
|
|
|
3. Email- Automatically Create Personalized Emails with Attachments Video
|
|
|
4. Microsoft Word- Create Personalized Letters in Word from Excel Video
|
|
|
5. Microsoft PowerPoint- Export Excel Sheets to PowerPoint Presentation Video
|
|
|
6. Key Takeaways- Working with Other Applications Text
|
|
|
|
16. Workbook and Worksheet Events
|
|
1. Overview- Event Procedures Video
|
|
|
2. Workbook Events- Toggle Full Screen -Activate- Deactivate- Open- Close- Video
|
|
|
3. Worksheet Selection Change- Dynamic Font Color of Selected Range Video
|
|
|
4. Refresh PivotTables Automatically - Concept of Range Intersection Video
|
|
|
5. Resetting a Dependent Drop-down when the first Drop-down is Changed Video
|
|
|
6. Activity- Link Page Header to Cell Value -BeforePrint Event- Text
|
|
|
7. Project- Link Page Header to Cell Value -BeforePrint Event- Video
|
|
|
8. Key Takeaways- Workbook - Worksheet Events Video
|
|
|
|
17. Working with Userforms - ActiveX Controls
|
|
1. Overview- UserForms - ActiveX Controls Video
|
|
|
10. BONUS- ListBox to Print Multiple Pages at Once Video
|
|
|
11. UserForm Checklist - Course Map Status Text
|
|
|
2. ActiveX Controls- What you Need to Know Video
|
|
|
3. ActiveX Check Box to Fix Scroll Area - Toggle Screen Settings Video
|
|
|
4. ActiveX to Show and Hide Help Video
|
|
|
5. ActiveX Combo Box for Easy Sheet Navigation Video
|
|
|
6. ActiveX to Show or Hide Other ActiveX controls Video
|
|
|
7. UserForm Basics- What You Need to Get Started Video
|
|
|
8. UserForm for Data Entry -Input - Check Boxes- Video
|
|
|
9. Practical UserForm to Document External Links - Comments -Combo Box - Option button- Video
|
|
|
|
18. Main Project -3- Invoice Generation Tool
|
|
1. Tool Overview- What You Will Learn Video
|
|
|
10. Final Updates - Debugging Video
|
|
|
11. Last Milestone Completed- Text
|
|
|
2. Setting up an Input UserForm to Collect Master Data Video
|
|
|
3. Working with Multi-Column ListBoxes Video
|
|
|
4. Edit Master Data with UserForm Video
|
|
|
5. Searchable ListBox -with Selection Change event- Video
|
|
|
6. Enhanced Searchable ListBox- Write Selection back to Excel Table Video
|
|
|
7. MultiPage UserForm to Create Invoices - Email -Setup- Video
|
|
|
8. Export PDF - Excel Workbook for Each Invoice based on ListBox Selection Video
|
|
|
9. Create Email in Outlook - Attach PDF Invoice Video
|
|
|
|
19. Create your own Custom Functions
|
|
1. Overview- Function Procedures Video
|
|
|
2. Setting up a Simple Function -including Optional Arguments- Video
|
|
|
3. Function to Calculate Age -Result in Years - Months- Video
|
|
|
4. Functions that Split Text and Numbers from Cell Value Video
|
|
|
5. Using Functions in Sub Procedures Video
|
|
|
6. Activity- Function That Sums based on Cell Color Text
|
|
|
7. Project- Function That Sums based on Cell Color Video
|
|
|
8. Key Takeaways- Function Procedures in VBA Text
|
|
|
|
2. Your First Excel Macro
|
|
1. Overview- Macros - Visual Basic Editor -VBE- Video
|
|
|
2. Steps to Your First Macro Recording Video
|
|
|
3. Visual Basic Editor- What You Need to Know Video
|
|
|
4. Project- Dynamic Cell Selection -Special Cells- Video
|
|
|
5. Project- Absolute versus Relative Macro Recording Video
|
|
|
6. 7 Ways to Run Macros - VBA code Video
|
|
|
7. OFFICE 365 Update- Comments - Notes Text
|
|
|
8. Activity- Record a Macro that Deletes all Comments Text
|
|
|
9. What-s the Difference Between Macros and VBA- Text
|
|
|
|
20. Working with Charts
|
|
1. Overview- The Chart Object Library Video
|
|
|
2. Create and Modify a Chart with VBA Video
|
|
|
3. Animated Charts- Different Methods Video
|
|
|
4. Show Charts inside UserForms Video
|
|
|
5. Key Takeaways- VBA Charts Text
|
|
|
|
22. Final Assessment - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
3. The Object Model
|
|
1. Overview- VBA Object Model Video
|
|
|
2. VBA-s Code Reference Object Library Video
|
|
|
3. VB Color Guidelines - Keyboard Shortcuts Video
|
|
|
4. Excel VBA Object Model Video
|
|
|
5. Object Properties Video
|
|
|
6. Object Methods Video
|
|
|
7. How to Find the Object- Property - Method Video
|
|
|
8. Conclusion- Key Takeaways Video
|
|
|
|
4. Referencing Ranges- Worksheets - Workbooks with VBA
|
|
1. Overview- Referencing Ranges- Worksheets - Workbooks Video
|
|
|
10. Key Takeaways- Referencing Ranges Video
|
|
|
2. Referring to Ranges - Writing to Cells in VBA Video
|
|
|
3. Most Useful Range Properties - Methods Video
|
|
|
4. 4 Methods to Find the Last Row of a Range Video
|
|
|
5. Copying - Resizing a Variable Range Video
|
|
|
6. Properly Referencing Worksheets Video
|
|
|
7. Properly Referencing Workbooks Video
|
|
|
8. Activity- Save a Hard-coded Copy of Workbook Text
|
|
|
9. Project- Save Hard-coded Copy - Macro-free version of workbook Video
|
|
|
|
5. Working with Variables
|
|
1. Overview- Role of Assignment - Variables Video
|
|
|
2. Data Types for Better Performance Video
|
|
|
3. Declaring Variables- Arrays - Constants Video
|
|
|
4. Setting Object Variables Video
|
|
|
5. Scoping Variables Video
|
|
|
6. Activity- Revisit Hard-coded Workbook Project Text
|
|
|
7. Key Takeaways- Working with Variables Video
|
|
|
|
6. Looping through Collections - Making Decisions
|
|
1. Overview- Why Collections are a VBA Essential Video
|
|
|
10. Key Takeaways- Collections - Decision Making in VBA Text
|
|
|
2. With - End With for Easier Code Writing Video
|
|
|
3. For Each to Loop Through Collections Video
|
|
|
4. IF Then -Else- ElseIF- for Conditional Outcomes Video
|
|
|
5. Select Case as Alternative for Many IF Statements Video
|
|
|
6. Goto Statement to Change Program Flow Video
|
|
|
7. Activity- Get the Number of Formulas in a Worksheet Text
|
|
|
8. Project- Get the Number of Formulas in a Worksheet Video
|
|
|
9. Bonus- Un-hiding All Sheets in One Go -3 Methods- Video
|
|
|
|
7. Useful Built-in Functions
|
|
1. Overview- VBA versus Worksheet Functions Video
|
|
|
2. Most Useful VBA Functions Video
|
|
|
3. Message Box Options Video
|
|
|
4. Input Box -VBA InputBox Function- Video
|
|
|
5. Input Box that can Select Ranges Video
|
|
|
6. Activity- Show Top 3 Values in a Message Box Based on Range Text
|
|
|
7. Project- Show Top 3 Values in a Message box based on Range Video
|
|
|
8. Key Takeaways- Built-in Functions Text
|
|
|
|
8. Debugging- Error Handling - Procedure Scope
|
|
1. Overview- Debugging- Handling Errors - Procedure Scope Video
|
|
|
2. Debugging Options- Watch- Locals- Immediate Windows - More Video
|
|
|
3. Error Handling- Different Methods Video
|
|
|
4. Faster Code by Suppressing Pop-ups - Flickering Screen Video
|
|
|
5. Procedure Scope - Running one Sub from Another Video
|
|
|
6. Passing Arguments to Sub Procedures -By Ref- By Val- Video
|
|
|
7. Activity- Number of Formulas -or Comments- Used in a Workbook Text
|
|
|
8. Project- Number of Formulas -or Comments- Used in a Workbook Video
|
|
|
9. Key Takeaways- Debugging - Error Handling Video
|
|
|
|
9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-
|
|
1. Project Overview- Table of Contents -TOC- Video
|
|
|
2. TOC Project- The Basics Video
|
|
|
3. TOC Project- Adding Hyperlinks Video
|
|
|
4. TOC Project- Testing the VBA Code Video
|
|
|
5. TOC Project- Adding Error Handling - More Checks Video
|
|
|
6. TOC Project- Adding to Personal Macro Workbook Video
|
|
|
7. First Milestone Completed- Text
|
|
|
Description
Related Torrents
Trackers
| Tracker name |
| udp://tracker.coppersurfer.tk:6969/announce |
| udp://9.rarbg.me:2850/announce |
| udp://9.rarbg.to:2920/announce |
| udp://tracker.opentrackr.org:1337 |
| udp://tracker.leechers-paradise.org:6969/announce |
Torrent hash:
Copied!
