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
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.
Title: Excel Gantt Macro vba - Planificación de Proyectos
Video:
Description:macro vba Excel Gantt creación del diagrama o gráfico de gantt para cualquier tipo de proyecto, creación automática del informe de avance o retraso del proyecto y de las actividades que lo engloba.Puedes descargarlo en www.webandmacros.com
