Applied Excel: Working with Data Sets and Scenario Analysis

Applied Excel: Working with Data Sets and Scenario Analysis

Regular price $150.00
Shipping calculated at checkout.

OVERVIEW VIDEO

 

Save $$ with our Excel Bundle

Includes both Applied Excel and Excel Best Practices

TTS Excel Bundle

WHAT YOU WILL LEARN: 

  • Excel Best Practices and Efficiencies
    • Speed up your skills in Excel
  • Working with Client Data
  • Analyzing Data in Excel
  • Scenario Analysis
  • Macros and User-Friendly Tools
  • Pivot Tables
  • Data Tables
  • Enhancing Model Integrity
  • Introduction to VBA & Macros
  • Array Formulas

Over 6 hours of video-based self-study videos.

The Applied Excel course will benefit a wide variety job roles including:

  • Consulting
  • Financial planning and analysis, operations, or the business/strategic development group of any corporation
  • Accounting
  • Financial services (investment banking, research, asset management, brokerage, sales & trading, insurance, private equity, venture capital)
  • Marketing and brand management
  • Entrepreneurs and start-ups

Through practical examples and annotated Excel guides, the course will improve the participant’s ability to use Excel efficiently to parse a large data set and interpret the results. By utilizing both basic and advanced Excel tools, students can dramatically improve their efficiency in data organization, allowing them to spend more time interpreting and sensitizing the data.

KEY FEATURES

  • Estimated time to complete is 10-15 hours
  • Over 6 hours of video based instruction
  • Course materials include videos and hands-on Excel exercises.
  • Optimized for PC based Excel
  • The Excel shortcuts in this course are not optimized for Mac versions of Excel, but this will not detract substantially from the course experience

TOPICS COVERED

  • Organization of data: (text to columns, RIGHT, LEFT, UPPER, LOWER, CONCATENATE, etc.)
  • Lookup functions (VLookup, HLookup, MATCH)
  • Pivot Tables
  • Scenario analysis (CHOOSE, OFFSET)
  • Introduction to macros and other format controls
  • Creations of basic print macros
  • Editing of basic VBA code
  • Drop-down menus (combo boxes)
  • Data validation and creation of dynamic text
  • Sensitivity analysis using data tables

PREREQUISITES

  • There are no prerequisites. However, students with a basic knowledge of Excel will benefit more from the course.
  • We recommend taking the Excel Best Practices course to become fast and efficient in Excel.

Buying More Than One Course?

Browse Our Course Bundles Below:

Sold out
Sold out
Sold out

Sale

Unavailable

Sold Out