Excel tips & tricks

Nearly everyone who uses Excel has their preferred way of doing things. In this webinar on Excel tips and tricks, we will show you that your frequently used, favorite ways of tackling tasks can be enhanced drastically. Perhaps given a ten-fold increase in efficiency in some cases! You will be wowed when you discover what Excel can really do. For example, suppose you wanted to make a Table of Contents for a workbook you inherit – with hyperlinks to each sheet. You will be shown a way to do that in this course. Or, how can you create a series of dates containing only the 1st and the 15th of each month? How would you insert a row between every existing row in under 10 seconds even if there were 1000 or more rows?

Learn new ways to think outside the box, using innovative solutions presented in the webinar. Attendees often say “I had no idea you could do that in Excel”

Selection tricks, Z-order of objects, Using fill handle to insert or delete rows, Making a Table of Contents, exploring an oddity, Amazing result using =SUMPRODUCT(SUBTOTAL(109,OFFSET(…, Fill right and have reference go down & vice versa, Auto-number questions, “Add to Print Area” command, Getting a random sample, Interesting formatting, powerful trace precedents, protecting a table, Images in Userforms, Removing Hard Space, Comments inside a formula, Creating default shapes, AND MORE

There is always more to learn in Excel. This instructor is the only person in the world who has achieved the designation by Microsoft of “Excel’s Most Valuable Professional” award for all 25 years of the program’s existence and has been using Excel since version 0.99 in 1986 and is constantly creating new tips and tricks. If you want to be more proficient and efficient in your everyday usage of Excel, this is a good webinar for you to learn ideas about how to do that. It’s thinking outside the box (or outside the cells). Although this topic has been seen on the Internet, this 60-minute presentation on tips and tricks is brand new and has not been seen on the Internet (yet)! So be among the first to learn these new tips and enhance your Excel “fluency”.

Other possible webinar topics:

• Pivot tables
• Dynamic Array functions
• Formatting
• Everything you wanted to know about Printing
• Excel functions you should know
• VBA

Any Excel user!

I have been using Excel since version 0.99 (on the Macintosh)! I was voted an “MVP” (Most Valuable Professional) by Microsoft for 25 years, from 1993-2018. I’m the author of 5 Excel books, available from Amazon.com or MrExcel.com. I consult and train on all levels of Excel. I lead the New York PC User's group on Excel monthly.