Introduction and Getting Started
  • Downloading Excel
  • Why Should You Use Excel?
  • Getting Familiar with the Excel Interface
  • The Excel Ribbon
  • How to Use the Course Resources
Entering and Editing Data and Formulas
  • Basics of Data Entry and Formatting
  • Working with Date Values in Excel
  • Introduction to Cell References in Excel
  • Arithmetic and Mathematical Operators in Excel
  • Using the Fill Handle to Autofill Data in Excel
  • Relative, Absolute, and Mixed Cell References in Excel
  • Named Cells and Ranges in Excel
  • Exercise - Personal Budget
Formatting Your Excel Worksheet
  • Using ALT as a Shortcut, and Other Shortcuts
  • Font Formatting, Text Alignment, and Merging Cells
  • Inserting and Deleting Cells, Rows, and Columns
  • Hiding and Unhiding Rows and Columns
  • Borders & Fill Colors
  • Conditional Formatting
  • Hyperlinks in Excel
  • Protecting Excel Worksheets and Workbooks
  • Data Validation and How to Create a Dropdown List
  • Exercise - Conditional Formatting
  • Exercise - Creating a Table of Contents
Excel Functions
  • What is a Function in Excel?
  • Order of Operations (Order of Precedence) in Excel
  • SUM and the AUTOSUM Feature in Excel
  • COUNT, COUNTA, and COUNTBLANK
  • AVERAGE
  • MIN and MAX
  • ISBLANK, ISNUMBER, ISTEXT, and ISERROR
  • Booleans and Logical Operators in Excel
  • Exercise - Logical Operators
  • IF
  • VLOOKUP
  • CONCATENATE, TRIM, and TEXTSPLIT
  • Using SEARCH and ISNUMBER to Find If a Cell Contains Specific Text
  • Exercise - Student Grades
  • INDEX, MATCH, AND INDEX MATCH
Navigating and Exploring Larger Datasets
  • How to Freeze Panes, Rows, and Columns in Excel
  • How to Sort Lists in Excel
  • How to Use Excel Filters
  • Shortcuts for Filtering and Sorting
  • Unsort and Revert Back to Original Order
  • Exercise - Bestselling Artists
Cleaning and Processing Your Data in Excel
  • What is Data Cleaning and the Data Cleaning Process
  • Remove Blank Rows
  • Remove Rows with Blank Cells
  • How to Fill or Replace Blank Cells in Excel
  • Remove Duplicates
  • Using Find and Find and Replace
  • SUBSTITUTE Function
  • Data Cleaning Pro Tip: Creating a Key
  • Importing CSV, TSV, and TXT and Text to Columns
  • Exercise - States
  • Sources of Data for Your Personal Projects
Excel Pivot Tables for Summary and Analysis
  • What is a Pivot Table?
  • Fundamentals: Creating a Pivot Table, The Field List, and Aggregators
  • Bonus: Count Unique (Distinct Count) with Pivot Tables
  • Adding Data to Pivot Tables
  • Data Best Practices: Source Data Formatting and Organization
  • Formatting Pivot Table Dates and Numbers
  • Sorting and Filtering with Pivot Tables
  • Exercise - Animal Bites
  • Calculate Values in a Pivot Table
  • Custom Calculations with Pivot Tables
  • Slicers and Timelines
  • Exercise - IMDB Movie Database
  • Pivot Table Tabular Form to Export Data
Data Visualization
  • Tips for Effective Data Visualization
  • Parts of an Excel Chart
  • Types of Data
  • Types of Data
  • How to Insert a Chart and Add Chart Elements
  • How to Insert Bar and Column Charts Excel
  • Format Chart Area Tutorial
  • Sparklines
  • Combo Charts (Two-Axis Charts)
  • Line Charts and Trendlines
  • Pie Charts
  • Scatter Plots
  • Bubble Charts
  • Histograms and Pareto Charts
  • Box and Whisker Plots
  • Heat Maps
Data Analyst Fundamentals
  • The Scientific Method and How It Applies to Data Analysis
  • Types of Data Analysis
  • Data Analysts vs. Data Scientists
  • Independent vs. Dependent Variables
  • Independent vs. Dependent Variables
MBA Unit 1: Performing a Digital Marketing Keyword Analysis