In this class you will learn:
how to create Excel formulas using different operators
how to create Excel functions that have practical applications for Financial type spreadsheets
At the end of the class you will be able to:
Create basic arithmetic formulas that also include percentages, ratios and absolute references
Create function formulas including the statistical functions
Create basic arithmetic formulas that also include percentages, ratios and absolute references
Create function formulas including the statistical functions (SUM, AVERAGE, COUNT, etc.
Create logical functions for making decisions including nested IF statements
Understand and apply conditional formatting
Print spreadsheets to hard copy