You’ll learn the pros, cons, and limitations of each type of worksheet function as well as suggested uses for each.
David also explains how to create more flexible formulas using the INDIRECT and OFFSET functions, as well as how to verify sums and totals quickly and easily.
David typically demonstrates techniques from the version of Excel used by the majority of attendees. This means he uses Excel 2010, 2013, or 2016 to demonstrate techniques, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast.
Who Should AttendPractitioners seeking to understand alternatives to the SUM function in Microsoft Excel.
Instructional MethodGroup: Internet-based
NASBA Field of Study
Computer Software & Applications (2 hours)
Program PrerequisitesPrevious Experience Working in Excel.