Learn basic excel formulas

Get a clear, practical understanding of basic excel formulas

What you'll cover

1. 1
   Excel Interface Basics

   Navigate the Excel window and identify key components like cells, rows, columns, and the formula bar.
2. 2
   Entering and Editing Data

   Learn how to input text and numbers into cells and correct mistakes.
3. 3
   Understanding Cell References

   Grasp how cells are identified (e.g., A1, B2) and why this is crucial for formulas.
4. 4
   Simple Arithmetic Formulas

   Create basic formulas using addition (+), subtraction (-), multiplication (*), and division (/).
5. 5
   Using the SUM Function

   Efficiently add up a range of numbers using the SUM formula.
6. 6
   Introduction to AVERAGE and COUNT

   Calculate the average and count the number of items in a data set.
7. 7
   Practical Formula Application

   Apply learned formulas to a simple real-world scenario, like tracking expenses.