MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 3.5 hour | Size: 2.45 GB
Learn advanced tools and techniques for business data analysis in Excel using PivotTable, PivotChart and much more
What you’ll learn
Working with real-world data and solving real-world tasks
Turning data into business insights for decision-making
Cleaning and preparing data for further analysis
Using the important functions in Excel (Logical, Text, Date, Math, Statistical)
Calculating descriptive statistics and relationship between sets
Combining data from multiply tables by VLOOKUP, INDEX and MATCH functions
Analyzing data using PivotTable and PivotChart tools
Performing what-if analysis by Goal Seek, Data Table and Scenario Manager tools
Visualizing data and preparing interactive dashboards
Working in Excel by using hot shortcuts
Requirements
Basic knowledge of Excel
Description
3.5 hours professional course for everyone who wants to learn essentials of data analysis and visualization in Excel and become an advanced Excel user. All what you need to be able to:
– work with large 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,
– summarize values by different techniques,
– analyze data using Pivot Table, Pivot Chart, Slicer,
– visualize your results and prepare interactive dashboards,
– turn data into useful 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, Reporting specialists
Password/解压密码-0daydown
Download rapidgator
https://rg.to/file/a9a99232cf0ce067245f6f7e06c010e8/Mastering_Data_Analysis_in_Excel.part1.rar.html
https://rg.to/file/672c10b01db3ccdb2d5c574a6a1c0865/Mastering_Data_Analysis_in_Excel.part2.rar.html
https://rg.to/file/842633b0528ca998942c6df27732def9/Mastering_Data_Analysis_in_Excel.part3.rar.html
https://rg.to/file/84dd1ce5080f3a5187add7becaa9f98e/Mastering_Data_Analysis_in_Excel.part4.rar.html
Download nitroflare
http://nitroflare.com/view/C7E79041E98B6DD/Mastering_Data_Analysis_in_Excel.part1.rar
http://nitroflare.com/view/D8FC5B2E58BE3AF/Mastering_Data_Analysis_in_Excel.part2.rar
http://nitroflare.com/view/851118D310B5283/Mastering_Data_Analysis_in_Excel.part3.rar
http://nitroflare.com/view/5EA057CFCD2B933/Mastering_Data_Analysis_in_Excel.part4.rar
Download 百度云
你是VIP 1个月(1 month)赞助会员，