Bill Jelen on CFO Today: 90 Minute Power Excel!!
Focused on intermediate and advanced Excel users, Bill’s aim during this Webcast is to have you put what you learned to work the next time you open up a spreadsheet.
During this Webcast, Bill provides examples and works through several key techniques, including how to:
- Write effective formulas, including text formulas;
- Do a two-way lookup, both vertical and horizontal;
- Add thousands of subtotals in seconds;
- Quickly work the ins and outs of pivot tables;
- Power up your IF statements;
- Do faster filtering;
- Create perfect charts in a single keystroke; and
- Apply dozens of additional tips and tricks that allow you and your finance team to use Excel more quickly and efficiently.
During this Webcast, Bill uses Excel 2010 for demonstration purposes, but regularly points out how participants using earlier versions of Excel can produce the same results.