| 001 Applying VLOOKUP function.mp4 | 58.5 MB | ||
| 001 Applying VLOOKUP function_en.vtt | 3.4 KB | ||
| 001 Applying the sort function.mp4 | 29.5 MB | ||
| 001 Applying the sort function_en.vtt | 1.8 KB | ||
| 001 Basics of Data Visualizations.mp4 | 41.8 MB | ||
| 001 Basics of Data Visualizations_en.vtt | 2 KB | ||
| 001 Bonus Lecture.html | 4.7 KB | ||
| 001 Conclusion.mp4 | 46.3 MB | ||
| 001 Conclusion_en.vtt | 2.5 KB | ||
| 001 Goal Seek Analysis.mp4 | 42.8 MB | ||
| 001 Goal Seek Analysis_en.vtt | 3 KB | ||
| 001 How is Excel important to businesses.mp4 | 49.3 MB | ||
| 001 How is Excel important to businesses_en.vtt | 2.5 KB | ||
| 001 Making Pivot Tables.mp4 | 44.3 MB | ||
| 001 Making Pivot Tables_en.vtt | 3.2 KB | ||
| 001 Understanding Regression.mp4 | 39 MB | ||
| 001 Understanding Regression_en.vtt | 1.8 KB | ||
| 001 Using Colorbars for formatting.mp4 | 31 MB | ||
| 001 Using Colorbars for formatting_en.vtt | 1.8 KB | ||
| 001 Using the IF function.mp4 | 28.2 MB | ||
| 001 Using the IF function_en.vtt | 1.4 KB | ||
| 001 Using the MIN, MAX AVERAGE functions.mp4 | 36.6 MB | ||
| 001 Using the MIN, MAX AVERAGE functions_en.vtt | 1.9 KB | ||
| 001 Using the UPPER, LOWER and PROPER functions.mp4 | 54.9 MB | ||
| 001 Using the UPPER, LOWER and PROPER functions_en.vtt | 2.9 KB | ||
| 001 Why to use Index and Match_.mp4 | 52.1 MB | ||
| 001 Why to use Index and Match__en.vtt | 2.2 KB | ||
| 002 Applying HLOOKUP function.mp4 | 25.6 MB | ||
| 002 Applying HLOOKUP function_en.vtt | 1.9 KB | ||
| 002 Applying Index and Match.mp4 | 38.4 MB | ||
| 002 Applying Index and Match_en.vtt | 2.4 KB | ||
| 002 Applying the filter function.mp4 | 26.9 MB | ||
| 002 Applying the filter function_en.vtt | 1.5 KB | ||
| 002 Data Tables.mp4 | 32.8 MB | ||
| 002 Data Tables_en.vtt | 2.4 KB | ||
| 002 Finding the Standard deviations.mp4 | 49.6 MB | ||
| 002 Finding the Standard deviations_en.vtt | 2.6 KB | ||
| 002 How to Get Your Certificate of Completion.html | 512 B | ||
| 002 Making Charts in Excel.mp4 | 50.5 MB | ||
| 002 Making Charts in Excel_en.vtt | 3.4 KB | ||
| 002 Making Pivot Charts.mp4 | 28.4 MB | ||
| 002 Making Pivot Charts_en.vtt | 1.8 KB | ||
| 002 Performing Linear Regression.mp4 | 33.6 MB | ||
| 002 Performing Linear Regression_en.vtt | 2.1 KB | ||
| 002 Understanding the excel interface.mp4 | 26.8 MB | ||
| 002 Understanding the excel interface_en.vtt | 2.1 KB | ||
| 002 Using Colorscales for formatting.mp4 | 30.8 MB | ||
| 002 Using Colorscales for formatting_en.vtt | 1.5 KB | ||
| 002 Using the IF ERROR function.mp4 | 33.5 MB | ||
| 002 Using the IF ERROR function_en.vtt | 1.9 KB | ||
| 002 Using the LEFT, RIGHT and SEARCH functions.mp4 | 57.7 MB | ||
| 002 Using the LEFT, RIGHT and SEARCH functions_en.vtt | 3 KB | ||
| 003 Applying the COUNTIF function.mp4 | 34.2 MB | ||
| 003 Applying the COUNTIF function_en.vtt | 1.9 KB | ||
| 003 Applying the advanced filter function.mp4 | 42.4 MB | ||
| 003 Applying the advanced filter function_en.vtt | 2.3 KB | ||
| 003 Basic Formatting in Excel.mp4 | 35.9 MB | ||
| 003 Basic Formatting in Excel_en.vtt | 1.8 KB | ||
| 003 Find the percentiles of data.mp4 | 48.6 MB | ||
| 003 Find the percentiles of data_en.vtt | 2.9 KB | ||
| 003 Making Dashboards.mp4 | 38.8 MB | ||
| 003 Making Dashboards_en.vtt | 2.1 KB | ||
| 003 Quiz Solution.mp4 | 72.6 MB | ||
| 003 Quiz Solution_en.vtt | 4.9 KB | ||
| 003 Scenario Management.mp4 | 46.1 MB | ||
| 003 Scenario Management_en.vtt | 3.2 KB | ||
| 003 Using the TRIM, CONCAT and LEN functions.mp4 | 48.3 MB | ||
| 003 Using the TRIM, CONCAT and LEN functions_en.vtt | 2.5 KB | ||
| 004 Adding Slicers in Dashbaords.mp4 | 33 MB | ||
| 004 Adding Slicers in Dashbaords_en.vtt | 2.4 KB | ||
| 004 Applying the SUMIF function.mp4 | 30.6 MB | ||
| 004 Applying the SUMIF function_en.vtt | 1.7 KB | ||
| 004 Exercise on Conditional Formatting.mp4 | 57.8 MB | ||
| 004 Exercise on Conditional Formatting_en.vtt | 2.9 KB | ||
| 004 Exercise on Index and Match Functions.mp4 | 55.9 MB | ||
| 004 Exercise on Index and Match Functions_en.vtt | 2.8 KB | ||
| 004 Exercise on Lookup Functions.mp4 | 42.1 MB | ||
| 004 Exercise on Lookup Functions_en.vtt | 2 KB | ||
| 004 Exercise on Pivot Tables.mp4 | 58.7 MB | ||
| 004 Exercise on Pivot Tables_en.vtt | 2.9 KB | ||
| 004 Finding the Outliers present in data.mp4 | 57.3 MB | ||
| 004 Finding the Outliers present in data_en.vtt | 3.2 KB | ||
| 004 Insertion and Deletion in Excel.mp4 | 37.1 MB | ||
| 004 Insertion and Deletion in Excel_en.vtt | 1.9 KB | ||
| 004 Quiz Solution.mp4 | 53.4 MB | ||
| 004 Quiz Solution_en.vtt | 3.9 KB | ||
| 005 Applying the AVERAGEIF function.mp4 | 32.1 MB | ||
| 005 Applying the AVERAGEIF function_en.vtt | 1.8 KB | ||
| 005 Data Types in Excel.mp4 | 68.8 MB | ||
| 005 Data Types in Excel_en.vtt | 5 KB | ||
| 005 Exercise on Filters.mp4 | 49.3 MB | ||
| 005 Exercise on Filters_en.vtt | 2.4 KB | ||
| 005 Exercise on Text Functions.mp4 | 66.6 MB | ||
| 005 Exercise on Text Functions_en.vtt | 3.2 KB | ||
| 005 Finding the Missing values in data.mp4 | 35.1 MB | ||
| 005 Finding the Missing values in data_en.vtt | 1.7 KB | ||
| 005 Formatting dashboards.mp4 | 27.9 MB | ||
| 005 Formatting dashboards_en.vtt | 1.8 KB | ||
| 005 Solution on Conditional Formatting.mp4 | 52.1 MB | ||
| 005 Solution on Conditional Formatting_en.vtt | 4.1 KB | ||
| 005 Solution on Index and Match Functions.mp4 | 70.4 MB | ||
| 005 Solution on Index and Match Functions_en.vtt | 6.3 KB | ||
| 005 Solution on Lookup Functions.mp4 | 49.4 MB | ||
| 005 Solution on Lookup Functions_en.vtt | 4.4 KB | ||
| 005 Solution on Pivot Tables.mp4 | 48.1 MB | ||
| 005 Solution on Pivot Tables_en.vtt | 3.9 KB | ||
| 006 Quiz Solution.mp4 | 39.2 MB | ||
| 006 Quiz Solution_en.vtt | 3 KB | ||
| 006 Solution on Filters.mp4 | 54.8 MB | ||
| 006 Solution on Filters_en.vtt | 3.8 KB | ||
| 006 Solution on Text Functions.mp4 | 63.7 MB | ||
| 006 Solution on Text Functions_en.vtt | 5.6 KB | ||
| 007 Exercise on Data Visualizations.mp4 | 57.3 MB | ||
| 007 Exercise on Data Visualizations_en.vtt | 2.7 KB | ||
| 007 Exercise on Descriptive Statistics.mp4 | 61.3 MB | ||
| 007 Exercise on Descriptive Statistics_en.vtt | 2.9 KB | ||
| 007 Exercise on Logical Functions.mp4 | 67.6 MB | ||
| 007 Exercise on Logical Functions_en.vtt | 3.5 KB | ||
| 008 Solution on Data Visualizations.mp4 | 47.1 MB | ||
| 008 Solution on Data Visualizations_en.vtt | 3.7 KB | ||
| 008 Solution on Descriptive Statistics.mp4 | 58 MB | ||
| 008 Solution on Descriptive Statistics_en.vtt | 4.4 KB | ||
| 008 Solution on Logical Functions.mp4 | 60.5 MB | ||
| 008 Solution on Logical Functions_en.vtt | 6.6 KB | ||
| 009 Exercise on Dashboards.mp4 | 39.5 MB | ||
| 009 Exercise on Dashboards_en.vtt | 1.8 KB | ||
| 009 Exercise on Data Cleaning.mp4 | 54 MB | ||
| 009 Exercise on Data Cleaning_en.vtt | 2.7 KB | ||
| 010 Solution on Dashboards.mp4 | 62.1 MB | ||
| 010 Solution on Dashboards_en.vtt | 5.6 KB | ||
| 010 Solution on Data Cleaning.mp4 | 76.1 MB | ||
| 010 Solution on Data Cleaning_en.vtt | 6.6 KB | ||
| 37036824-pivot-3.xlsx | 16.2 KB | ||
| 37036832-Pivot-charts.xlsx | 278.3 KB | ||
| 37036996-Exercises-on-dashboard-and-visualization.xlsx | 278.3 KB | ||
| 37037008-pivot-exercise.xlsx | 32.6 KB | ||
| 37037012-pivot2.xlsx | 10.8 KB | ||
| 37037146-pivot-3.xlsx | 16.2 KB | ||
| 37037286-Exercises-on-Index-and-match.xlsx | 9 KB | ||
| 37037298-vlookup.xlsx | 10.6 KB | ||
| 37037310-vlookup-2.xlsx | 10.4 KB | ||
| 37037326-logical-data.xlsx | 10.5 KB | ||
| 37037346-logicalData.xlsx | 10.5 KB | ||
| 37037350-exams.xlsx | 65.6 KB | ||
| 37037462-exams.xlsx | 65.6 KB | ||
| 37037484-exams.xlsx | 65.6 KB | ||
| 37037664-market-fact.csv | 605.3 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Excel_Example.xls | 157 KB | ||
| Exercises on Conditional formatting.docx | 686.8 KB | ||
| Exercises on Data cleaning.docx | 325.6 KB | ||
| Exercises on Descriptive statistics.docx | 188.3 KB | ||
| Exercises on Filters.docx | 15.5 KB | ||
| Exercises on Index and match function.docx | 276 KB | ||
| Exercises on Logical function.docx | 258.8 KB | ||
| Exercises on Pivot table.docx | 314.8 KB | ||
| Exercises on dashboard and visualization.xlsx | 278.3 KB | ||
| Exercises on lookups.docx | 240.2 KB | ||
| Exercises on text function.docx | 403.6 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| MOCK_DATA.xlsx | 25.5 KB | ||
| Orders_data.xlsx | 1.5 MB | ||
| Salary_Data.xls | 20.5 KB | ||
| What if Analysis.xlsx | 15.1 KB | ||
| market_fact.csv | 605.3 KB | ||
| ▲ 189 total files | |||
Excel Data Analysis Masterclass with Excel Dashboards (updated 10/2021)
https://CoursePig.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.37 GB | Duration: 3h 59m
Master Advanced MS Excel topics - Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics
What you'll learn
Learn about basic formatting in excel.
Learn about sorting and filtering functions in excel.
Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.
Learn how to find outliers and missing values in Excel.
Learn how to find standard deviation and percentiles in data using Excel.
Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.
Learn about using Color Bars and Color scales in excel.
Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
Learn how to merge datasets using Index and match.
Learn making Pivot Tables and Pivot charts in excel.
Learn making interactive dashboards in excel.
Learn about What-if analysis in excel.
Learn how to perform linear regression in excel.
Quizzes and exercises.
Turn real world data into business insights in Excel.
Best Practices for dashboard development, table and graph design.
Discover the most Powerful tool in Excel to transform your Data into Insight and intelligence.
Requirements
No prior knowledge required.
Determination and Desire to learn new things.
A positive attitude to success.
A willingness to learn and practice.
Description
Welcome to the best online course on Excel.
Microsoft Excel is one of the most used software applications of all time.
Hundreds of millions of people around the world use Excel.
It is a very handy software that can be used to store and organize many datasets.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 272 MB | freecoursewb | 3 weeks | 24 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 1 month | 0 | 0 |
| 2.7 GB | freecoursewb | 2 months | 12 | 1 | |
| 2.7 GB | freecoursewb | 2 months | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 2 months | 9 | 5 |
All Comments