Learning the formulas in Excel was the most difficult task in Chapter 5. The first important rule in learning formulas is starting with the equal sign for each equation. Although it seems simple this a step that I often forget about. If this equal sign isn't added before an equation, Excel can't solve the problem. It is also important that there is a basic understanding of a table design. For example, understanding what a structured reference is. A structured reference is a cell reference that refers to the table column header, instead of the absolute cell location. These table references make formulas easier to understand on their own. Table rows are a great example of simple formulas. If a table has a total row you can then apply functions like AVERAGE, COUNT, SUM, etc. These rows are automatically added when a table is created. This information helped me simplify equations and I hope it does the same for you too!
Structured references in tables definitely make formulas and cell references easier to construct!
ReplyDeleteExcellent choice of topic with 5.9.4 Formulas in Tables, Leina :-)
Thank so much for this blog post. It is helping me understand much better.
ReplyDeleteFor sure this one was a new thing I learned and I'm so grateful. I work spreadsheets for reports at work and knowing I can swiftly put together a table is super helpful.
ReplyDeleteI often forget to type out what kind of function I want to use. I know what function to use, but I typed the whole function out in my head instead of physically typing it out hahaha!
ReplyDeleteThere are so many formulas to pick from in excel. I get excited when I guess the right one on the different tests. It started off pretty fun, but I can see how it can get overwhelming.
ReplyDelete