.png){kind=logo}
Instructor
Jeff Lenning
Instructor
Learn about the features you need to achieve greater efficiency and automation. Written by a CPA who is recognized by other CPAs as an Excel expert, this course is for accounting and finance professionals who have a good grasp of Excel and want to take their skills to the next level. The course now includes Excel 2016.
▪ Automate recurring processes
▪ Use the most powerful features of Excel
▪ Know which features and functions should be used for various high-level tasks
▪ Advanced pivot tables
▪ External data ranges (ODBC)
▪ Visual basic: macros and user defined functions
▪ Digital workpapers
▪ Securing worksheets and workbooks
▪ Named ranges
▪ Vlookup() and related functions that Nest Offset(), Text(), Match()
▪ IF function and other efficiency gains
▪ Encryption and data validation
None.
Accounting and finance professionals in public practice or industry