Learn Something New Beyond Excel

DESKTOP REAL McCOY DRAGONBALL Z Goku 01 Repaint No.02 Miyazawa Distribution Limited about 150mm Painted figures
Bucilla Stamped Cross Stitch Crib Cover Kit, 34 by 43-Inch, 46024 Cute-a-Saurus

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?

SeSDY Pet Nest Deep Sleep Family Comfort Teddy Fleece Kennel Pad Pet Cage Four Seasons Pet Supplies (color Brown, Size XS)

List All Excel Files with Dates

Henbrandt Pink Metallic Shimmer Curtain 92 x 244cm - Pack of 25

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

Fate kaleid Liner Prisma Illya 2wei Herz Chloe (Beast Style) 1 8 Scale PVC Figure

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.

Road aesthetics 02 run 1 32 (SP7) (japan import)

Ganz 23cm bluee My First Doctor's Bag Playset

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.

Flameer Mini Hot Air Stirling Engine Motor Model (Balance Type) Electricity Generator Educational Physical Science Kits