TGx:Udemy | Mastering Data Analysis in Excel FTU] TGx Exclusive

Hot Picks

First Cam

New Movies

1080p x265

New TV

Misc

Torrent details for "Udemy | Mastering Data Analysis in Excel FTU] TGx Exclusive" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

Udemy | Mastering Data Analysis in Excel FTU] TGx Exclusive

Controls:

Report Torrent

Torrent verified by Prom3th3uS

Category:

Other > Training

Language:

English

Total Size:

2.74 GB

Info Hash:

4fe51aa220490311b5696977e398b2095a3c9c20

Added By:

Prom3th3uS :_verified_uploader:

Added:

02-10-2019 00:34

Views:

854

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

255

File	Size
0. Websites you may like/0. (1Hack.Us) Premium Tutorials-Guides-Articles & Community based Forum.url	377.00 B
0. Websites you may like/1. (FreeTutorials.Us) Download Udemy Paid Courses For Free.url	328.00 B
0. Websites you may like/2. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url	286.00 B
0. Websites you may like/3. (NulledPremium.com) Download E-Learning, E-Books, Audio-Books, Comics, Articles and more... etc.url	163.00 B
0. Websites you may like/4. (FTUApps.com) Download Cracked Developers Applications For Free.url	239.00 B
0. Websites you may like/How you can help Team-FTU.txt	229.00 B
1. Getting Started/1. Greetings.mp4	17.28 MB
1. Getting Started/1. Greetings.vtt	2.04 kB
1. Getting Started/2. MS Excel for data analysis.mp4	16.40 MB
1. Getting Started/2. MS Excel for data analysis.vtt	1.87 kB
1. Getting Started/3. Download the Working Data.html	49.00 B
1. Getting Started/3.1 Working data_clean.xlsx.xlsx	6.27 MB
10. Final Tricks/1. Protect Worksheet and Workbook.mp4	41.09 MB
10. Final Tricks/1. Protect Worksheet and Workbook.vtt	3.00 kB
10. Final Tricks/2. Hot Shortcuts for Working in Excel.html	72.00 B
10. Final Tricks/2.1 The list of hot keys in Excel.docx.docx	14.96 kB
10. Final Tricks/3. Wrapping Up.mp4	7.61 MB
10. Final Tricks/3. Wrapping Up.vtt	1,012.00 B
11. Your Special Bonus!/1. Introduction to Power Add-ins in Excel.mp4	27.21 MB
11. Your Special Bonus!/1. Introduction to Power Add-ins in Excel.vtt	2.19 kB
11. Your Special Bonus!/2. Bonus Coupon of My Next Course!.html	188.00 B
2. Cleaning and Preparing Tools/1. Introduction to the Task.mp4	26.42 MB
2. Cleaning and Preparing Tools/1. Introduction to the Task.vtt	2.58 kB
2. Cleaning and Preparing Tools/2. Sort and Filter.mp4	95.45 MB
2. Cleaning and Preparing Tools/2. Sort and Filter.vtt	6.04 kB
2. Cleaning and Preparing Tools/3. Text to Columns.mp4	71.39 MB
2. Cleaning and Preparing Tools/3. Text to Columns.vtt	4.30 kB
2. Cleaning and Preparing Tools/4. Remove Duplicates.mp4	61.19 MB
2. Cleaning and Preparing Tools/4. Remove Duplicates.vtt	3.46 kB
2. Cleaning and Preparing Tools/5. Data Validation.mp4	102.74 MB
2. Cleaning and Preparing Tools/5. Data Validation.vtt	5.49 kB
2. Cleaning and Preparing Tools/5.1 Data Validation.xlsx.xlsx	15.39 kB
2. Cleaning and Preparing Tools/6. Find, Replace, Go to.mp4	56.37 MB
2. Cleaning and Preparing Tools/6. Find, Replace, Go to.vtt	2.94 kB
2. Cleaning and Preparing Tools/7. Data Entry Form.mp4	32.53 MB
2. Cleaning and Preparing Tools/7. Data Entry Form.vtt	2.24 kB
2. Cleaning and Preparing Tools/8. Quiz 1.html	146.00 B
3. 50 Most Frequently Used Functions/1. Logical Functions IF, AND, OR.mp4	140.72 MB
3. 50 Most Frequently Used Functions/1. Logical Functions IF, AND, OR.vtt	5.37 kB
3. 50 Most Frequently Used Functions/2. SUBTOTAL vs SUM.mp4	89.13 MB
3. 50 Most Frequently Used Functions/2. SUBTOTAL vs SUM.vtt	4.06 kB
3. 50 Most Frequently Used Functions/3. Text Fuctions RIGHT, LEFT, LEN, CONCATENATE, UPPER, LOWER.mp4	122.42 MB
3. 50 Most Frequently Used Functions/3. Text Fuctions RIGHT, LEFT, LEN, CONCATENATE, UPPER, LOWER.vtt	5.21 kB
3. 50 Most Frequently Used Functions/4. Date Functions YEAR, MONTH, DAY, EOMONTH, DATE.mp4	63.75 MB
3. 50 Most Frequently Used Functions/4. Date Functions YEAR, MONTH, DAY, EOMONTH, DATE.vtt	3.76 kB
3. 50 Most Frequently Used Functions/5. Math Functions SUMIF, COUNTIF, SUMIFS, COUNTIFS.mp4	116.76 MB
3. 50 Most Frequently Used Functions/6. Statistical Functions MAX, MIN, MEAN, MEDIAN, MODE, VAR, StdDev, CORREL.mp4	99.87 MB
3. 50 Most Frequently Used Functions/6. Statistical Functions MAX, MIN, MEAN, MEDIAN, MODE, VAR, StdDev, CORREL.vtt	6.73 kB
3. 50 Most Frequently Used Functions/7. Financial Functions PMT, PV, RATE, NPER, NPV, IRR.mp4	63.11 MB
3. 50 Most Frequently Used Functions/7. Financial Functions PMT, PV, RATE, NPER, NPV, IRR.vtt	5.67 kB
3. 50 Most Frequently Used Functions/7.1 Financial Analysis.xlsx.xlsx	13.07 kB
3. 50 Most Frequently Used Functions/8. Quiz 2.html	146.00 B
4. PivotTable for Data Analysis/1. Introduction to PivotTable.mp4	86.36 MB
4. PivotTable for Data Analysis/1. Introduction to PivotTable.vtt	5.76 kB
4. PivotTable for Data Analysis/2. Calculations by PivotTable.mp4	141.24 MB
4. PivotTable for Data Analysis/2. Calculations by PivotTable.vtt	7.86 kB
4. PivotTable for Data Analysis/3. GetPivotData.mp4	32.69 MB
5. What-If Analysis/1. What-If Analysis Goal Seek.mp4	93.51 MB
5. What-If Analysis/1. What-If Analysis Goal Seek.vtt	5.99 kB
5. What-If Analysis/2. What-If Analysis Data Table.mp4	41.74 MB
5. What-If Analysis/2. What-If Analysis Data Table.vtt	4.81 kB
5. What-If Analysis/2.1 Data Table.xlsx.xlsx	11.55 kB
5. What-If Analysis/3. What-If Analysis Scenario Manager.mp4	44.77 MB
5. What-If Analysis/3. What-If Analysis Scenario Manager.vtt	3.83 kB
5. What-If Analysis/4. Auditing Formulas.mp4	17.72 MB
5. What-If Analysis/4. Auditing Formulas.vtt	1.90 kB
5. What-If Analysis/5. Quiz 3.html	146.00 B
6. Merging Techniques/1. VLOOKUP With Exact Match.mp4	101.46 MB
6. Merging Techniques/1. VLOOKUP With Exact Match.vtt	6.17 kB
6. Merging Techniques/2. INDEX and MATCH vs VLOOKUP.mp4	91.58 MB
6. Merging Techniques/2. INDEX and MATCH vs VLOOKUP.vtt	5.66 kB
6. Merging Techniques/3. VLOOKUP With Approximate Match.mp4	68.05 MB
6. Merging Techniques/3. VLOOKUP With Approximate Match.vtt	3.07 kB
7. Smart and Interactive Tables/1. Format as Table.mp4	36.73 MB
7. Smart and Interactive Tables/1. Format as Table.vtt	2.36 kB
7. Smart and Interactive Tables/2. Data Model.mp4	47.67 MB
7. Smart and Interactive Tables/2. Data Model.vtt	4.06 kB
7. Smart and Interactive Tables/3. Slicer.mp4	36.15 MB
7. Smart and Interactive Tables/4. Quiz 4.html	146.00 B
8. Visualizing Data/1. Conditional Formatting.mp4	70.24 MB
8. Visualizing Data/1. Conditional Formatting.vtt	4.74 kB
8. Visualizing Data/10. Creation of the Interactive Dashboard.mp4	35.21 MB
8. Visualizing Data/10. Creation of the Interactive Dashboard.vtt	2.76 kB
8. Visualizing Data/11. Presenting of the Final Results.mp4	33.74 MB
8. Visualizing Data/11. Presenting of the Final Results.vtt	3.00 kB
8. Visualizing Data/12. Download the Completed File.html	51.00 B
8. Visualizing Data/12.1 Working data_complete.xlsx.xlsx	17.78 MB
8. Visualizing Data/13. Quiz 5.html	146.00 B
8. Visualizing Data/2. Sparklines as Mini Charts.mp4	35.13 MB
8. Visualizing Data/2. Sparklines as Mini Charts.vtt	2.38 kB
8. Visualizing Data/3. Column Chart and Bar Chart.mp4	55.03 MB
8. Visualizing Data/3. Column Chart and Bar Chart.vtt	4.47 kB
8. Visualizing Data/4. Line Chart.mp4	29.13 MB
8. Visualizing Data/4. Line Chart.vtt	1.91 kB
8. Visualizing Data/5. Pie Chart.mp4	18.45 MB
8. Visualizing Data/5. Pie Chart.vtt	1.88 kB
8. Visualizing Data/6. Area Chart.mp4	19.57 MB
8. Visualizing Data/6. Area Chart.vtt	1.51 kB
8. Visualizing Data/7. Combo Charts.mp4	37.74 MB
8. Visualizing Data/7. Combo Charts.vtt	2.83 kB
8. Visualizing Data/8. Speedometer Chart.mp4	55.64 MB
8. Visualizing Data/8. Speedometer Chart.vtt	4.13 kB
8. Visualizing Data/9. PivotChart.mp4	57.56 MB
8. Visualizing Data/9. PivotChart.vtt	4.06 kB
9. Data Analysis ToolPak/1. Scatter Plots.mp4	15.03 MB
9. Data Analysis ToolPak/1.1 Statistical Analysis _ clean.xlsx.xlsx	20.07 kB
9. Data Analysis ToolPak/2. Activation of Data Analysis ToolPak.mp4	9.77 MB
9. Data Analysis ToolPak/3. Descriptive Statistics.mp4	31.25 MB
9. Data Analysis ToolPak/4. Histogram.mp4	37.01 MB
9. Data Analysis ToolPak/5. Correlation.mp4	61.28 MB
9. Data Analysis ToolPak/6. Linear Regression.mp4	24.56 MB
9. Data Analysis ToolPak/7. Explanation of Regression Output.mp4	60.68 MB
9. Data Analysis ToolPak/8. Download the Results of Statistical Analysis.html	58.00 B
9. Data Analysis ToolPak/8.1 Statistical Analysis _ final.xlsx.xlsx	35.41 kB
9. Data Analysis ToolPak/9. Quiz 6.html	146.00 B

Thanks for rating :
sdev88 (5),

Description

For More Udemy Free Courses >>> https://freetutorials.us/
For more Lynda and other Courses >>> https://www.freecoursesonline.me/
Forum for discussion >>> https://1hack.us/

Learn advanced tools and techniques for data analysis in Excel using PivotTable, Data Analysis ToolPak, and much more

Created by: Vardges Zardaryan
Last updated: 9/2019
Language: English
Caption (CC): Included
Torrent Contains: 115 Files, 12 Folders
Course Source: https://www.udemy.com/course/mastering-data-analysis-in-excel-am/

What you'll learn

• Learn different techniques for data analysis that can be easily implemented in Excel 2010, 2013, 2016, and 2019
• Transform Data into insight using powerful methods of analysis, techniques and tools
• Bring your skills of Excel from Intermediate to Expert level
• Work with real-world data and solve real-world tasks
• Clean and prepare data for further analysis
• Learn 50 frequently used functions in Excel (Logical, Text, Date, Math, Statistical, Financial)
• Combine data from multiply worksheets by VLOOKUP, INDEX and MATCH functions
• Perform What-if analysis by Goal Seek, Data Table and Scenario Manager tools
• Learn best practices for data analysis and data presentation using PivotTable and PivotChart tools
• Learn best practices for the design and setup of interactive dashboards
• Perform statistical analysis by using Data Analysis ToolPak including Linear Regression
• Work in Excel faster by using hot key shortcuts

Course content
all 56 lectures 04:23:14

Requirements

• Basic knowledge of Excel
• Microsoft Excel 2010, 2013, 2016, 2019
• Passion for Excel

Description

<<LIMITED TIME OFFER: Enroll to this course for only $9.99 by using "EXCEL19" coupon code for access to full course and the certificate>>

4.5 hours professional course for everyone who wants to learn essentials of data analysis and visualization in Excel and become an advanced Excel user. Unlock the power of Excel to utilize its analytical tools — no matter your experience level.

All what you need to be able to:

- work with large real-world data sets,

- clean and prepare data for further analysis,

- combine data from multiply sheets using Vlookup, Index and Match functions,

- perform advanced calculations and sensitivity analysis,

- execute aggregation commands (SUM, SUBTOTAL, etc.) and their conditional variants (SUMIFS, COUNTIFS, etc.) to summarize data sets.,

- analyze data using Pivot Table, Pivot Chart, Slicer,

- visualize your results and prepare interactive charts and dashboards,

- perform statistical analysis by Data Analysis ToolPak,

- turn data into business insights.

All this we will do on the real-world data and will solve real-world tasks. You don't need to spend weeks and months to learn Excel. Start now, take all the steps with me, and in a few days you will feel very comfortable working in Excel and solving tasks in your job.

Good luck!

Who this course is for:

• Business analysts, Data analysts, Financial analysts, Risk managers, Reporting specialists.