Microsoft® Excel 2007 Advanced Tools for Analysis
Target Student: Take this course if you want to use the advanced tools built-in Excel specifically for analysis, to create spreadsheets that automate analysis processes, and to know what tools and functions are best for each worksheet need. 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
This website and its contents are copyright © 2008, Knowledge Source Inc. | ||