Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Data Analysis Fundamentals with Excel

Posted By: IrGens
Data Analysis Fundamentals with Excel

Data Analysis Fundamentals with Excel
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 8h | 12.57 GB
Instructors: Chris Sorensen, Ammul Shergill

This video course takes youthe business user, business analyst, or data analystthrough an end-to-end solution for collecting, cleaning, importing, managing, and sharing data for operational and reporting purposes using Excel.

A story-based approach is used to teach you the data and analytics lifecycle. Learn the how and why behind the options available to you in Excel. These best practices go beyond just tips and tricks; learn pros and cons of the techniques to make you a more proficient analyst.

Instructors Chris Sorensen and Ammul Shergill have decades of experience helping companies and business professionals get the most out of their data. Together, Chris and Ammul will be your guides as you learn the fundamentals of data analysis with Excel and gain skills to design, build, and share Excel solutions.

Skill Level

Beginner-Intermediate

Learn How To

* Get and transform data
* Structure data for analysis in Excel
* Design data models
* Write formulas
* Create PivotTables and use PivotTable commands
* Create and format PivotCharts
* Build a reusable interactive dashboard
* Present meaningful, accessible analysis for effective decision making

Who Should Take This Course

* Excel users who need to level-up their analytics skills
* Professionals who need to produce accurate and timely analysis of business performance
* Business analysts who want to work on an end-to-end data analysis use case with Excel
* Business analysts who want to learn best practices for building sustainable data models
* MBAs who need to learn or refresh their knowledge of analyzing data with Excel

Course Requirements

This video assumes you have a basic understanding of Microsoft Excel, including menus and navigation, workbook components, and formulas.


Data Analysis Fundamentals with Excel