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?
WHY SHOULD YOU ATTEND?
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
AREA COVERED
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
LEARNING OBJECTIVES
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”
WHO WILL BENEFIT?
Any Excel user!
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
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
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”
Any Excel user!
Speaker Profile
Bob Umlas
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.
Upcoming Webinars
Bootcamp for New Managers and Supervisors: Avoid These 7 Mi…
By:Marcia Zidle
Nov. 30, 2023
10:00 AM PDT | 01:00 PM EDT
Strategic Interviewing & Selection: Getting the Right Talen…
By:Pete Tosh
Nov. 30, 2023
12:00 PM PDT | 03:00 PM EDT
Conflict Resolution in a Remote Workplace
By:Natasha Nurse
Nov. 30, 2023
10:00 AM PDT | 01:00 PM EDT
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
By:Dr. Susan Strauss
Dec. 1, 2023
12:00 PM PDT | 03:00 PM EDT
Workplace Investigations 101: How to Conduct your Investiga…
By:Dr. Susan Strauss
Dec. 4, 2023
10:00 AM PDT | 01:00 PM EDT
Cleanroom, Microbiology and Sterility Assurance Practices f…
By:Kelly Thomas
Dec. 4, 2023
12:00 PM PDT | 03:00 PM EDT
5 Key Components of Good Manufacturing Practices to obtain …
By:Meredith Crabtree
Dec. 5, 2023
12:00 PM PDT | 03:00 PM EDT
Successfully Negotiating the Labor Agreement
By:Gerry McLaughlin
Dec. 5, 2023
12:00 PM PDT | 03:00 PM EDT
Understanding the incredible uses and fallbacks of ChatGPT
By:Justin Muscolino
Dec. 5, 2023
10:00 AM PDT | 01:00 PM EDT
Wage And Hour Laws: Ensuring Compliance With The Fair Labor…
By:Diane L. Dee
Dec. 5, 2023
10:00 AM PDT | 01:00 PM EDT
How to Manage Conflict in the Workplace
By:Susan Schoenfeld
Dec. 5, 2023
10:00 AM PDT | 01:00 PM EDT
Neutralizing Harassment - How to Promote the Proactive Pers…
By:Beverly Beuermann-King
Dec. 5, 2023
12:00 PM PDT | 03:00 PM EDT
Human Error Reduction Techniques for Floor Supervisors
By:Ginette M. Collazo
Dec. 6, 2023
10:00 AM PDT | 01:00 PM EDT
Hybrid Workplace: 10 Best Practices to Manage Your Team’s P…
By:Marcia Zidle
Dec. 6, 2023
12:00 PM PDT | 03:00 PM EDT
Using Better Managerial Decision Making - to get great resu…
By:Bill Straubinger
Dec. 6, 2023
12:00 PM PDT | 03:00 PM EDT
Changing Behavior: Why Rewards and Punishments Often Aren't…
By:Rebecca Staton-Reinstein
Dec. 6, 2023
12:00 PM PDT | 03:00 PM EDT
Excel - Pivot Tables - The Key To Modern Data Analysis and …
By:Mike Thomas
Dec. 7, 2023
10:00 AM PDT | 01:00 PM EDT
Using Stay Interviews To Improve Employee Retention & Engag…
By:Pete Tosh
Dec. 7, 2023
12:00 PM PDT | 03:00 PM EDT
Form W-9 Compliance to Avoid Penalties: TIN Verification, B…
By:Patrick Haggerty
Dec. 7, 2023
12:00 PM PDT | 03:00 PM EDT
Using High-Performance Coaching for Managers to Address Per…
By:William J. Rothwell
Dec. 7, 2023
12:00 PM PDT | 03:00 PM EDT
FDA Technology Modernization Action Plan (TMAP) and Impact …
By: Carolyn Troiano
Dec. 12, 2023
10:00 AM PDT | 01:00 PM EDT
FDA Audit Best Practices - Do's and Don'ts
By: Charles H. Paul
Dec. 12, 2023
10:00 AM PDT | 01:00 PM EDT
Stay Interviews: A Powerful and Low-Cost Employee Engagemen…
By:Marcia Zidle
Dec. 13, 2023
10:00 AM PDT | 01:00 PM EDT
Become an excellent Critical Thinker to greatly improve you…
By:Bill Straubinger
Dec. 13, 2023
10:00 AM PDT | 01:00 PM EDT
Learn the Do's and Don'ts of Opening Business Bank Accounts
By:Justin Muscolino
Dec. 14, 2023
12:00 PM PDT | 03:00 PM EDT
Project Management for HR, Administrative Professionals, an…
By:Rebecca Staton-Reinstein
Dec. 15, 2023
12:00 PM PDT | 03:00 PM EDT
Writing Effective 483 and Warning Letter Responses
By:Kelly Thomas
Dec. 19, 2023
12:00 PM PDT | 03:00 PM EDT
Dealing With Difficult People In Life & Work
By:Paul J. Cline
Dec. 19, 2023
10:00 AM PDT | 01:00 PM EDT