December 2020
Beginner to intermediate
8h
English
Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)
Overview
7+ Hours of Video Instruction
This video course takes you—the business user, business analyst, or data analyst—through 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.
Download the companion files for this LiveLesson from https://www.informit.com/store/data-analysis-fundamentals-with-excel-video-9780136915577.
About the Instructors
This video course takes you—the business user, business analyst, or data analyst—through 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.
Download the companion files for this LiveLesson from https://www.informit.com/store/data-analysis-fundamentals-with-excel-video-9780136915577.
About the Instructors
Chris Sorensen, MCSE (Data Management and Analytics) and Microsoft Certified Trainer, is the founder and president of Iteration Insights. Chris is a consultant, architect, educator, author, and coach with nearly 20 years of experience in the analytics space.
Ammul Shergill, MBA, is a principal consultant at Stratsyn Consulting where he designs, implements, and supports solutions for strategic business analysis.
Skill Level
Beginner-Intermediate
Learn How To
This video assumes you have a basic understanding of Microsoft Excel, including menus and navigation, workbook components, and formulas.
Ammul Shergill, MBA, is a principal consultant at Stratsyn Consulting where he designs, implements, and supports solutions for strategic business analysis.
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
- 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
This video assumes you have a basic understanding of Microsoft Excel, including menus and navigation, workbook components, and formulas.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.