Description
$130 (per person) includes an online webinar for 2 hours of CPE credit
Excel is one of the most powerful tools available to government auditors. Let college professors Wendy Tietz and Tracie Miller lead you through a hands-on webinar showing you a number of tips and tricks in Excel to enhance productivity.
Topics include an overview of the interface and key features such as AutoFill, Flash Fill, and managing Excel tables.
Tips related to data validation, conditional formatting, advanced data cleanup, and XLOOKUP will be shared.
The session also includes overviews of SmartArt, pivot tables, pivot charts, and decision-making tools and wraps up with an introduction to themes and templates. Don’t miss this helpful live session!
Learning Objectives:
- Describe Excel’s interface and basic features
- Apply keyboard shortcuts to perform basic Excel commands
- Apply time-saving Excel techniques to a variety of tasks relevant to government auditors
Program Level: Beginning
Field of Study: Auditing (Governmental)
Who Should Attend: Auditors
Prerequisites: none
Instructional Method: Webinar (Group Internet Based)
Advanced Preparation Required: Participants should have Excel for Microsoft 365, Excel 2021, Excel 2019, or Excel 2016 installed on their computer prior to attending this workshop.
CPE Credit Hours: 2
Date: Wednesday, November 29, 2023
Time: 12:00 p.m. – 2:00 p.m. Central
Time Saving Tips and Tricks to Boost Your Excel Productivity Webinar Leaders:
Wendy Tietz, Professor, Kent State University
Wendy M. Tietz, PhD, CPA, CMA, CSCA, CGMA, is a professor in the Department of Accounting in the College of Business Administration at Kent State University, where she teaches financial and managerial accounting. Dr. Tietz is a Certified Microsoft Trainer and has earned the Microsoft Office Specialist Excel designation. She is a member of the American Accounting Association, IMA, AICPA, and the Ohio Society of CPAs. She has published articles in such journals as Issues in Accounting Education, Journal of Emerging Technologies in Accounting, IMA Educational Case Journal, and others. Dr. Tietz has received several national teaching awards and is the co-author of two accounting textbooks published by Pearson Education.
Tracie Miller (Nobles), Program Chair, Franklin University
Tracie L. Miller (Nobles), PhD, CPA, is the program chair for the B.S. Accounting program at Franklin University. She has extensive teaching experience including faculty appointments at Austin Community College, Texas State University, Aims Community College, and The University of Texas-Austin. Dr. Miller received her doctoral degree from Texas A&M University. Her research interest includes financial literacy education, culturally responsive teaching, and online learning. She has public accounting experience with Deloitte Tax LLP. She serves in numerous leadership roles for American Accounting Association, American Institute of CPAs, Teachers of Accounting at Two-Year Colleges, and Texas Society of CPAs. Dr. Miller has received several teaching and professional awards including the AAA / J. Michael and Mary Anne / Deloitte Foundation Cook Prize, TXCPA Outstanding Accounting Educator, and AICPA Bea Sanders Award. Dr. Miller is also an author of several accounting textbooks published by Pearson.
Yellowbook-CPE.com is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: