Published: July, 2020
In this outstanding course, Excel expert David Ringstrom, CPA, will expand your knowledge of pivot tables and show you step-by-step how to manipulate pivot table data faster and more efficiently. You’ll learn how to extract data from Microsoft Access databases and other sources, minimize repetitive steps in Excel by creating keyboard shortcuts, and adapt simple macros that can be recorded. In addition, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Linked Picture feature, the PowerPivot feature, and others.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Who Would Be Interested in This Course:
Practitioners who would like to learn how to manipulate their pivot table data faster and more efficiently.
President Excel Accountant
I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:
Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:
I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.
I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.
I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.
Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting
Excel Accountant is an exclusive excel training platform for CPA, Tax Professionals, Accountants, Bookkeepers, Financial Professionals, CFP, EA, CFOs & Controllers etc and the entire Accounting, Finance & Tax community.
Here is what you get for the yearly subscription from Excel Accountant website.
Dec 1st, 2020
A very details and great course! if you want to learn Excel and you are working in Finance/accounting field, this is the course you should enroll. Each chapter has a very details note, you may download the notes and keep if for future reference. I was surprised on the dashboard being done in this course! never thought I can use excel to create such a insightful and wonderful dashboard
Dec 1st, 2020
I am highly impressed with the course content and its coverage. I am heartily thankful to the author of the course for this wonderful creation. only one thing is that, Macros part is very less. It can be more elaborated. otherwise I am fully satisfied with the course. The training is very detailed, comprehensive and a good course for someone who wants to develop proper excel skill.
Dec 27th, 2021
Very good information
Dec 10th, 2021
The format and pacing of the webinar makes understanding complex concepts easy to understand.
Dec 10th, 2020
100% learning new material... was already of the basic copy and paste options, but using the 'alt E+S+V' as paste special values is something new to me, instead of right clicking and choosing the necessary option.