Making a simple budget by using basic functions.
Round your sales data do decimals, nearest thousand and many more
Lookup employee information from the employee list based on different parameters
Create a body mass index calculator using height and weight of a person
Calculate the earnings of top models based on scenarios
Try using vertical lookup instead of if statements
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Revisit your sales data, calculate regional totals, conditional totals
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Calculate work days considering holidays, weekends and number of days worked
Create a handy trigonometry cheat sheet for commonly used angles.
Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...
Create some statistics to better understand the social media adoption
Making more practice by using text functions for date operations.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Create a summary of salesperson sales stats with the help of range lookup.
Making more practice by using workday function.
Making more practice by using lookup functions.
Making more filtering practices.
Basic revenue calculation by implementing stays, discounts and tax.
Making more practice by using IF() function.
Practice your skills about pivot tables.
Changing cell properties as date formats.
Using basic functions with more practices.
Using pie chart for your data.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Create a "Travel Budget" sample.
Making more practice by using date functions.
Resolving VLOOKUP errors.
Checking formulas results with Iphone-Samsung sales.
Practice your text functions skills.
Formating cell range which are formatted different type.
Making more practice by using time functions.
Making more practice by using TODAY() and NOW() functions
Getting values with VLOOKUP:
Combine text strings using TEXTJOIN() and CONCAT().
Getting special information from the table.
Drill down your sales data using an alternative lookup method.
Calculate which country recieves the most tourists in each continent.
Using line chart for your data.
Working on banking operations.
Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.
Using four operations and statistical functions over a scenario about play tickets status of a theater.
Understanding formulas with "Sales" operations.
Creating an invoice with base functions.
Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Removing duplicate information from the table.
Using MAXIFS() and MINIFS() at a basic level.
Making more practice by using IF() and AND() functions.
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...
Using some specific functions.
Sorting data by given criteria.
Working with advanced functions.
Using and testing some values.
Using Nested IF.
Creating a column chart and edit it.
Working on Social Security.
Using populer finance functions.
Correcting value errors.
Sort data by given criteria.
Calculate vacation days based on years worked and other conditions
Making more practice by using IF() and OR() functions.
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Using filters and subtotal functions.
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Master date functions using the complaints data for a gym.
Using formulas for "Electronic Sales" operations.
Summarizing data with pivot table.
Getting some information with VLOOKUP on "Employee Data"
Making more practice by using networkday function.
Matching nested IF() and IFS() functions.
Create a new account
I already have an account
You need upgrade!
You need a bigger screen to run the Sheetzoom app in Excel Online. Please switch to your PC or Tablet
Made with in Istanbul
Get notified first! Sign-up free for our newsletter.