Excel formulas and functions - intensive

course description

topic

• review of basic functions using paste function sum, max, min, average, count functions
• displaying formulas and exploring the calculation tab in tool options
• using information functions to evaluate the contents of cells including error values
• using date functions to display date/time information and to perform date/time calculations
• using text functions to extract part of the contents of a cell or to convert data
• using functions from the financial functions category to perform a range of tasks linked to loans, payments and interest rates
• an introduction to the statistical functions available in excel
• installing the analysis toolpak
• using functions from the analysis toolpak