I am launching a new add-in today for Excel 2000 through Excel 2010. Easy-XL adds 50 powerful data analysis tools to Excel.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Microsoft is releasing a new look for the Excel Quick Access Toolbar and Ribbon. The feature is rolling out slowly to beta Insiders now. Here is a first look at the QAT and Ribbon.
Can you sort one column in an Excel table using the Filters and not sort the other columns? This would be easy if it was a range. But it you press Ctrl+T, I am not sure of a good way.
So - the weekend challenge: Does anyone have a clever way of solving this?
A new feature debuting in Microsoft 365 Excel. If you save your file to OneDrive Excel will record every change anyone types in the workbook. You can then see those changes using Review, Show Changes, in Excel Online. It is tracking the changes anyone is making in Win32 Excel. This is HUGE!
New in Excel for Microsoft 365: Hold down Ctrl and Shift while scrolling the wheel mouse to scroll sideways.
Today, Bill has data where the amount of indent is telling him some data. He shows how to use VBA and IndentLevel to add a column of data showing the indent level. Then, a second technique, using the Group button on the Data Tab to make an outline view in Excel.
May 20th, 2021 is Global Accessibility Awareness Day. It is a great day to take a look at the new Check Accessibility tab in the Excel ribbon.
Are you trying to use the Analysis ToolPak dialog box?
There is a better version, for free, from Frontline Systems.
Running into a bug? Microsoft knows about the problem.
George Mount's book: Advancing into Analytics: From Excel to Python and R 1, Mount, George - Amazon.com
Dan Fylstra's XLMiner info: XLMiner Analysis ToolPak
In an episode guaranteed to hack off many of my friends, Bill and Ann K. Emery discuss some Excel features they don't like, such as:
The Action Pen
Shoot a Photo Of Your Data
Ctrl+T Tables
Conditional Formatting Data Bars with a Gradient.
Check out Ann's blog post on 24 conditional formatting features to avoid: 24 Conditional Formatting Visuals in Microsoft Excel that Should Be Retired | Depict Data Studio
