February 25, 2020
When I do a live Power Excel seminar, I offer that if anyone in the room ever has an odd Excel problem, they can send it to me for help. That is how I came to receive this data cleansing problem. Someone had a summary worksheet that looks like this.
February 24, 2020
The reason that co-authoring is possible is because of AutoSave. Every time that you make a spreadsheet change, that change will be saved to OneDrive so that others can (almost) instantly see what you just typed. AutoSave is necessary if you want ten accountants editing a budget worksheet at the same time.
February 20, 2020
After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017.
February 19, 2020
The Auto Recover feature is a lifesaver. It is turned on automatically in Excel 2010 and newer.
February 17, 2020
The Excel team offers Currency, Percent, and Comma icons in the center of the Home tab of the Ribbon. The tooltip says the Comma Style formats with a thousands separator. I despise this icon. Why do I despise this icon?
February 13, 2020
Anything you do to Book.xltx (default workbook) is cumulative. Build the workbook with your favorite settings today. If you discover some new settings that you would like to add to Book.xltx in the future, follow these steps:
February 12, 2020
In a few minutes, you can teach Excel your favorite settings. Then, every time you create a new workbook with Ctrl+N or insert a new worksheet, the worksheet will inherit all of your favorite settings.
February 10, 2020
Say that you want to build the following report, with months going down column A. In each row, you want to pull the grand total data from each sheet. Each sheet has the same number of rows, so the total is always in row 12.
February 6, 2020
You have a workbook with 12 worksheets, 1 for each month. All of the worksheets have the same number of rows and columns. You want a summary worksheet in order to total January through December.
February 5, 2020
Any time your manager asks you for something, he or she comes back 15 minutes later and asks for an odd twist that wasn't specified the first time. Now that you can create worksheet copies really quickly.
February 3, 2020
When you select two or more numeric cells, the total appears in the status bar in the lower right of the Excel window.
January 30, 2020
Say that you want to add a total row and a total column to a data set.