1.5 CPE credit of Computer Software & Applications for all CPAs
1.5 CPE credit for Certified Management Accountants (CMA)
1.5 CPD credit (Verifiable) for Canadian CPAs
1.5 CE credit of Computer Technology for Maryland Tax Preparers
2 General Educational credit for Tax Professionals / Bookkeepers / Accountants
Building A 7-Figure Tax Practice While Black
How to build a successful tax practice
Top Hacks for Tax Season 2021
Four Essential Tools for Media Success
Pivot Your Marketing in Response to COVID-19
Public Relations and Marketing for Small Business Owners
Improve Your Virtual and In Person Networking Success
Lessons for In-Person Networking Success
Rev Up Your Newsletter or Start One
Why HER and Not ME? How YOU Can be the Accountant Reporters Call
Niche Strategy: Grow Your Bottom Line with High Value Clients
Succession Planning in Accounting Firms: How to Recruit, Develop and Retain Successors
Why You Should Care About the CARES Act
The Power of Succession Planning
The Power of Business Continuity
Microsoft surveys show that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with various data-handling tools to manage data efficiently. It’s all the more important these days as data collection has become more automated and you’re getting swamped with tons of data. But what can you do with all that data?
You need to know how to re-arrange the data (Sort), see just what you want to see (Filter, Slicer), create quick summaries (subtotal), restructure fields containing too much data (the exciting Flash Fill tool and the Text to Columns feature), and eliminate redundant records.
Converting your data into tables offers additional ease-of-use features (with a couple of downsides). If you are setting up new lists, you need to know the powerful validation tools that keep out bad data from the start and how to drastically reduce data entry with drop-down clickable lists.
New dynamic array functions, like FILTER, SORT, SOR TBY, and UNIQUE provide additional power as you work with lists.
MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478
MY-CPE LLC (Sponsor Id#: 143597) 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: www.NASBARegistry.org.
Principal, Taylor Associates
Dennis Taylor has taught thousands of Excel seminars and classes over the past 25 years, has presented over 750 Excel webinars, and has been the author/co-author of six books on spreadsheet software. He has taught hundreds of public Excel seminars throughout the US and Canada since 2006 and has recorded numerous Excel courses