I teach around 175 live webinars annually on Microsoft Excel across roughly two-dozen training providers.

Perimeter Chapter, Georgia Society of CPAs.Atlanta chapter, American Society of Women CPAs.Georgia Government Finance Officers Association.National Association of Certified Valuators and Analysts.I have spoken at conferences or meetings for these organizations: Our services include training, technical support, accounting automation, and problem solving. I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. How to work in Excel with ease by a much better presentation of data?.

How to become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work?.

What are the Conditional Formatting Formulas?.

In this online continuing education program following major topics are covered: Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. David also provides an Excel workbook that includes most of the examples he uses during the webcast. 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. Conditional formatting is a simple tool that allows you to visually highlight information based on a set of criteria and can be used in a variety of ways.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. The good news is you don’t have to ramp up the font to a cartoonish size to get relief. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.īut staring at Excel Spreadsheets for hours on end can put a strain on accountants’ eyes. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features.

Conditional formatting excel 2016 names