Using simple text function to create a digital staff identity card. You will be more advanced in using the text functions.
Learned Excel Functions: CONCAT(), CONCATENATE(), IF(), LEFT(), LEN(), MID(), PROPER(), RIGHT(), UPPER()
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtime hours.
Learned Excel Functions: FALSE(), IF(), INT(), SUM(), TIME(), WEEKDAY(), WEEKNUM()
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional statisctics.
Learned Excel Functions: AVERAGE(), COUNTBLANK(), COUNTIF(), FALSE(), IF(), RANK(), ROUNDUP(), SUM(), SUMIF(), SUMIFS(), TRUE(), VLOOKUP()
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Learned Excel Functions: CONCAT(), CONCATENATE(), DAY(), LEN(), MONTH(), REPT(), TEXT(), TRIM(), UPPER(), YEAR()
Learned Excel Functions: VLOOKUP()
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() functions in this exercise.
Learned Excel Functions: FALSE(), HLOOKUP(), TRUE(), VLOOKUP()
Revisit your sales data, calculate regional totals, conditional totals
Learned Excel Functions: COUNTIF(), SUM(), SUMIF(), SUMIFS(), SUMPRODUCT()
Using Nested IF.
Learned Excel Functions: FALSE(), IF(), INDEX(), MATCH(), MAX(), RANK(), SUM(), TRUE()
Orientation program for 2017 starters
Rating Count : 3
Create a new account
I already have an account
By signing in/up, you agree to the Terms of Use and Privacy Policy.
You need upgrade!
You need a bigger screen to run the Sheetzoom app in Excel Online. Please switch to your PC or Tablet