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.
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: 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.
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.
Practice: Date Functions
Making more practice by using date functions.
Practice: Date Functions
Making more practice by using date functions.
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.
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: 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.
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: 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.
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.
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: 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: 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: VLOOKUP-V
Making more practice by using lookup functions.
Practice: VLOOKUP-V
Making more practice by using lookup 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.
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.
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.
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.
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: 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.
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: Working with operators
Using basic functions with more practices.
Practice: Date Functions
Making more practice by using date functions.
Practice: Understanding Absolute References-II
Using basic functions with more practices.
Practice: Time Function
Making more practice by using time functions.
Practice: Basic Date Functions
Making more practice by using TODAY() and NOW() functions
Practice: Basic functions-IV
Using basic functions with more practices.
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.
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.
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: Adding values that meet a single criteria - Part I
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
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...
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: 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: 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...
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
Formatting Numbers
Formating cell range which are formatted different type.
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: SUMIFS, COUNTIFS, AVERAGEIFS - V
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() 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.
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.
