Many Excel users struggle with formatting their spreadsheets to give them a polished and professional appearance. Among the challenges these users face is how to center text over multiple columns.…
Tag: Excel
Five New Excel Features to Boost Productivity in 2020
As you are no doubt aware, Microsoft added many new features with the release of Excel 2019 and continues to update the venerable spreadsheet application through updates to Office 365.…
Excel's New Dynamic Array Feature
Excel’s New Dynamic Array Feature Excel’s new dynamic array feature is one of the best enhancements Microsoft has added to Excel in years. With dynamic arrays, we now have the…
Excel's XLOOKUP Feature Begins Arriving
Microsoft has begun rolling-out Excel’s anticipated XLOOKUP feature to some Office 365 subscribers. While not all Office 365 subscribers yet have access to this feature, if you are an Office…
Use Power Query to Split Data Into Multiple Columns
Excel offers multiple ways to split data in a cell. Among these are the venerable Text to Columns tool, Flash Fill, and writing formulas that incorporate Excel functions such as…
How to Link QuickBooks Data into Excel
As an accounting application designed for small businesses, QuickBooks and QuickBooks Online have relatively robust reporting options. In addition to numerous, standard reports, these tools offer customization options and the…
Excel's Easy to Use LARGE and SMALL Functions
For many years, the MAX and the MIN functions have overshadowed Excel’s LARGE and SMALL functions. However, as you will see in this tip, the LARGE and the SMALL functions…
Using Power Query To Combine Excel Workbooks
The more we dig into Excel’s Power Query feature, the more we find out just what a powerful tool it really is. For example, Power Query includes tools to ease…
Does Your Version of Excel Contain Power Pivot?
Over the years, knowing whether you have access to the Power Pivot feature in Excel has been challenging at times to say the least. First introduced as an add-in for…
K2's Advanced Excel Data Magic - Managing, Analyzing, and Reporting
K2’s Advanced Excel Data Magic – Managing, Analyzing, and Reporting New Course for 2020! Course Description With tools such as Data Models, Power Query, and Power Pivot, today’s versions of…