Excel Tips and Techniques: Improve Productivity and Financial Modeling Webinar

• Identify three problems caused by merging cells.
• Determine if a cell has Text or Values, and why it's important.
• Identify three advantages of named ranges using the Name Box.
• Recognize the 10 steps to follow when creating a model.
• Identify a potential fraud situation using the Histogram tool.
• Create a macro using the macro recorder.

Improve productivity and financial modeling skills with an assortment of tips, techniques, features, commands and functions. Examine practical applications of Excel key features and functionality.

A generic 3-Year business model is used to demonstrate key features covered in the course which includes a basic introduction to macros using the macro recorder. Among other items, learn the importance of the QAT (Quick Access Toolbar) and how to add/remove "buttons" from it; create dynamically linked pictures using the Camera feature; construct "Smart Text" using Concatenation; create named ranges using the Name Box; and find and eliminate links.

Note: Course format is lecture style. Laptops are not required, but are encouraged. A CD with selected demo Excel files is provided.

Formerly titled: Excel Tips and Techniques for Increased Productivity and Improved Financial Modeling: Intermediate