Portfolios

Exercise for beginners #1: Use the cells in your calculation

How to enter numbers in a cell? How to do calculations with numbers? How to do calculations with cell references? How to use Excel's built-in functions?

Exercise: Use dollars in your formula

Exercises to create test (comparing values)

Find the products under the stock limit

Create an Invoice Template

Steps to create a dropdown list

Create a dropdown list is Excel is very useful. This series of steps will show you 2 techniques to create a dropdown list in your cells.

Function