Course Goals & Overview:
This course focuses on how learning the fundamental building blocks of Excel so you can begin to take advantage and leverage all of Excel's true capabilities. In order to efficiently build models and crunch large data dumps in Excel, one must master the basics before the advanced content. Learn relevant financial formulas, proper navigation, formatting of files and worksheets, creating calculations in cells, and linking between worksheets/tabs. Functions and tools covered in this course include: mathematical, financial, logic, date/time formulas; data manipulation; anchoring; data tables; and building a capstone model. Emphasis will be on using shortcut keys, simplifying steps, and manipulating data. You will leave with techniques you can use immediately, allowing you to work faster and with less effort.

Course Sections:

Course Goals & Overview:
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!

Course Sections:

Course Goals & Overview:
"A Picture is Worth a Thousand Words" - but what happens when you have the perfect image in your head but you can't get Excel to graph it the way you want? Ever get annoyed at constantly having to go back into "Source Data" whenever you add an item to your data series? Or how about getting the perfect sized bar or line without resorting to using a ruler to literally draw it on! This course builds upon our Advanced Excel for Data Analysis course and focuses advanced charting & graphing techniques and how to properly integrate with PowerPoint. A critical, must-take course especially for professionals that have to create graphs in their presentations, reports and slides. As usual, we emphasize and teach all the best practices and focuses on our core Excel learning goal: automation, automation, automation! Leave nothing to chance, there is always a way to simplify and automate your charting & graphing approach. This jam-packed session includes: waterfall charts, football fields, dymamic ranges, and much much more! Learn the best practices of integrating into PowerPoint, when to embed, link (never) and copy as picture, as well as add to our Excel macros with a couple handy PowerPoint macros.

Course Sections: