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?

F 90cmx200cm HLMIN Pure Coton Baby Crawling Mat Super Soft Smooth Touch Foldable Super Thick Anti-slip For Bed Floor (color E, Size 200cmx220cm)

List All Excel Files with Dates

Wo -class aircraft carrier fleet size Parker Collection - - this ship XL

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

Steiff 240188 Jocko Monkey Music Box, Brown Beige Green

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.

Multicolor Standard Star Wars Rubie's Costume Samurai Darth Vader Costume

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.

Maisto Year 2015 Special Edition Series 1 18 Scale Die Cast Car Set - bluee color 2005 State Police Cruiser Chevrolet Corvette Coupe with Display Base (Car Dimension 9 x 4 x 2-1 2 ) by Maisto