Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 16th Nov'24 to 26th Nov'24
Excel Tips & Tricks - Part 3
- Interesting way to access every 3rd column in another sheet
- If you have “3x4x5” in a cell, how can you calculate it?
- Make a multiplication table in one formula in one cell
- Interesting formatting
- In one formula, sort a 4-row grouping of name, address
- A little trickery with VBA & Userforms
- Putting comments into a formula
- Setting a default Shape
- Copy a page setup from one sheet to others
- Getting data from the statusbar
- Advanced filter
- Aligning objects
- Adding time
- Formatting errors
- Trick to adjust row heights from merged cells
- New uses for AutoSum
- Interesting formulas for getting a grand total with embedded subtotals
And so much more!
Overview of the webinar
There are many shortcuts to do the work you do. This course shows many tips & tricks which many experts aren’t aware of and which save you lots of time. One of my favourite comments which came from this course was, “This Isn’t Excel, it’s Magic!” It also became the title of one of my books!
You will become more efficient and save time once you’ve seen the amazing shortcuts and tips that are built into Excel. You will be wowed at the new ability you will have once these shortcuts are discovered.
Who should attend?
Anyone who uses Excel needs to be able to make their work more efficient. So, this course is for
- All Excel Users
Why should you attend?
Excel is a widely used spreadsheet program that helps users to manage, organize, and analyze data effectively. However, the software can often be time-consuming and frustrating to use, especially when it comes to large datasets. Excel Tips & Tricks is a topic that focuses on providing users with powerful and time-saving excel shortcuts that can help accomplish tasks efficiently and with less stress.
This topic is ideal for individuals who work with Excel regularly as it provides many tips and tricks that can be used to simplify tasks, increase productivity, and reduce errors when working with large amounts of data. The shortcuts are also relevant for both novice and experienced Excel users, helping them become more proficient in their work.
Faculty - Mr.Bob Umlas
Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients from 1998 to 2018.
He has been using Excel since 1986 - version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. At the time, most issues contain either an article by Mr. Umlas on using VBA (Visual Basic for Applications) or some tip or technique from him on using Excel. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel.
Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1994-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called "Maximizing Excel Development Using Array Formulas" at Microsoft's Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City. He has hosted London’s Global Excel Summit each year since 2021, and in person in 2024, as well as led a session on tips and tricks. He also led a session on tips and tricks at the Las Vegas’ Financial Modeling World Championship in December, 2023. He has led online sessions all over the world including Africa, India, England, Canada and of course, the USA.