23 OCT 2025 - We are back! If you have been following us over the last few years, you will know that the last 2 months have been rough. We website was practically not loading. Sorry for the mess. We are back though and everything should run smoothly now. New servers. Updated domains. And new owners. We invite you all to start uploading torrents again!
TORRENT DETAILS
[ WebToolTip.com ] Udemy - Data Analysis Using Excel
Language: English | Duration: 3h 24m | Size: 1.72 GB
Using formula, charts, pivot tables , what-if analysis and Solver add-in to understand complex data
What you'll learn
Learn how to create formulae and identify the right formula for a use case. Troubleshoot and debugging of formulae
Add visualization techniques i.e. charts, pivot charts and sparklines to tables and format the charts
Analyse the data using pivot tables. Understand the different options available in pivot tables
Use Excel for forecasting, what-if analysis and optimization technique using the Solver add-in
Building interactive dashboards using Excel
Requirements
This course requires that learners should have Microsoft Excel installed on their device. Basic knowledge of Microsoft Excel - i.e. opening and saving file and manual data entry knowledge is required. No advanced knowledge of excel is required. This course has been created using Excel 2019. This course will work for Excel 2019 and above. Most of the course will work for all versions of Excel. However, the menu options may change slightly depending upon the specific version used.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4
8.4 MB
~Get Your Files Here !/2 - Module1 Using Formulae/1 - Formula Introduction - StudentDataMaster.xlsx
31.7 KB
~Get Your Files Here !/2 - Module1 Using Formulae/1 - Formula Introduction.mp4
2.9 MB
~Get Your Files Here !/2 - Module1 Using Formulae/10 - Finding the right Function.mp4
36.6 MB
~Get Your Files Here !/2 - Module1 Using Formulae/11 - Conditional Counting in Excel.mp4
138.5 MB
~Get Your Files Here !/2 - Module1 Using Formulae/12 - Using Name Manager in Formulae.mp4
31.7 MB
~Get Your Files Here !/2 - Module1 Using Formulae/13 - Calculation Options in Formulae.mp4
26.9 MB
~Get Your Files Here !/2 - Module1 Using Formulae/14 - Debugging Formulae - FormulaAuditingMaster.xlsx
11.5 KB
~Get Your Files Here !/2 - Module1 Using Formulae/14 - Debugging Formulae.mp4
28.7 MB
~Get Your Files Here !/2 - Module1 Using Formulae/15 - Using Watch Window for Debugging.mp4
16.6 MB
~Get Your Files Here !/2 - Module1 Using Formulae/2 - Creating first formula Summation Formula.mp4
25.8 MB
~Get Your Files Here !/2 - Module1 Using Formulae/3 - Creating Mathematical Formulae and Using Named References.mp4
28.5 MB
~Get Your Files Here !/2 - Module1 Using Formulae/4 - Creating Functions that work with text input.mp4
42 MB
~Get Your Files Here !/2 - Module1 Using Formulae/5 - Creating Nested Functions.mp4
25.9 MB
~Get Your Files Here !/2 - Module1 Using Formulae/6 - Creating Formula that use logical operators.mp4
39.5 MB
~Get Your Files Here !/2 - Module1 Using Formulae/7 - Creating Nested Logical Functions.mp4
30.2 MB
~Get Your Files Here !/2 - Module1 Using Formulae/8 - Using the lookup function.mp4
59.3 MB
~Get Your Files Here !/2 - Module1 Using Formulae/9 - Functions that work with dates.mp4
27.1 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/1 - Charts Introduction - CreatingChartsMaster.xlsx
10.8 KB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/1 - Charts Introduction.mp4
1.6 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/2 - Creating a simple chart.mp4
20.3 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/3 - Options for Formatting Charts.mp4
31.5 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/4 - Formatting Axis on Charts.mp4
33.1 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/5 - Formatting Data on Charts.mp4
22.7 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/6 - Formatting Legends And Gridlines on Charts.mp4
10.9 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/7 - Changing Chart Styles, Chart Data and Chart Type.mp4
40.9 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/8 - Adding Error Lines, Trend Lines Drop Lines in Charts.mp4
36.6 MB
~Get Your Files Here !/3 - Module2 Data Visualization Using Charts/9 - Selecting the most appropriate Chart.mp4
21.2 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/1 - Pivot Table Introduction - PivotTablesMaster.xlsx
8.8 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/1 - Pivot Table Introduction.mp4
3.6 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/10 - Formatting Pivot Tables.mp4
71.7 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/11 - Creating Pivot Charts.mp4
56.9 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/2 - Creating a Pivot Table.mp4
34.6 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/3 - Creating Hierarchies In Pivot Table.mp4
50 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/4 - Applying Filters In Pivot Table.mp4
11.6 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/5 - Formulae In Pivot Tables.mp4
16.2 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/6 - Data Comparison In Pivot Tables.mp4
179 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/7 - Analyzing Individual Data Points in Pivot Table.mp4
39.1 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/8 - Working with Slicers.mp4
46.2 MB
~Get Your Files Here !/4 - Module 3 Pivot Tables and Pivot Charts/9 - Working with Timelines.mp4
59.3 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/1 - Introduction to Sparklines, Headers and Footers.mp4
3.3 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/2 - Creating Sparklines.mp4
24.5 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/3 - Features of a Sparklines.mp4
25.6 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/4 - Types of Sparklines.mp4
30.1 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/5 - Sparklines In Pivot Tables.mp4
18.8 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/6 - Creating Headers and Footers.mp4
24.1 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/7 - Header and Footer Features.mp4
18 MB
~Get Your Files Here !/5 - Module 4 Adding Sparklines, Headers and Footers/8 - Printing Headers and Footers.mp4
12.2 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/1 - Introduction to Forecasting In Excel - ForecastingMaster.xlsx
8.8 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/1 - Introduction to Forecasting In Excel.mp4
2.1 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/2 - Creating a Forecast.mp4
8.2 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/3 - Forecasting Options.mp4
40.6 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/4 - Forecasting Multiple Data Points.mp4
9.7 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/5 - What If Analysis Goal Seek.mp4
12.3 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/6 - What If Analysis Data Table.mp4
13.9 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/7 - What If Analysis Scenario Manager.mp4
17.7 MB
~Get Your Files Here !/6 - Module 5 Problem Solving Using Excel/8 - Using Solver Add-In.mp4
34.4 MB
~Get Your Files Here !/7 - Module 6 Interactive Dashboard using Excel/1 - Introduction to Dashboards - DashboardMaster.xlsx
338.9 KB
~Get Your Files Here !/7 - Module 6 Interactive Dashboard using Excel/1 - Introduction to Dashboards.mp4
1.6 MB
~Get Your Files Here !/7 - Module 6 Interactive Dashboard using Excel/2 - Dashboard Explained.mp4
19.3 MB
~Get Your Files Here !/7 - Module 6 Interactive Dashboard using Excel/3 - Creating Pivot Tables.mp4
9.6 MB
~Get Your Files Here !/7 - Module 6 Interactive Dashboard using Excel/4 - Creating Dashboard Slicers.mp4
21.9 MB
~Get Your Files Here !/7 - Module 6 Interactive Dashboard using Excel/5 - Tying together Dashboard Elements.mp4
![[ WebToolTip.com ] Udemy - Data Analysis Using Excel](https://f.t0r.space/no-cover.webp)
