Course Intro

Jumpstart Overview

Jumpstart Part 1

Jumpstart Part 2 Filtering Unique Values

Jumpstart Part 2

Jumpstart Part 3

Getting Acclimated Section Overview

EXCEL User Interface

Adding Deleting and Editing Data in a Cell

Introduction to Keyboard Shortcuts

Navigation Keyboard Shortcuts

Data Selection Keyboard Shortcuts

Inserting and Deleting Rows and Columns

Auto Fit Row and Column Size

Freeze Panes and Split Boxes

Formatting Numbers

Formatting Cells

Grouping and Hiding Rows or Columns

Installing EXCEL AddIns

Basic Excel Formulas & Functions Section Overview

Basic Math Functions in Excel

Conditional Math Functions

MIN MAX and AVERAGE Functions

Logical Operators and Functions

Anchoring Cell References and Name Ranges

Array Functions

Internal Rate of Return IRR Functions

Net Present Value NPV and Cash Multiple

Loan Amortization Table

Compound Annual Growth Rate CAGR

Fill Commands

IS Functions

Rounding Numbers

Text Times and Date Data Formats Section Overview

How EXCEL Treats Text Times and Dates Data

Combining Strings of Text Together

Changing the Case of Text

Cutting Substrings from a Text

Using the FIND Function

Searching for Specific Text in Data

Splitting a Text Field into Multiple Columns

Converting Dates from Text into Values

Adding and Subtracting Dates

Compiling Monthly and Annual Totals

Conducting Day of the Week Analysis

Combining Date and Time Data

Adding and Subtracting Times

Conducting Hours of the Day Analysis

Introduction Statistics in EXCEL Section Overview

Brief Overview of Statistics

Mean Median & Mode

Frequency Distributions

Percentile and PercentileRank

Standard Deviation and Variance

Trends in Data

Introduction to Correlation

Handling Data Overview

Lookup with VLOOKUP

Lookup with HLOOKUP

Name Arrays for Reuse and Readability

Group Records with Nested IF Statements

Avoid Errors with IF and ISNUMBER

Create Dropdown Lists for Filtering

Create Unique Lists

MultiCondition Lookup with DSUM

Fast Lookup with INDEX and MATCH

Create Rankings with SMALL and LARGE

MultiCondition Lookup with INDEX and MATCH

Insert a Pivot Table

Prepare Data for Pivoting

Learn to Pivot a Table

Group Rows and Columns

Format for Readability

Modify Output Values for Insights

Sort Filter and Slicer

Insert Calculated Fields

Handle New Data in Pivot Tables

Intoduction to Charts in Excel Overview

Why Use Charts Anyway

Line Chart

Pie Charts

Bar Chart

Column Chart Clustered

Column Chart Stacked

Column Chart 100 Stacked

Scatter Plot

Combination Chart

Area Chart

Gantt Chart

Bubble Chart

Bullet Chart

Waterfall Chart

Cryptocurrency Case Study Overview

Getting and Prepping the Data

Bitcoin vs S&P500

Ethereum Litecoin & Bitcoin

Introduction to Moving Averages

Survey Data Overview

Preparing the Data

Demographics Who Are the Survey Respondents

Pivoting the Data Part 1

Pivoting the Data Part 2

So You Want to Do a Startup

A Note On Data Preparation

Scan the Data

Exercise 1

Dig into the Categories

Pivot and Chart Part 1

Pivot and Chart Part 2

Analysis Leads to Finding

Startup Funding CSV File Import

Import and Fix Startup Info Data Part 2

Import and Fix Startup Info Data Part 1

Import and Fix Startup Info Data Part 3

Join the Two Tables

Make Unique Lists

How to extractcopy unique values from a column of data

How to filter list for unique data points only

How to model timing contingencies

OPTIONAL How to use Udemy download files etc

NOTICE Temporary Udemy Technical Issue