Tuesday 19 June 2007

Wall St. Training: 19.0 Advanced Excel for Data Analysis

Title:
Wall St. Training: 19.0 Advanced Excel for Data Analysis


Video:


Description:This course focuses on how to effectively and efficiently utilize Microsoft Excel for data analysis. A financial analyst will not only use Excel to build financial models, but also to crunch a large data dump. Learn how to minimize as much manual labor as possible, thereby saving time and performing more detailed analysis quickly. Apply commonly-used formulas in new and different ways; uncover often over-looked Excel formulas; streamline number crunching and analysis via functions and tools including pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis; enhance your spreadsheets with drop-down boxes, data validation techniques, automation of alternate row shading; take Excel to the next level with an introduction to building and automating simple macros and more! ***YOUTUBE VISITORS ONLY*** 10% off any online course, use Discount code: youtube www.wstselfstudy.com

Published:
20/Jun/2007

Thursday 14 June 2007

Making a Gantt Chart in Excel 2007

Title:
Making a Gantt Chart in Excel 2007Video:


Description:Using Excel 2007 to create a Gantt chart--a popular project management tool

Published:
15/Jun/2007

Sunday 10 June 2007

Excel 2007 Demo - Create charts

Title:
Excel 2007 Demo - Create charts


Video:


Description:See more Excel 2007 demos at office.microsoft.com In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them.

Published:
11/Jun/2007