On Twitter this week, David Napoli asked us – What top Excel tip would you teach in a class? David is planning an Excel class, and has most of the content ready, but wanted ideas from other people who have taught similar courses. What are your top Excel tips for beginners?
List All Excel Files with Dates
Last week, someone asked if I could stop zipping the sample Excel files that you can download from my website. Well, I thought about it carefully, and decided to leave things as they are. Excel helped me decide, and you can get the macro that I used, to list all Excel files with dates and sizes.
Show Excel UserForm Automatically When Workbook Opens
You can add a UserForm to your Excel file, so it’s easy for people to enter data, without going to the table where the historical data is stored. Usually, I add a worksheet button that opens the form. But, with a simple macro, you can show Excel UserForm automatically, when workbook opens.
Continue reading “Show Excel UserForm Automatically When Workbook Opens”
Excel Lookup Formula for Last Item in Column
How can you get the last number in an Excel column? I needed to do that in one of my sample files, so here’s the formula that I used. Then, someone asked me how to get the last item (text or number) from a column, so there’s a formula for that too.
Continue reading “Excel Lookup Formula for Last Item in Column”
Add Month Sheets Automatically in Excel
Set up a Master sheet in your Microsoft Excel workbook, and add monthly sheets automatically, based on that template. The new sheets will be named for the month and year, in yyyy_mm format.
Errors in Pivot Table Totals
Pivot tables are a quick and easy way to summarize a table full of data, without fancy formulas. Occasionally though, things can go wrong. Today we’ll figure out why you might see errors in pivot table totals or subtotals, when all the item amounts look fine. Continue reading “Errors in Pivot Table Totals”
Preview Picture Problems in Excel
In the good old days of Excel, you could change a workbook setting, and see a preview picture of the file contents, before you opened it. That feature was available in Excel’s Open window, but has disappeared in newer versions of Excel. Here’s how to see Preview Pictures, and a warning about using them.
Excel UserForm Builder Add-in
If you’ve purchased a copy of my UserForms for Data Entry kit, there’s a new bonus for you — the UserForm Builder (UFB)Â add-in. Watch the video below, to see how it works, and download the latest version of the kit, to try it out.
Confusing Options on Excel Status Bar
The Excel Status Bar shows you messages about what’s going on, while you work. Some of those messages are optional, and you can turn them on or off. Here’s how you can customize the Excel Status Bar, and see my notes on a couple of the options that were confusing.
Excel Custom Styles Problem
When you create an Excel Table, or a Pivot Table, a default style is applied. You can change to a different built-in style, or create custom styles, with your own formatting. There are details below, and an Excel custom styles problem that you might run into.