Excel 2007 Functions & Formulas

Microsoft^Ž Excel 2007 Functions & Formulas

Target Student: Take this course if you want to learn useful tools, tricks and tips for utilizing functions and formulas available in Microsoft Excel 2007. Learn which functions are best suited from over 300 available built-in functions.

Course Content:

Entering and Using Formulas; Operators and the Order of Operations; Absolute and Relative Cell References; The Paste Function Dialog Box and Categories; The Function Palette; Introduction to Names; How to Create Cell and Range Names; Using Names in Formulas; Potential Problems with Names; Math Functions in Formulas; The AutoCalculate Tool; Counting and Summing Functions; Survey of Advanced Math Functions; Survey of Text Functions in Excel; Extracting Text from a Text string; Joining Text together; Case Functions; Converting Text; Survey of Date and Time Functions in Excel; Assembling a Date from Separate Cells; Parsing a Date; Time Functions; The Basics of Lookup Functions; Using the Lookup Function; Using the Vlookup Function; Using the Hlookup Function; The IF Function; The Five Basic Financial Functions; Depreciation Functions; The Goal Seek Function; How Excel Works with Databases and Lists; How to Create a List; Sorting and Filtering a List; Using Database Functions

BACK