10 Productive Excel Features for Accountants (and 3 Time wasters)
In this presentation Excel expert David H. Ringstrom, CPA cherry-picks 10 of the best features in Excel .
Date and time
Location
Online
About this event
- Event lasts 1 hour 30 minutes
In this presentation Excel expert David H. Ringstrom, CPA cherry-picks 10 of the best features in Excel that can make accountants more productive. He’ll also share 3 common time-wasters that can frustrate accountants and heavy users of Excel.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Microsoft 365 (formerly known as Office 365) version of Excel.
Session Highlights:
- Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
- Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
- Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets.
- Streamlining filtering of lists in Excel 2013 and later by using the Slicer feature with tables.
- Gaining control of long lists of data by filtering instead of sorting.
Why You Should Attend:
- Define the arguments used with the VLOOKUP function.
- Recall the benefits of Excel’s Table feature.
- State which Conditional Formatting menu contains the Duplicate Values option.
Notice for our “Live” Attendees: If you have enrolled in the “Live Webinar”, you will get your instruction kit before 24 hours of the live class.
For Recorded Participants: If you have signed up for the “Recorded” class, you will get access to the “Recording link” 24 hours after the live class.
Frequently asked questions
It's simple. Pick the numbers of attendees you want to enroll in the class, and choose your payment method. Fill the required details. And, that's it. You are good to go.
Certainly, you will get the credits if you sign up for the class. You will receive the credits within 24 hours of the live class.
Yes, you will receive the handout along with the webinar instruction kit for joining the live class. You can save the handout then. And, get back to you as many times as you want.
Participants will receive the webinar instruction kit for joining the live webinar 24 hours before the schedule date at their registered email address.