In this webinar, we will review three skills that help you work like an Excel ninja: getting information with Power Query, building effective pivot reports, and working with great speed through VBA/macros.
Identify the tool that imports data from multiple workbooks
State the command to import data files from a folder
Recognize the language used to write macros
PLEASE NOTE: ARCHIVED WEBINARS DO NOT QUALIFY FOR CPE
Award-winning instructor Jeff Lenning has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient.
About Our Presenter
If you could learn Excel simply and easily at your pace and could learn the features and functions that are relevant and practical to accounting professionals – would you want to? If you are an accounting professional and have taken Excel classes before, you know the pace can be too fast or too slow, and the content may not be relevant to your work. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way.
Become more efficient, streamline processes, and save time with Jeff Lenning’s Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you don’t. The content has been written from scratch integrating everything Jeff knows about Excel training learned over the past decade of providing continuing professional education.