Order of Operations

Order of Operations


Function Dialog Box

Function Dialog Box

IF Function
IF Function

PMT and IF Formula
PMT and IF Formula


Formulas and Functions in Microsoft Excel

Covers these topics and more :

  • The way Excel “does math” known as order of operations
  • Learn what answer Excel gives for this formula: 2+5*3 and why
  • Method for making formulas refer to the cell you want when you copy it
  • Difference between Absolute and Relative References
  • Easy ways to build formulas
  • How to create formula for the Percentage of a total
  • Create long formulas
  • Understand relative and absolute references in formulas
  • Copy and move formulas
  • The Sum (∑ ) function
  • The mighty "IF" function
  • How to master using functions
  • Useful help topics
 
© 2009 Mel Babb

Houston, Texas Metro Area 713.981.5641 mel@melpchelp.com
We help you make the computer work for you!