Media Summary: IN THIS LESSON: You'll use a range of aggregate, conditional IN THIS SECTION: You'll learn why Excel is the swiss army knife of IN THIS LESSON: I'll teach you the difference between a flat file or “database format”

Beyondformulas Modeling 5 Data Analysis - Detailed Analysis & Overview

IN THIS LESSON: You'll use a range of aggregate, conditional IN THIS SECTION: You'll learn why Excel is the swiss army knife of IN THIS LESSON: I'll teach you the difference between a flat file or “database format” You can find the whole course here: http:// IN THIS LESSON: Learn how to use Excel VBA to do something useful - either create a macro to automate tasks, or a new ... IN THIS LESSON: You'll learn how to build Excel

IN THIS SECTION: You'll learn to create powerful "encapsulated" excel CONCLUSION: Wrapping it all up ** ---------------------------------------------------------------------------------------------------------------- To take ... IN THIS LESSON: Creating the excel charts you want, and reproduce them using chart templates ... IN THIS LESSON: You'll learn about the consulting Problem Solving Process (commonly taught by McKinsey, Bain and BCG to ... AD: Sign up to enroll for a 7-day free trial with Coursera now!

Photo Gallery

BeyondFormulas Modeling - 5. DATA ANALYSIS - 1. Section Introduction
BeyondFormulas Modeling - 5. DATA ANALYSIS - 2. The best aggregation formula for analyzing data
BeyondFormulas Modeling - 4. DATA BASICS - 1. Section Introduction
BeyondFormulas Modeling - 4. DATA BASICS - 5. Primer on structuring data: Table or “Flat file”
BeyondFormulas - Excel Modeling Training for Analysts & Consultants
BeyondFormulas Modeling - 6. MODELING - 5. VBA, User defined functions and Macros
BeyondFormulas Modeling - 2. EFFICIENCY - 5. Building a model for stakeholders
BeyondFormulas Modeling - 6. MODELING - 1. Section Introduction
BeyondFormulas Modeling - 1. INTRO - 2. What this course covers: Modeling Approach & Excel Tools
BeyondFormulas Modeling - 10. CONCLUSION
BeyondFormulas Modeling - 8. OUTPUT - 3. Creating the excel charts you want
BeyondFormulas Modeling - 3. PROBLEM SOLVING - 2. Problem Solving 101
View Detailed Profile
BeyondFormulas Modeling - 5. DATA ANALYSIS - 1. Section Introduction

BeyondFormulas Modeling - 5. DATA ANALYSIS - 1. Section Introduction

IN THIS SECTION: Become an Excel

BeyondFormulas Modeling - 5. DATA ANALYSIS - 2. The best aggregation formula for analyzing data

BeyondFormulas Modeling - 5. DATA ANALYSIS - 2. The best aggregation formula for analyzing data

IN THIS LESSON: You'll use a range of aggregate, conditional

BeyondFormulas Modeling - 4. DATA BASICS - 1. Section Introduction

BeyondFormulas Modeling - 4. DATA BASICS - 1. Section Introduction

IN THIS SECTION: You'll learn why Excel is the swiss army knife of

BeyondFormulas Modeling - 4. DATA BASICS - 5. Primer on structuring data: Table or “Flat file”

BeyondFormulas Modeling - 4. DATA BASICS - 5. Primer on structuring data: Table or “Flat file”

IN THIS LESSON: I'll teach you the difference between a flat file or “database format”

BeyondFormulas - Excel Modeling Training for Analysts & Consultants

BeyondFormulas - Excel Modeling Training for Analysts & Consultants

You can find the whole course here: http://

BeyondFormulas Modeling - 6. MODELING - 5. VBA, User defined functions and Macros

BeyondFormulas Modeling - 6. MODELING - 5. VBA, User defined functions and Macros

IN THIS LESSON: Learn how to use Excel VBA to do something useful - either create a macro to automate tasks, or a new ...

BeyondFormulas Modeling - 2. EFFICIENCY - 5. Building a model for stakeholders

BeyondFormulas Modeling - 2. EFFICIENCY - 5. Building a model for stakeholders

IN THIS LESSON: You'll learn how to build Excel

BeyondFormulas Modeling - 6. MODELING - 1. Section Introduction

BeyondFormulas Modeling - 6. MODELING - 1. Section Introduction

IN THIS SECTION: You'll learn to create powerful "encapsulated" excel

BeyondFormulas Modeling - 1. INTRO - 2. What this course covers: Modeling Approach & Excel Tools

BeyondFormulas Modeling - 1. INTRO - 2. What this course covers: Modeling Approach & Excel Tools

To take this full professional excel

BeyondFormulas Modeling - 10. CONCLUSION

BeyondFormulas Modeling - 10. CONCLUSION

CONCLUSION: Wrapping it all up ** ---------------------------------------------------------------------------------------------------------------- To...

BeyondFormulas Modeling - 8. OUTPUT - 3. Creating the excel charts you want

BeyondFormulas Modeling - 8. OUTPUT - 3. Creating the excel charts you want

IN THIS LESSON: Creating the excel charts you want, and reproduce them using chart templates ...

BeyondFormulas Modeling - 3. PROBLEM SOLVING - 2. Problem Solving 101

BeyondFormulas Modeling - 3. PROBLEM SOLVING - 2. Problem Solving 101

IN THIS LESSON: You'll learn about the consulting Problem Solving Process (commonly taught by McKinsey, Bain and BCG to ...

Master Data Analysis on Excel in Just 10 Minutes

Master Data Analysis on Excel in Just 10 Minutes

AD: Sign up to enroll for a 7-day free trial with Coursera now!