K2’s Introduction to Excel Macros You have used Excel for years and perhaps Lotus prior to that. During this time, you have said repeatedly, “One day, I’ll learn how to…
Tag: Excel
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 New Course for 2019! Course Description Excel errors continue to plague organizations of all sizes – estimates peg the error rate at approximately 90%.…
K2's Microsoft Office 365 - All The Things You Need To Know
K2’s Microsoft Office 365 – All The Things You Need To Know New Course for 2019! Course Description Microsoft Office 365 continues to grow and evolve, yet most subscribers are…
K2's Excel Financial Modeling Best Practices
K2’s Excel Financial Modeling Best Practices Excel remains the tool of choice for many professionals when building financial models, including forecasted financial statements and budgets. Yet many of these professionals…
K2's Excel Data Models, Combinations, and Consolidations
K2’s Excel Data Models, Combinations, and Consolidations Combining and linking data from multiple tables, sheets, and workbooks is a daily need for most accountants, yet many do not fully appreciate…
Adding Slicer Filters to Tables in Excel
Adding Slicer Filters to Tables in Excel Tables were added to the 2007 release of Excel and provide exceptional functionality as automatically expanding and contracting ranges of data. However, you…
Working with Excel's CHOOSE Function
Click here to see more Tech Tips Working with Excel’s CHOOSE Function Excel’s CHOOSE function provides a great alternative to using other lookup functions when you might need to find…
Using Excel's Flash Fill Tool to Clean-Up a QuickBooks Trial Balance
Click here to see more Tech Tips Using Excel’s Flash Fill Tool to Clean-Up a QuickBooks Trial Balance Excel’s Flash Fill tool — first introduced with the 2013 release of Excel…