Special Use of Lookups
Try using vertical lookup instead of if statements
Special Use of Lookups
Try using vertical lookup instead of if statements
Top Models
Calculate the earnings of top models based on scenarios
Top Models
Calculate the earnings of top models based on scenarios
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
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.
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
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
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
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.
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
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: Workday Function
Making more practice by using workday function.
Practice: Workday Function
Making more practice by using workday function.
Hotel California
Basic revenue calculation by implementing stays, discounts and tax.
Hotel California
Basic revenue calculation by implementing stays, discounts and tax.
Practice: Pivot Tables-III
Practice your skills about pivot tables.
Practice: Pivot Tables-III
Practice your skills about pivot tables.
Practice: Pivot Tables-II
Practice your skills about pivot tables.
Practice: Pivot Tables-II
Practice your skills about pivot tables.
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.
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.
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: 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.
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...
Practice: Pivot Tables-V
Practice your skills about pivot tables.
Practice: Pivot Tables-V
Practice your skills about pivot tables.
Practice: Date Functions
Making more practice by using date functions.
Practice: Date Functions
Making more practice by using date functions.
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
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: 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.
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.
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: Time Function
Making more practice by using time functions.
Practice: Time Function
Making more practice by using time 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: Date Functions
Making more practice by using date functions.
Practice: Date Functions
Making more practice by using date functions.
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.
Special Use of Lookups
Try using vertical lookup instead of if statements
Top Models
Calculate the earnings of top models based on scenarios
Oil Production
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
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
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: 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: Pivot Tables-IV
Practice your skills about pivot tables.
Practice: Adding values that meet a single criteria - Part IV
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
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: Date Functions
Making more practice by using date functions.
Most Popular Movies
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Practice: Networkday Function
Making more practice by using networkday function.
Practice: Time Function
Making more practice by using time functions.
Practice: Date Functions
Making more practice by using date functions.
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
Trigonometry Cheat Sheet
Create a handy trigonometry cheat sheet for commonly used angles.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV
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.
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.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II
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.
Highest Paid Celebrities
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
New Text Functions
Combine text strings using TEXTJOIN() and CONCAT().
Customer & Order Table
Getting special information from the table.
