Learn Something New Beyond Excel

Dolity Flysky FS-NV14 14CH 2.4G AFHDS 2A RC Transmitter Controller w iA8x Receiver
Dry Erase Dungeon Tiles, Set of Nine 10 interlocking squares for role-playing and miniature tabletop games

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"

Draculaura is turning 1600 and is throwing the party of the millennium
All the ghoul kids will be there in their most fabulous party fashions
Includes exclusive skeleton key invite, scary cool outfit, and a birthday present
Fans of Monster High won't wait to get their claws on these dolls
Collect all your favorite Monster High Sweet 1600 dolls

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?

Flycolor 80A RC brushless ESC 2-6S SBEC 5.5V 4A Hobby Model Aircraft Helicopter Part Accessories Electronic Speed Controller for Airplane

List All Excel Files with Dates

Diamond 6-Gallon Ball Bucket with 30 Sports White Plastic Baseballs Hollow Balls for Wiffle Practice

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

Anchor Hocking Pint Mixing Glass - Rim Tempered - 16 Oz (4)

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.

YD Pet Travel Carrier Pet Stroller 3-wheel Pet Trolley Multifunctional Folding Large Dog Pet Cart Scooter Outdoor Travel Pet Supplies & (color RED)

TongT16 No Pedal Two-wheeled Training Bicycle Kids Bullet Balance Bikes Adjustable Height 12 Inch Aluminum Alloy Lightweight Body Design Girls Boys Aged 1-5 Years Birthday Present W-16

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.

gold Legacy New Year's Eve Party Assortment for 10