MicroNugget: How to Work with Formulas

In this video, Simona Millham covers how to use formulas in Microsoft Excel. She shows you how to enter both simple and complex formulas into spreadsheets. She also shows you how to resolve common errors in your spreadsheets. She further provides some tips and tricks that you may not be aware of.

After watching this video, you will know how to input and copy a wide variety of formulas in Microsoft Excel. This includes basic mathematical operations, such as adding, subtracting and multiplying the contents of cells. Simona also shows you how to compute percentages in your formulas. She further goes into detail about cell referencing and how you can use absolute cell references when copying formulas. She additionally explains the various errors that you may encounter in Excel and how to go about resolving them. Finally, she provides a variety of tips, such as transposing cells, displaying information in the status bar and highlighting formulas.

Start learning with CBT Nuggets:

[AlaaSaeed]

CBT Nuggets in British accent? The world is changing. ☺️