Tutorial Excel Formula & Functions Quick Reference in PDF

  • Formula & Functions Basics
  • Checking for formula
  • Building a formula to add
  • Autosum to add row or column totals
  • Building a formula to subtract
  • Building a formula to multiply or divide
  • Useful keyboard Shortcuts
  • Use insert function (formula builder) to make formulae easier
  • Autofill to copy formula to other cells
  • Relative cell references
  • Absolute references for common variables
  • Mixed cell references
  • Flash Fill (Excel 2013 & 2016 only)
  • To split the contents of a column into 2 columns
  • Colour all cells containing a formula (Excel 2013 only)
  • Recommended PivotTables (Excel 2013 and 2016)
Description : Download Excel Formula & Functions Quick Reference tutorial, free PDF by University of Brighton.
Level : Beginners
Created : 2017-09-21 09:34:49
Size : 293.72 KB
File type : pdf
Pages : 8
Author : Faye Brockwell
Downloads : 1124

Summary on tutorial Excel Formula & Functions Quick Reference

It is never too late to start learning and it would be a shame to miss an opportunity to learn a tutorial or course that can be so useful as Excel Formula & Functions Quick Reference especially when it is free! You do not have to register for expensive classes and travel from one part of town to another to take classes. All you need to do is download the course and open the PDF file. This specific program is classified in the Excel category where you can find some other similar courses.

The file includes tutorial that is adjusted for beginner's and advanced users who make it easy to learn.

Fortunately, more and more people are willing to share their experience and knowledge with others and they do not want compensation for this. The course Excel Formula & Functions Quick Reference is completely free and the author does not want compensation. As mentioned previously, you can do some research and find other attractive PDF courses as well.

Login or Create an account to leave a comment