Excel 2007 Advanced Tools for Analysis Training Class

Course Content: How Excel is Used: From Simple Spreadsheets to Applications; Excel Versions and Compatibility; The Functions and Formula Tools; Entering and Using Formulas; Operators and the Order of Operations; The AutoCalculate Tool; Absolute and Relative Cell References; Other Formula Tools; Showing Formulas on the Worksheet; Using the Formula Auditing Toolbar; Tracing Cell Relationships; Tracing and Correcting Errors; How Excel Works with Databases and Lists; How to Create a List; Sorting a List; Filtering a List; Using the Subtotal Function; Conditional Formatting; Using Goal Seek; Using Solver; Building Scenarios; 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; Survey of Financial Functions; Depreciation Functions;  Recording Simple Macros; Macros and VBA Code; Accessibility and Security