|
/0. Websites you may like/
|
|
[CourseClub.Me].url
|
0.1 KB
|
|
[FreeCourseSite.com].url
|
0.1 KB
|
|
[GigaCourse.Com].url
|
0.0 KB
|
|
/01 - Before You Dive In/
|
|
001 How to Get the Most Out of This Course.mp4
|
60.2 MB
|
|
001 How to Get the Most Out of This Course_en.srt
|
4.4 KB
|
|
002 ALL-WorkBooks-Excel-Essentials.zip
|
1.5 MB
|
|
002 Download Course Files.mp4
|
3.7 MB
|
|
002 Download Course Files_en.srt
|
1.8 KB
|
|
002 Excel-Essentials-CourseNotes.pdf
|
1.7 MB
|
|
003 Course Outline for Quick Reference.html
|
0.6 KB
|
|
003 Detailed-Course-Outline-Excel-Essentials.xlsx
|
29.1 KB
|
|
/02 - Quick Tour of Excel/
|
|
001 Excel Workbook, Worksheet, Cell Structure.mp4
|
58.1 MB
|
|
001 Excel Workbook, Worksheet, Cell Structure_en.srt
|
12.0 KB
|
|
002 Quick Tour of Excel - Ribbon & Quick Access Toolbar.mp4
|
23.2 MB
|
|
002 Quick Tour of Excel - Ribbon & Quick Access Toolbar_en.srt
|
5.5 KB
|
|
003 Customizing the Excel Interface.mp4
|
31.0 MB
|
|
003 Customizing the Excel Interface_en.srt
|
8.8 KB
|
|
004 Summary Important Points to Remember (Terminology & Shortcuts).html
|
2.4 KB
|
|
/03 - Data Input & Hidden Features to Save Time/
|
|
001 Overview - Data Input & Hidden Excel Features.mp4
|
8.5 MB
|
|
001 Overview - Data Input & Hidden Excel Features_en.srt
|
2.4 KB
|
|
001 S3-Excel-DataInput-START.xlsx
|
81.4 KB
|
|
001 S3-Excel-DataInput.xlsx
|
66.2 KB
|
|
002 Data Entry and Editing Excel Data.mp4
|
25.5 MB
|
|
002 Data Entry and Editing Excel Data_en.srt
|
9.9 KB
|
|
003 Basic Excel Formulas.mp4
|
27.5 MB
|
|
003 Basic Excel Formulas_en.srt
|
12.8 KB
|
|
004 Text to Speech (Hidden Excel Feature).mp4
|
12.3 MB
|
|
004 Text to Speech (Hidden Excel Feature)_en.srt
|
4.4 KB
|
|
005 Correctly Input Dates and Time Stamps in Excel.mp4
|
19.5 MB
|
|
005 Correctly Input Dates and Time Stamps in Excel_en.srt
|
5.7 KB
|
|
006 Use Excel AutoFill To Do Your Work.mp4
|
10.8 MB
|
|
006 Use Excel AutoFill To Do Your Work_en.srt
|
5.8 KB
|
|
007 Excel Flash Fill for Major Time Saving (Become Pro).mp4
|
43.7 MB
|
|
007 Excel Flash Fill for Major Time Saving (Become Pro)_en.srt
|
7.3 KB
|
|
008 Custom Lists With AutoFill (Hidden Excel Feature).mp4
|
12.7 MB
|
|
008 Custom Lists With AutoFill (Hidden Excel Feature)_en.srt
|
3.5 KB
|
|
009 Inputting & Editing Comments & Notes in Excel.mp4
|
42.4 MB
|
|
009 Inputting & Editing Comments & Notes in Excel_en.srt
|
11.5 KB
|
|
010 Finding Excel Formulas & Input Cells with ONE Click (Become Pro).mp4
|
29.6 MB
|
|
010 Finding Excel Formulas & Input Cells with ONE Click (Become Pro)_en.srt
|
5.6 KB
|
|
011 Excel Data Validation to Reduce Time Checking Data.mp4
|
76.5 MB
|
|
011 Excel Data Validation to Reduce Time Checking Data_en.srt
|
15.9 KB
|
|
012 Adding Tool Tips (Screen Tips in Excel).mp4
|
5.9 MB
|
|
012 Adding Tool Tips (Screen Tips in Excel)_en.srt
|
3.4 KB
|
|
013 Learn to Work with Pictures, Shapes & Other Objects in Excel.mp4
|
25.4 MB
|
|
013 Learn to Work with Pictures, Shapes & Other Objects in Excel_en.srt
|
7.1 KB
|
|
014 Challenge Data Manipulation & Preparation in Excel.html
|
0.8 KB
|
|
015 Solution Data Manipulation & Preparation in Excel.mp4
|
72.9 MB
|
|
015 Solution Data Manipulation & Preparation in Excel_en.srt
|
7.2 KB
|
|
016 Summary Key Excel Features to Impress & Save Time.html
|
2.5 KB
|
|
/04 - Worksheet Navigation, Copying and Protecting/
|
|
001 Overview - Worksheet Navigation in Excel.mp4
|
4.8 MB
|
|
001 Overview - Worksheet Navigation in Excel_en.srt
|
1.5 KB
|
|
001 S4-Excel-Worksheet-START.xlsx
|
46.2 KB
|
|
001 S4-Excel-Worksheet.xlsx
|
51.9 KB
|
|
002 Useful Excel Shortcuts for Navigation (Become Pro).mp4
|
43.8 MB
|
|
002 Useful Excel Shortcuts for Navigation (Become Pro)_en.srt
|
14.9 KB
|
|
003 Copying, Moving & Hiding Worksheets.mp4
|
22.3 MB
|
|
003 Copying, Moving & Hiding Worksheets_en.srt
|
4.4 KB
|
|
004 Freeze Panes (Lock Rows, Columns) & Split Screen for Long Excel Reports.mp4
|
39.8 MB
|
|
004 Freeze Panes (Lock Rows, Columns) & Split Screen for Long Excel Reports_en.srt
|
4.4 KB
|
|
005 Hide & Unhide, Insert, Adjust Columns & Rows in Excel.mp4
|
64.2 MB
|
|
005 Hide & Unhide, Insert, Adjust Columns & Rows in Excel_en.srt
|
8.6 KB
|
|
006 Copying and Pasting Data (Hidden Excel Paste Features).mp4
|
41.2 MB
|
|
006 Copying and Pasting Data (Hidden Excel Paste Features)_en.srt
|
7.8 KB
|
|
007 Protecting Excel Worksheets & Specific Ranges.mp4
|
78.9 MB
|
|
007 Protecting Excel Worksheets & Specific Ranges_en.srt
|
12.3 KB
|
|
008 Challenge Update & Protect Excel Report.html
|
0.8 KB
|
|
009 Solution Update & Protect Excel Report.mp4
|
41.4 MB
|
|
009 Solution Update & Protect Excel Report_en.srt
|
5.7 KB
|
|
010 Summary Important Worksheet Features & Excel Shortcuts.html
|
3.9 KB
|
|
/05 - Excel Formulas & What to be Aware of/
|
|
001 Overview - Excel Formulas & What to be Aware of.mp4
|
11.5 MB
|
|
001 Overview - Excel Formulas & What to be Aware of_en.srt
|
3.3 KB
|
|
001 S5-Excel-Formulas-START.xlsx
|
73.9 KB
|
|
001 S5-Excel-Formulas.xlsx
|
75.5 KB
|
|
002 How Excel Calculates - Order of Precedence.mp4
|
10.9 MB
|
|
002 How Excel Calculates - Order of Precedence_en.srt
|
7.3 KB
|
|
003 Simple but Useful Excel Formulas.mp4
|
55.0 MB
|
|
003 Simple but Useful Excel Formulas_en.srt
|
7.2 KB
|
|
004 Essential Excel Rule (Don't Skip!).mp4
|
8.6 MB
|
|
004 Essential Excel Rule (Don't Skip!)_en.srt
|
3.5 KB
|
|
005 Absolute and Relative Cell Referencing in Excel.mp4
|
22.2 MB
|
|
005 Absolute and Relative Cell Referencing in Excel_en.srt
|
8.5 KB
|
|
006 Improve Clarity with Range Names.mp4
|
29.5 MB
|
|
006 Improve Clarity with Range Names_en.srt
|
7.1 KB
|
|
007 Referencing other Workbooks or Worksheets.mp4
|
28.0 MB
|
|
007 Referencing other Workbooks or Worksheets_en.srt
|
5.6 KB
|
|
008 Circular References & How to Locate Them.mp4
|
9.4 MB
|
|
008 Circular References & How to Locate Them_en.srt
|
2.3 KB
|
|
009 Combine Values From Two or More Cells to ONE Cell.mp4
|
20.1 MB
|
|
009 Combine Values From Two or More Cells to ONE Cell_en.srt
|
5.3 KB
|
|
010 Challenge Allocate Yearly Value Based on Percentages.html
|
0.9 KB
|
|
011 Solution Allocate Yearly Value Based on Percentages.mp4
|
28.1 MB
|
|
011 Solution Allocate Yearly Value Based on Percentages_en.srt
|
4.7 KB
|
|
012 Summary Key Points when Writing Excel Formulas.html
|
2.1 KB
|
|
/06 - Important Excel Functions (Everything you need to become Pro)/
|
|
001 Overview & Finding Excel Functions from Insert Function.mp4
|
23.3 MB
|
|
001 Overview & Finding Excel Functions from Insert Function_en.srt
|
7.2 KB
|
|
001 S6-Excel-Functions-START.xlsx
|
64.8 KB
|
|
001 S6-Excel-Functions.xlsx
|
79.8 KB
|
|
002 Important! Working with Excel Functions.html
|
1.5 KB
|
|
003 COUNT, COUNTA, COUNTBLANK.mp4
|
15.9 MB
|
|
003 COUNT, COUNTA, COUNTBLANK_en.srt
|
5.5 KB
|
|
004 COUNT based on a Condition (COUNTIFS).mp4
|
105.6 MB
|
|
004 COUNT based on a Condition (COUNTIFS)_en.srt
|
12.4 KB
|
|
005 SUM & AVERAGE Functions in Excel.mp4
|
23.6 MB
|
|
005 SUM & AVERAGE Functions in Excel_en.srt
|
3.9 KB
|
|
006 SUM by Criteria (SUMIFS, AVERAGEIFS).mp4
|
59.0 MB
|
|
006 SUM by Criteria (SUMIFS, AVERAGEIFS)_en.srt
|
8.4 KB
|
|
007 MAX & MIN (MAXIFS & MINIFS).mp4
|
40.6 MB
|
|
007 MAX & MIN (MAXIFS & MINIFS)_en.srt
|
5.3 KB
|
|
007 MAXIFS-MINIFS-Alternative.url
|
0.1 KB
|
|
008 Rounding Values (ROUND, ROUNDUP & ROUNDOWN).mp4
|
22.8 MB
|
|
008 Rounding Values (ROUND, ROUNDUP & ROUNDOWN)_en.srt
|
7.3 KB
|
|
009 Essential Excel Date Functions.mp4
|
44.4 MB
|
|
009 Essential Excel Date Functions_en.srt
|
13.1 KB
|
|
010 Time Calculations in Excel - Total Time Worked.mp4
|
37.9 MB
|
|
010 Time Calculations in Excel - Total Time Worked_en.srt
|
7.9 KB
|
|
011 Dynamic-Arrays-Explained.url
|
0.1 KB
|
|
011 Handling Excel Formula Errors.mp4
|
16.0 MB
|
|
011 Handling Excel Formula Errors_en.srt
|
7.1 KB
|
|
012 IF (Then, Else) Excel Function - Conditional Formulas.mp4
|
55.0 MB
|
|
012 IF (Then, Else) Excel Function - Conditional Formulas_en.srt
|
17.5 KB
|
|
013 VLOOKUP Function - Lookup Values from Another Place.mp4
|
61.7 MB
|
|
013 VLOOKUP Function - Lookup Values from Another Place_en.srt
|
10.7 KB
|
|
014 Challenge How Good Are you with Excel Functions.html
|
1.1 KB
|
|
015 Solution How Good Are you with Excel Functions.mp4
|
73.0 MB
|
|
015 Solution How Good Are you with Excel Functions_en.srt
|
9.4 KB
|
|
016 NEW 365 Functions FILTER, SORT, UNIQUE, XLOOKUP & More.html
|
1.8 KB
|
|
017 Summary Important Excel Functions.html
|
2.6 KB
|
|
external-links.txt
|
0.2 KB
|
|
/07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/
|
|
001 Overview - Data Cleaning, Analysis & Management Tools in Excel.mp4
|
39.0 MB
|
|
001 Overview - Data Cleaning, Analysis & Management Tools in Excel_en.srt
|
3.3 KB
|
|
001 S7-Excel-DataCleaning-START.xlsx
|
79.0 KB
|
|
001 S7-Excel-DataCleaning.xlsx
|
89.1 KB
|
|
002 Sort Data (Organize & Create Order) in Excel.mp4
|
62.8 MB
|
|
002 Sort Data (Organize & Create Order) in Excel_en.srt
|
8.9 KB
|
|
003 Unsort Data to Revert to Original Order.mp4
|
8.2 MB
|
|
003 Unsort Data to Revert to Original Order_en.srt
|
2.2 KB
|
|
004 Add Subtotals to Sorted Data.mp4
|
63.6 MB
|
|
004 Add Subtotals to Sorted Data_en.srt
|
8.6 KB
|
|
005 Filter Data to Extract What you Need.mp4
|
53.5 MB
|
|
005 Filter Data to Extract What you Need_en.srt
|
7.5 KB
|
|
006 Delete Blank or Empty Rows in Excel.mp4
|
29.1 MB
|
|
006 Delete Blank or Empty Rows in Excel_en.srt
|
5.1 KB
|
|
007 Fill Empty Cells in One Go (Become Pro).mp4
|
40.7 MB
|
|
007 Fill Empty Cells in One Go (Become Pro)_en.srt
|
4.2 KB
|
|
008 Remove Duplicates to Get a Unique List in Excel.mp4
|
21.7 MB
|
|
008 Remove Duplicates to Get a Unique List in Excel_en.srt
|
3.9 KB
|
|
009 Excel Find Feature, Select & Emphasize.mp4
|
89.7 MB
|
|
009 Excel Find Feature, Select & Emphasize_en.srt
|
9.8 KB
|
|
010 Find and Replace Values & Formatting (Hidden Excel Feature).mp4
|
54.5 MB
|
|
010 Find and Replace Values & Formatting (Hidden Excel Feature)_en.srt
|
6.6 KB
|
|
011 Why Excel Tables Can be a Time Saver (Become Pro).mp4
|
108.4 MB
|
|
011 Why Excel Tables Can be a Time Saver (Become Pro)_en.srt
|
14.8 KB
|
|
012 Challenge Data Management in Excel.html
|
0.9 KB
|
|
013 Solution Data Management Challenge in Excel.mp4
|
36.7 MB
|
|
013 Solution Data Management Challenge in Excel_en.srt
|
7.3 KB
|
|
014 Summary Tools for Organizing, Cleaning & Managing Data in Excel.html
|
2.2 KB
|
|
015 Special Message - You've Got This!.mp4
|
10.4 MB
|
|
015 Special Message - You've Got This!_en.srt
|
3.1 KB
|
|
/08 - Formatting including Conditional & Number Formatting in Excel/
|
|
001 Overview - All About Formatting.mp4
|
29.6 MB
|
|
001 Overview - All About Formatting_en.srt
|
2.0 KB
|
|
001 S8-Excel-Formatting-START.xlsx
|
44.2 KB
|
|
001 S8-Excel-Formatting.xlsx
|
47.7 KB
|
|
001 Smart-Ways-to-Use-Custom-Formatting.url
|
0.1 KB
|
|
002 Excel Formatting Tips - Alignment, Borders & More.mp4
|
24.7 MB
|
|
002 Excel Formatting Tips - Alignment, Borders & More_en.srt
|
7.4 KB
|
|
003 Better Than Merge (Become Pro).mp4
|
13.3 MB
|
|
003 Better Than Merge (Become Pro)_en.srt
|
4.5 KB
|
|
004 Justify Text Length (Hidden Excel Feature).mp4
|
14.2 MB
|
|
004 Justify Text Length (Hidden Excel Feature)_en.srt
|
3.6 KB
|
|
005 Excel Number Formatting Options (& Special Formatting).mp4
|
28.8 MB
|
|
005 Excel Number Formatting Options (& Special Formatting)_en.srt
|
5.5 KB
|
|
006 Excel Conditional Formatting (Top Bottom Analysis & More).mp4
|
67.3 MB
|
|
006 Excel Conditional Formatting (Top Bottom Analysis & More)_en.srt
|
8.2 KB
|
|
007 Icons & Data Bars with Conditional Formatting in Excel.mp4
|
51.1 MB
|
|
007 Icons & Data Bars with Conditional Formatting in Excel_en.srt
|
9.1 KB
|
|
008 Challenge Format Excel Report.html
|
0.9 KB
|
|
009 Solution Format Excel Report Challenge.mp4
|
21.1 MB
|
|
009 Solution Format Excel Report Challenge_en.srt
|
9.4 KB
|
|
010 Summary Useful Excel Formatting Tools.html
|
1.4 KB
|
|
external-links.txt
|
0.1 KB
|
|
/09 - Printing Excel Files & Saving as PDF/
|
|
001 Checklist Before Printing.mp4
|
10.8 MB
|
|
001 Checklist Before Printing_en.srt
|
3.0 KB
|
|
001 S9-Excel-Print-START.xlsx
|
63.4 KB
|
|
001 S9-Excel-Print.xlsx
|
71.8 KB
|
|
002 Useful Printing Options in Excel.mp4
|
25.4 MB
|
|
002 Useful Printing Options in Excel_en.srt
|
6.3 KB
|
|
003 Adding Page Breaks & Printing Parts of a Sheet.mp4
|
24.0 MB
|
|
003 Adding Page Breaks & Printing Parts of a Sheet_en.srt
|
5.9 KB
|
|
004 Printing Large Datasets (Make sure you include this!).mp4
|
42.1 MB
|
|
004 Printing Large Datasets (Make sure you include this!)_en.srt
|
5.2 KB
|
|
005 Header & Footer in Excel (Logo, Page Numbers, etc.).mp4
|
38.5 MB
|
|
005 Header & Footer in Excel (Logo, Page Numbers, etc.)_en.srt
|
5.3 KB
|
|
006 Saving Excel Files PDF & Printing Many Sheets.mp4
|
21.3 MB
|
|
006 Saving Excel Files PDF & Printing Many Sheets_en.srt
|
5.3 KB
|
|
007 Challenge Prepare Excel Report for Printing.html
|
0.8 KB
|
|
008 Solution Prepare Excel Report for Printing.mp4
|
25.5 MB
|
|
008 Solution Prepare Excel Report for Printing_en.srt
|
4.3 KB
|
|
009 Summary Excel Printing Checklist.html
|
1.6 KB
|
|
/10 - Workbook Design Principles/
|
|
001 Good Spreadsheet Design Principles (with Examples).mp4
|
99.3 MB
|
|
001 Good Spreadsheet Design Principles (with Examples)_en.srt
|
7.4 KB
|
|
001 S10-Excel-DesignPrinciples-START.xlsx
|
133.0 KB
|
|
001 S10-Excel-DesignPrinciples.xlsx
|
147.6 KB
|
|
002 Adding Hyperlinks (Plus a Smart Workaround) in Excel.mp4
|
36.1 MB
|
|
002 Adding Hyperlinks (Plus a Smart Workaround) in Excel_en.srt
|
8.8 KB
|
|
003 Define Cell Styles & Set Defaults (e.g. for Excel Tables).mp4
|
23.6 MB
|
|
003 Define Cell Styles & Set Defaults (e.g. for Excel Tables)_en.srt
|
7.9 KB
|
|
004 Excel Workbook Theme & Color to Save Time.mp4
|
20.2 MB
|
|
004 Excel Workbook Theme & Color to Save Time_en.srt
|
7.6 KB
|
|
005 Use Your Own Excel Templates.mp4
|
18.3 MB
|
|
005 Use Your Own Excel Templates_en.srt
|
5.5 KB
|
|
006 Summary Excel Workbook Design Principles.html
|
1.8 KB
|
|
/11 - Working With Excel Charts/
|
|
001 Overview - Create Helpful Excel Charts.mp4
|
6.7 MB
|
|
001 Overview - Create Helpful Excel Charts_en.srt
|
3.4 KB
|
|
001 S11-Excel-Charts-START.xlsx
|
45.9 KB
|
|
001 S11-Excel-Charts.xlsx
|
114.7 KB
|
|
002 Excel Chart Basics for a Quick Start.mp4
|
102.0 MB
|
|
002 Excel Chart Basics for a Quick Start_en.srt
|
16.9 KB
|
|
003 Adding More Series to a Chart (Comparison Charts - Method 1).mp4
|
30.3 MB
|
|
003 Adding More Series to a Chart (Comparison Charts - Method 1)_en.srt
|
9.4 KB
|
|
004 Comparison Excel Charts - Actual & Variance (Method 2).mp4
|
30.0 MB
|
|
004 Comparison Excel Charts - Actual & Variance (Method 2)_en.srt
|
8.6 KB
|
|
005 Combination Charts (Plus a Hidden Excel Feature).mp4
|
29.4 MB
|
|
005 Combination Charts (Plus a Hidden Excel Feature)_en.srt
|
9.3 KB
|
|
006 Dynamic Chart Ranges with Excel Tables.mp4
|
7.4 MB
|
|
006 Dynamic Chart Ranges with Excel Tables_en.srt
|
3.4 KB
|
|
007 Pareto & Histogram Excel Charts.mp4
|
31.4 MB
|
|
007 Pareto & Histogram Excel Charts_en.srt
|
9.1 KB
|
|
008 Treemap Chart in Excel.mp4
|
40.6 MB
|
|
008 Treemap Chart in Excel_en.srt
|
9.8 KB
|
|
009 Sunburst, Pie & Doughnut Excel Charts.mp4
|
36.3 MB
|
|
009 Sunburst, Pie & Doughnut Excel Charts_en.srt
|
9.3 KB
|
|
010 Sparklines - Mini Excel Charts Inside Cells.mp4
|
33.4 MB
|
|
010 Sparklines - Mini Excel Charts Inside Cells_en.srt
|
8.9 KB
|
|
011 Challenge Treemap for Management Report.html
|
0.9 KB
|
|
012 Solution Treemap for Management Report.mp4
|
96.2 MB
|
|
012 Solution Treemap for Management Report_en.srt
|
8.5 KB
|
|
013 Summary Working with Excel Charts.html
|
1.8 KB
|
|
/12 - Quick Insights with Excel Pivot Tables/
|
|
001 Benefits of Excel Pivot Tables & Starting Checklist.mp4
|
4.4 MB
|
|
001 Benefits of Excel Pivot Tables & Starting Checklist_en.srt
|
1.5 KB
|
|
001 S12-Excel-PivotTables-START.xlsx
|
62.9 KB
|
|
001 S12-Excel-PivotTables.xlsx
|
102.1 KB
|
|
002 Inserting a Pivot Table in Excel.mp4
|
121.5 MB
|
|
002 Inserting a Pivot Table in Excel_en.srt
|
15.0 KB
|
|
003 Why You Should Use Tables as Pivot Source (Become Pro).mp4
|
38.3 MB
|
|
003 Why You Should Use Tables as Pivot Source (Become Pro)_en.srt
|
3.2 KB
|
|
004 Sorting Pivot Data & Analyzing Multiple Items.mp4
|
71.5 MB
|
|
004 Sorting Pivot Data & Analyzing Multiple Items_en.srt
|
9.2 KB
|
|
005 Adding Calculations & Multiple Reports with Pivot Tables.mp4
|
58.8 MB
|
|
005 Adding Calculations & Multiple Reports with Pivot Tables_en.srt
|
7.0 KB
|
|
006 Using Slicers & Timeline (Working with Dates) in Excel.mp4
|
49.8 MB
|
|
006 Using Slicers & Timeline (Working with Dates) in Excel_en.srt
|
11.0 KB
|
|
007 Creating Pivot Charts.mp4
|
45.2 MB
|
|
007 Creating Pivot Charts_en.srt
|
10.7 KB
|
|
008 Pivot Tables or Formulas When to Use What.mp4
|
6.5 MB
|
|
008 Pivot Tables or Formulas When to Use What_en.srt
|
2.9 KB
|
|
009 Challenge Excel Data Analysis with Pivot Tables.html
|
0.9 KB
|
|
010 Solution Excel Data Analysis with Pivot Tables.mp4
|
48.5 MB
|
|
010 Solution Excel Data Analysis with Pivot Tables_en.srt
|
8.3 KB
|
|
011 Summary Important Pivot Table Features.html
|
2.4 KB
|
|
/13 - Introduction to Power Query in Excel/
|
|
001 Import-Sample-Data-PowerQuery.txt
|
6.2 KB
|
|
001 Power Query, Power Pivot & Power BI - When to use which.mp4
|
64.7 MB
|
|
001 Power Query, Power Pivot & Power BI - When to use which_en.srt
|
5.3 KB
|
|
001 S13-Excel-PowerQuery-START.xlsx
|
41.0 KB
|
|
001 S13-Excel-PowerQuery.xlsx
|
82.8 KB
|
|
002 Availability of Power Query Get & Transform.html
|
0.8 KB
|
|
003 Import Text File with Power Query.mp4
|
119.4 MB
|
|
003 Import Text File with Power Query_en.srt
|
16.8 KB
|
|
004 Merge data in Power Query (for Pivot Table).mp4
|
31.6 MB
|
|
004 Merge data in Power Query (for Pivot Table)_en.srt
|
10.1 KB
|
|
005 Clean up Messy Excel Data (multiple headers, unpivot etc.).mp4
|
139.2 MB
|
|
005 Clean up Messy Excel Data (multiple headers, unpivot etc.)_en.srt
|
14.9 KB
|
|
006 Challenge Data Cleanup with Power Query.html
|
1.0 KB
|
|
007 Solution Data Cleanup with Power Query.mp4
|
59.2 MB
|
|
007 Solution Data Cleanup with Power Query_en.srt
|
9.3 KB
|
|
008 Summary Key Takeaways Excel Power Query.html
|
1.0 KB
|
|
/14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/
|
|
001 Excel Dynamic Arrays & New Functions in Microsoft 365.mp4
|
52.3 MB
|
|
001 Excel Dynamic Arrays & New Functions in Microsoft 365_en.srt
|
4.7 KB
|
|
001 S365-Excel-Functions-2020-START.xlsx
|
39.1 KB
|
|
001 S365-Excel-Functions-2020.xlsx
|
43.0 KB
|
|
002 Availability of the New Excel Functions.html
|
0.6 KB
|
|
003 Excel's New Calculation Engine Spill Error and @(at) sign.mp4
|
66.7 MB
|
|
003 Excel's New Calculation Engine Spill Error and @(at) sign_en.srt
|
14.5 KB
|
|
004 Excel UNIQUE Function Get List of Distinct Values.mp4
|
70.8 MB
|
|
004 Excel UNIQUE Function Get List of Distinct Values_en.srt
|
8.6 KB
|
|
005 Excel SORT & SORTBY Functions.mp4
|
105.6 MB
|
|
005 Excel SORT & SORTBY Functions_en.srt
|
12.2 KB
|
|
006 Excel FILTER Function Return Multiple Match Results.mp4
|
84.4 MB
|
|
006 Excel FILTER Function Return Multiple Match Results_en.srt
|
12.1 KB
|
|
007 Excel XLOOKUP Function The New Power Lookup Function.mp4
|
55.5 MB
|
|
007 Excel XLOOKUP Function The New Power Lookup Function_en.srt
|
13.3 KB
|
|
008 Challenge Get Total Salary by Division.html
|
1.1 KB
|
|
009 Solution Get Total Salary by Division.mp4
|
43.4 MB
|
|
009 Solution Get Total Salary by Division_en.srt
|
9.8 KB
|
|
/15 - Next Steps/
|
|
001 Your Next Steps & More Learning.mp4
|
32.1 MB
|
|
001 Your Next Steps & More Learning_en.srt
|
2.7 KB
|
|
002 BONUS - More from Leila.html
|
5.8 KB
|
|
Total files 297
|
