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

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

Managing Toxic Employees: Strategies For Leaders To Effecti…

Marketing to Medicare or Medicaid Beneficiaries - What You …

Effective Onboarding: How to Welcome, Engage, and Retain Ne…




Employee Engagement, Empowerment and Motivation in Challeng…

2023 EEOC and Employers: Investigating Harassment and Discr…

Being Seen as a Human Resource Strategic Business Partner

Managing International Employee Payroll & Tax Services


Six Thinking Hats - Structuring Creative Thinking (Paralle…

Delivering Constructive Criticism - Best Practices

How to Effectively Conduct Annual Employee Reviews

3-Hour Excel Automation Boot Camp: Top Ten Excel Functions …

Self Esteem Matters: An Ethics Based Webinar for Women

Accounting For Non Accountants : Debit, Credits And Financi…


New Ideas and Tools for Effective Performance Management 20…


Supervising a Human Error Free Environment: You can do a Lo…

Effectively Handling CP 2100 letter and B Notices

Basic Accounting and Finance for the Human Resources Profes…

Compliance with Stop Payments vs Unauthorized Transactions

Finally! The New I-9 Form and The Extension of the DHS Remo…

The Most Frequent 483's for Medical Device Companies in 2022

CAPA/Root Cause Analysis: Achieving Compliance with Proper …

Secrets Of Psychology - Why People Do The Things They Do

Remaining Agile in an Ever-Changing Climate

Project Management for administrative professionals

4-Hour Virtual Seminar on FMLA BOOTCAMP: Managing Complianc…


Succession Planning for Sustainable Small and Family Busine…