OWL Insight

Excel® and SQL for Data Analytics

Current Status

Not Enrolled

Price

$249.00

Get Started

This course is currently closed

Course Content

Expand All

Intro to the Case Study 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Sub Optimal Hotel

Hotel Business Terms

RAW_DATA file 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Importing RAW Data

Excel Tables 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Format as Table Copy

Table Column Sort Copy

Filter Table Column

Multiple Criteria Table Filtering

Naming Excel Tables

Insert and Delete Table Rows and Columns

Excel Table Cell Reference

Excel Table Total Row

Data Transformation 17 Topics

Expand

Lesson Content

0% Complete 0/17 Steps

Add OTA_COMM Table

VLOOKUP function Copy

IFERROR function Copy

IFERROR for GROSS RATE Copy

ROUND formulas Copy

CEILING and FLOOR formulas Copy

More ROUND and CEILING Copy

Date and Time in Excel Copy

MONTH formula Copy

WEEKDAY formula Copy

Intro to IF function Copy

JOIN and CONCATENATE Copy

More Date Functions Copy

LEFT and RIGHT functions Copy

MID function Copy

SUBSTITUTE and REPLACE functions Copy

UPPER, LOWER, and PROPER text Copy

Pivot Table and Pivot Chart 19 Topics

Expand

Lesson Content

0% Complete 0/19 Steps

Introduction to Pivot Tables Copy

A Simple Pivot Table Copy

Adding More Pivot Dimensions Copy

GROUP Pivot Labels Copy

Pivot Table Report Filter Copy

Value Field Settings Copy

More Value Field Settings Copy

Calculated Fields Copy

Pivot Table Formatting Copy

Simple Pivot Chart Copy

Multi-Dimension Pivot Chart Copy

Changing Pivot Chart Type Copy

Formatting any Excel Chart Copy

More Excel Chart Formatting Copy

Slicers with Pivot Charts Copy

Pivot Table Drill Down Copy

Referencing a Pivot Table Copy

Statistical Functions 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

AVERAGE function Copy

SUM function Copy

COUNT function Copy

Standard Deviation function Copy

Minimum and Maximum function Copy

QUARTILE function Copy

Nested and Criteria Functions 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

AVERAGEIF function Copy

SUMIF function Copy

COUNTIF function Copy

AVERAGEIFS function Copy

SUMIFS function Copy

Nested Functions Copy

Array Functions 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

MINIF Array function Copy

MAXIF Array function Copy

STDEV IF Array function Copy

QUARTILE IF Array function Copy

MINIFS and MAXIFS Array functions Copy

STDEVIFS Array function Copy

QUARTILEIFS Array function Copy

Non-exact criteria filters Copy

Databases 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

UI and Database Copy

Relational Database Copy

Important Definitions Copy

MS Query 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

MS Query Wizard Copy

MS Query Table View Copy

MS Query of Excel files Copy

SQL Basics 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

What is SQL? Copy

Types of SQL Copy

SQL Formulas 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Explore Our Courses

Build the full analytics skill stack.

Analytics Tools Master Course

Acquire the skills to become a confident, data-driven professional.

Data Science of Revenue Optimization

Master the pricing strategies that drive revenue in competitive markets.

How to Talk About Data

Uncover the insights hiding in any business using proven analytics frameworks.