Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

[ WebToolTip.com ] Udemy - Data Analysis Using Excel

Size
1.7 GB
Seeders
0
Leechers
2
Files
65
Category
Added
at 5:41pm GMT+1
Status
Not verified
Infohash
9445e3f4ec4b66584972f53f4655ddf7eb6ef9ba
Don't like banners? Log in and we will make sure you see no banners. For free.

Description

Data Analysis Using Excel


https://WebToolTip.com


Published 10/2025

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

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.

File list
  • [ WebToolTip.com ] Udemy - Data Analysis Using Excel
  • ~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 42.3 MB
  • ~Get Your Files Here !/8 - Recap/1 - Recap.mp4 6.5 MB
  • ~Get Your Files Here !/Bonus Resources.txt 70 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2.5 GB109
2.6 GB104
2.4 GB93
1.9 GB51
1.4 GB21
3.5 GB21
531 MB10
1.4 GB10
548 MB11
1.1 GB10
1.8 GB11
1.6 GB15
3.8 GB11
1.1 GB00
1.8 GB01