Learn Something New Beyond Excel

AZONE Pureneemo Character Series No. 96 High School Fleet Cape Mino
Glitter Galaxy Collectibles Rainbow Poo Emoji Mug with Lid 20 Ounces

If you love Excel, and want to expand your horizons a bit, there are a couple of great opportunities for you to learn something new, beyond Excel features and formulas. Are you ready for an adventure?

Continue reading "Learn Something New Beyond Excel"

Your Top Excel Tips For Beginners

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?

Just the Right shoes Fire and Water Club Edition 2002 Mint in Box

List All Excel Files with Dates

Hobby Japan MARK43 1 43 Honda Civic SIR II (EG6) frost white

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.

Continue reading "List All Excel Files with Dates"

Show Excel UserForm Automatically When Workbook Opens

Generic 50Pcs PG1823 Super Heroes Playwright Stan Lee Stanley Martin Lieber Iron Man Spider-Man Collection Four The Hulk Toys Kids Toys PG1569 50Pcs

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.

Barbie 2002 Limited Edition Winter Concert Collectible Doll

Sword Art Online double suede tapestry New Year Ver. Length of about 72.8cm × 51.5cm horizontal

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.

Continue reading "Preview Picture Problems in Excel"

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.

LHI FPV Kit APM Flight Controller Board F450 PCB Frame APM 2.8 M8N GPS 2212 920KV Motor simonk 30A ESC 9443 Props for Quadcopter Russia