Excel’s new LET function can really help you to simplify and streamline your formulas. With LET, you can declare variables within a formula and then use those variables to shorten…
Tag: Excel
Converting And Importing PDF Data Into Excel
Did you know that you now have the option of converting and importing PDF data into Excel? In this tip, you will learn just how easy it is to import…
Comparing Excel's Merge Cells and Center Across Selection Features
Merge Cells and Center Across Selection are long-standing features in Excel. You can use both these features to change the appearance of data in a spreadsheet. In this tip, you…
Excel's Ideas Feature - A Great Way To Summarize And Analyze Data
Excel’s Ideas feature offers tremendous opportunities for you to summarize and analyze data automatically. In this tip, you will learn how you can take advantage of Ideas.
Rethinking Sorting And Filtering in Excel
When sorting or filtering data in Excel, most users instinctively click the drop-down arrows at the top of a column to initiate the process. In this tip, you will learn…
Solve Formatting Issues in Excel with Center Across Selection
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.…
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…