Free Excel Training and Courses

### First Course

Making a simple budget by using basic functions.

### First Course

Making a simple budget by using basic functions.

### Round up Your Sales

Round your sales data do decimals, nearest thousand and many more

### Round up Your Sales

Round your sales data do decimals, nearest thousand and many more

### Employee List

Lookup employee information from the employee list based on different parameters

### Employee List

Lookup employee information from the employee list based on different parameters

### Body Mass Index Calculation

Create a body mass index calculator using height and weight of a person

### Body Mass Index Calculation

Create a body mass index calculator using height and weight of a person

### Top Models

Calculate the earnings of top models based on scenarios

### Top Models

Calculate the earnings of top models based on scenarios

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

### Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Richest Business People

Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...

### Richest Business People

Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...

### Project Work Days

Calculate work days considering holidays, weekends and number of days worked

### Project Work Days

Calculate work days considering holidays, weekends and number of days worked

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

### Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...

### Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Practice: Text Functions

Making more practice by using text functions for date operations.

### Practice: Text Functions

Making more practice by using text functions for date operations.

### Practice: Adding values that meet a single criteria - Part V

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part V

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Practice: Workday Function

Making more practice by using workday function.

### Practice: Workday Function

Making more practice by using workday function.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: Filters 2

Making more filtering practices.

### Practice: Filters 2

Making more filtering practices.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: Pivot Tables-III

Practice your skills about pivot tables.

### Practice: Pivot Tables-III

Practice your skills about pivot tables.

### Practice: Date Formatting

Changing cell properties as date formats.

### Practice: Date Formatting

Changing cell properties as date formats.

### Practice: Pivot Tables-II

Practice your skills about pivot tables.

### Practice: Pivot Tables-II

Practice your skills about pivot tables.

### Practice: Working with operators

Using basic functions with more practices.

### Practice: Working with operators

Using basic functions with more practices.

### Pie Chart

Using pie chart for your data.

### Pie Chart

Using pie chart for your data.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### Practice: IF Functions 4 - Bets

Making more practice by using IF() function.

### Practice: IF Functions 4 - Bets

Making more practice by using IF() function.

### Travel Budget

Create a "Travel Budget" sample.

### Travel Budget

Create a "Travel Budget" sample.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Date Functions

Making more practice by using date functions.

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Practice: Understanding Absolute References-II

Using basic functions with more practices.

### Practice: Understanding Absolute References-II

Using basic functions with more practices.

### Practice: NameList

Practice your text functions skills.

### Practice: NameList

Practice your text functions skills.

### Formatting Numbers

Formating cell range which are formatted different type.

### Formatting Numbers

Formating cell range which are formatted different type.

### Practice: Time Function

Making more practice by using time functions.

### Practice: Time Function

Making more practice by using time functions.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() functions

### Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() functions

### Practice: Arrangement

Practice your text functions skills.

### Practice: Arrangement

Practice your text functions skills.

### Practice: IF Functions 3 - Other Functions and If

Making more practice by using IF() function.

### Practice: IF Functions 3 - Other Functions and If

Making more practice by using IF() function.

### Practice: Basic functions-IV

Using basic functions with more practices.

### Practice: Basic functions-IV

Using basic functions with more practices.

### Stoner

Getting values with VLOOKUP:

### Stoner

Getting values with VLOOKUP:

### New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().

### New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().

### Customer & Order Table

Getting special information from the table.

### Customer & Order Table

Getting special information from the table.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Beverage Sales

Drill down your sales data using an alternative lookup method.

### Beverage Sales

Drill down your sales data using an alternative lookup method.

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### Practice: HLOOKUP

Making more practice by using lookup functions.

### Practice: HLOOKUP

Making more practice by using lookup functions.

### Practice: Product ID

Practice your text functions skills.

### Practice: Product ID

Practice your text functions skills.

### Line Chart

Using line chart for your data.

### Line Chart

Using line chart for your data.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### IBAN Numbers

Working on banking operations.

### IBAN Numbers

Working on banking operations.

### Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.

### Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.

### Profitability of a Theater

Using four operations and statistical functions over a scenario about play tickets status of a theater.

### Practice: Pivot Tables-IV

Practice your skills about pivot tables.

### Practice: Pivot Tables-IV

Practice your skills about pivot tables.

### Good Biscuit

Understanding formulas with "Sales" operations.

### Good Biscuit

Understanding formulas with "Sales" operations.

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### My First Invoice

Creating an invoice with base functions.

### My First Invoice

Creating an invoice with base functions.

### Automobile Leasing Calculator

Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...

### Automobile Leasing Calculator

Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

### Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Text

Practice your text functions skills.

### Practice: Text

Practice your text functions skills.

### Practice: Basic functions-II

Using basic functions with more practices.

### Practice: Basic functions-II

Using basic functions with more practices.

### New Employee ID Badge

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

### New Employee ID Badge

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

### Weekly Timesheet

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

### Weekly Timesheet

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

### Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.

### Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.

### Practice: Remove Duplicates

Removing duplicate information from the table.

### Practice: Remove Duplicates

Removing duplicate information from the table.

### Practice: Basic functions-III

Using basic functions with more practices.

### Practice: Basic functions-III

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.

### Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.

### Practice: IF Functions 7 - Customers

Making more practice by using IF() and AND() functions.

### Practice: IF Functions 7 - Customers

Making more practice by using IF() and AND() functions.

### Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...

### Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...

### Practice: Mail Address

Practice your text functions skills.

### Practice: Mail Address

Practice your text functions skills.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Other Functions

Using some specific functions.

### Other Functions

Using some specific functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Practice: Filters 1

Making more filtering practices.

### Practice: Filters 1

Making more filtering practices.

### Practice: Sort Data 1

Sorting data by given criteria.

### Practice: Sort Data 1

Sorting data by given criteria.

### Practice: Customer

Practice your text functions skills.

### Practice: Customer

Practice your text functions skills.

### Win a lottary ticket

Working with advanced functions.

### Win a lottary ticket

Working with advanced functions.

### Practice: Adding values that meet a single criteria - Part I

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part I

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Sales

Using and testing some values.

### Sales

Using and testing some values.

Using Nested IF.

Using Nested IF.

### Column Chart

Creating a column chart and edit it.

### Column Chart

Creating a column chart and edit it.

### Practice: Pivot Tables-V

Practice your skills about pivot tables.

### Practice: Pivot Tables-V

Practice your skills about pivot tables.

### Practice: Understanding Absolute References-I

Using basic functions with more practices.

### Practice: Understanding Absolute References-I

Using basic functions with more practices.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Date Functions

Making more practice by using date functions.

### Social Security Numbers

Working on Social Security.

### Social Security Numbers

Working on Social Security.

### Financial Convenience

Using populer finance functions.

### Financial Convenience

Using populer finance functions.

### Error Handling

Correcting value errors.

### Error Handling

Correcting value errors.

### Practice: Sort Data 2

Sort data by given criteria.

### Practice: Sort Data 2

Sort data by given criteria.

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Practice: Basic Counting functions

Using basic functions with more practices.

### Practice: Basic Counting functions

Using basic functions with more practices.

### Practice: IF Functions 8 - Sale Rent

Making more practice by using IF() and OR() functions.

### Practice: IF Functions 8 - Sale Rent

Making more practice by using IF() and OR() functions.

### Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...

### Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...

### Auto Filter and Subtotal Function

Using filters and subtotal functions.

### Auto Filter and Subtotal Function

Using filters and subtotal functions.

### World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.

### World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.

### Practice: Corrupted data

Practice your text functions skills.

### Practice: Corrupted data

Practice your text functions skills.

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Sunshine Events

Summarizing data with pivot table.

### Sunshine Events

Summarizing data with pivot table.

### Practice: Adding values that meet a single criteria - Part III

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part III

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Practice: Separation and merge

Practice your text functions skills.

### Practice: Separation and merge

Practice your text functions skills.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Practice: Adding values that meet a single criteria - Part II

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part II

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Networkday Function

Making more practice by using networkday function.

### Practice: Networkday Function

Making more practice by using networkday function.

### Privileged Customers

Matching nested IF() and IFS() functions.

### Privileged Customers

Matching nested IF() and IFS() functions.

### First Course

Making a simple budget by using basic functions.

### Round up Your Sales

Round your sales data do decimals, nearest thousand and many more

### Employee List

Lookup employee information from the employee list based on different parameters

### Top Models

Calculate the earnings of top models based on scenarios

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

### Richest Business People

Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...

### Project Work Days

Calculate work days considering holidays, weekends and number of days worked

### Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Practice: Text Functions

Making more practice by using text functions for date operations.

### Practice: Adding values that meet a single criteria - Part V

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Workday Function

Making more practice by using workday function.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Practice: Pivot Tables-III

Practice your skills about pivot tables.

### Practice: Date Formatting

Changing cell properties as date formats.

### Practice: Pivot Tables-II

Practice your skills about pivot tables.

### Practice: Working with operators

Using basic functions with more practices.

### Pie Chart

Using pie chart for your data.

### Travel Budget

Create a "Travel Budget" sample.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Understanding Absolute References-II

Using basic functions with more practices.

### Practice: NameList

Practice your text functions skills.

### Practice: Time Function

Making more practice by using time functions.

### Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() functions

### Practice: Arrangement

Practice your text functions skills.

### Practice: Basic functions-IV

Using basic functions with more practices.

### Practice: Product ID

Practice your text functions skills.

### Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.

### Practice: Pivot Tables-IV

Practice your skills about pivot tables.

### Automobile Leasing Calculator

Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...

### Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Text

Practice your text functions skills.

### Practice: Basic functions-II

Using basic functions with more practices.

### New Employee ID Badge

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

### Weekly Timesheet

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

### Practice: Basic functions-III

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

### Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...

### Practice: Mail Address

Practice your text functions skills.

### Practice: Customer

Practice your text functions skills.

### Practice: Adding values that meet a single criteria - Part I

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Column Chart

Creating a column chart and edit it.

### Practice: Pivot Tables-V

Practice your skills about pivot tables.

### Practice: Understanding Absolute References-I

Using basic functions with more practices.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Basic Counting functions

Using basic functions with more practices.

### Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...

### Practice: Corrupted data

Practice your text functions skills.

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### Practice: Adding values that meet a single criteria - Part III

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Separation and merge

Practice your text functions skills.

### Practice: Adding values that meet a single criteria - Part II

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Networkday Function

Making more practice by using networkday function.

### Body Mass Index Calculation

Create a body mass index calculator using height and weight of a person

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Formatting Numbers

Formating cell range which are formatted different type.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Stoner

Getting values with VLOOKUP:

### New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().

### Customer & Order Table

Getting special information from the table.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Beverage Sales

Drill down your sales data using an alternative lookup method.

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### Practice: HLOOKUP

Making more practice by using lookup functions.

### Line Chart

Using line chart for your data.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### IBAN Numbers

Working on banking operations.

### Good Biscuit

Understanding formulas with "Sales" operations.

### My First Invoice

Creating an invoice with base functions.

### Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Other Functions

Using some specific functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Win a lottary ticket

Working with advanced functions.

### Sales

Using and testing some values.

Using Nested IF.

### Social Security Numbers

Working on Social Security.

### Financial Convenience

Using populer finance functions.

### Error Handling

Correcting value errors.

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Auto Filter and Subtotal Function

Using filters and subtotal functions.

### World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Sunshine Events

Summarizing data with pivot table.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Privileged Customers

Matching nested IF() and IFS() functions.