You now have theoretical knowledge about formula construction and should feel confident to perform basic calculations adhering to a basic order of operation. You are also able to construct and edit formulas and have mastered working out percentage change, increase, or decrease; use the Function Library to access more complex formulas from the formula composer; and finally, use relative and absolute cell references in formulas. During this chapter, you worked with dates in formulas; used mathematical, financial, and text functions; and finally, learned how to apply conditional logic in formulas. You should now be confident at locating and fixing formula errors and be able to apply named ranges for workbook navigation or within a formula.
Excel 2019 includes several features for sharing and collaborating on workbooks and worksheets. In the next chapter, we'll learn...