This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Technical

Excel for Accounting Professionals Series Logo cgma

  Jeff Lenning, CPA, CITP |   £479.00 - 599.00 |   2018 |   16:00 h |   CGMA Store

The eight-part video series is designed to walk through the Excel features, functions and techniques that will save you time.

The series is designed progressively, ensuring that you have all prerequisite knowledge to understand and implement the topics discussed.

This is a comprehensive Excel series, not just a quick "tips and tricks" webinar.

It tackles real-world issues and builds robust workbooks that can truly drive productivity.

Topics discussed:

  • Tables and named references
  • Data validation and conditional formatting
  • Workbook design principles and organisation
  • Conditional summing and lookups
  • Error trapping and improving lookups
  • List comparisons and indenting
  • Data driven workbooks and concatenation
  • Dynamic headers, mapping tables and error check

Modules include:

  • Excel for Accounting Professionals Session 1: Tables and Named References
  • Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
  • Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
  • Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
  • Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
  • Excel for Accounting Professionals Session 6: List Comparisons and Indenting
  • Excel for Accounting Professionals Session 7: Date Driven Workbooks and Concatenation
  • Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check

Who should take this course?

  • Accounting and finance professionals
Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational
  • Management accounting: Technical: Accounting information systems: Information systems environment, Intermediate

Comments/Reflections