K2’s Microsoft 365/Office 365 – All The Things You Need To Know Course Information 8 CPE Credits 8-Hour Course Computer Software and Applications (8 Credits) Fundamental Understanding of Computer Operations…
Tag: Excel
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…
Cleaning Data with Excel's Trim Function
Click here to see more Tech Tips Cleaning Data using Excel’s TRIM Function When working in Excel, sometimes the data in a worksheet is “dirty” and contains leading or trailing…
Using Excel's AutoCorrect Feature to Store and Insert Formulas
Many Excel users find themselves frequently entering the same formula and are seeking a method through which they could store the formula and recall it on demand in the future.…
PivotTables are one of Excel’s most powerful features – if not THE most powerful feature – and are exceptionally useful at summarizing large volumes of data when preparing analytical reports.…
Excel Formatting Essentials
Excel Formatting Essentials Accounting and financial professionals often spend countless hours working with Excel, their tool of choice for so many tasks. Unfortunately, much of their time spent in Excel…