Experts Exchange - Microsoft Excel: Charting, What If Analysis, Curve Fitting and Solver

Experts Exchange Excel pro Brad Yundt shares insight on charting, "What if" analysis, curve fitting and using the solver. In this webinar, you'll learn how to:

- Fit equations to the data
- Handle missing data
- Expand a chart automatically as data becomes available
- Use Goal Seek to set the desired profit and perform regression analysis
- Match invoices to uncoded payment checks using Solver
- Track work orders and show accumulated time on each
- Use a single value data table to show the margin using alternative selling prices
- Use double value data tables to change two inputs simultaneously

About the Presenter: Brad Yundt is a mechanical engineer at Applied Research Associates, Inc. who has been working with Excel since 1988 and Visual Basic for Applications (VBA) since 1995. In 2003, Yundt began participating on Experts Exchange where he has since answered over 9,000 questions and currently serves as a Zone Advisor for Microsoft Office and Excel. For the past four years, Yundt has been the recipient of the prestigious Microsoft Most Valuable Professional award for Excel.

** Download the HQ version here: http://www.mediafire.com/?fvks9kc1wfxg4c9 **
Alternate download: http://www.filedropper.com/march2011excelwebinar
Webinar video viewing requirements:
- Windows Media 9 or higher
- GoToMeeting Codec (if you do not already have it installed, you may download it here: http://www.gotomeeting.com/codec )

Category:

Science & Technology

Tags:

• Microsoft Excel
• webinar
• solver
• curve fitting
• what if analysis
• regression analysis
• goal seek
• single value data table
• uncoded payment checks
• track work orders
• Experts Exchange

[GabiRav]

Zooming can make this video much better