Using Excel’s Transform Data by Example Add-in Dating back to Excel 2010, Microsoft has been adding features to Excel to assist us in transforming our data so that it is…
Tag: Excel
The Top Five New Features In Excel 2019
Now that Excel 2019 has been available for approximately six months, many companies have begun the process of upgrading their team members to the new version of Microsoft’s market-leading spreadsheet…
Power Query - One-Stop Data Shopping
Power Query: One-Stop Data Shopping Thomas g. stephens, Jr., Cpa, CGMA, CITP Like any good CPA, you want to harness the tools at your disposal to maximize your value. One…
Working with Stock and Geography Data Types in Excel
Working with Stock and Geography Data Types in Excel Microsoft recently added two new data types to Excel – 1) Stock and 2) Geography. If you use Excel 2019 obtained…
Unpivoting Data with Excel's Power Query Tool
Unpivoting Data with Excel’s Power Query Tool Power Query – a feature available in Excel dating back to 2010 – has emerged as “mainstream” tool for many Excel users. No…
Adding Performance Bands to Charts
Adding Performance Bands to Charts Many business professionals use charts when attempting to communicate more effectively. Unfortunately, these charts are not always as helpful as they should be. A common…
K2's Introduction to Excel Macros
K2’s Introduction to Excel Macros Course Description You have used Excel for years and perhaps Lotus prior to that. During this time, you have said repeatedly, “One day, I’ll learn…
K2's Advanced Excel Reporting - Best Practices, Tools, & Techniques
K2’s Advanced Excel Reporting – Best Practices, Tools, & Techniques If you need to build advanced Excel reports, including reports where the source data resides in your accounting software or…
K2's Excel Tips and Tools for Better Budgets
K2’s Excel Tips and Tools for Better Budgets Excel is the de facto budgeting and forecasting tool for most professionals, yet many who use Excel for these tasks do not…
K2's Testing and Auditing Excel Workbooks
K2’s Testing and Auditing Excel Workbooks Course Description Excel errors continue to plague organizations of all sizes – estimates peg the error rate at approximately 90%. As spreadsheets become ever-more…