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…
Tag: Excel
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 Information 4 CPE Credits 4-Hour Course Information Technology (4 Credits) Fundamental Knowledge of Excel 2013 and Newer Prerequisites Intermediate Program Level No Preparation…
K2's Microsoft Office 365 - All The Things You Need To Know
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…
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…