Excel Tips and Tricks - Put Excel Magic to Work for You July 12, 2022, 10:00am EDT July 12, 2022, 11:00am EDT

Learn to mystify and amaze with Excel features and techniques you can use
every day to work smarter and get more done.
This live, one-hour session will explain and demonstrate how to:
 Create custom number formats so the value 3,785,132 displays as $3.79 M,
while the exact unrounded amount is used for calculations;
 Use the AutoFill feature to enter a custom series by dragging the mouse,
including how to create a date series that lists weekdays only;
 Use text formulas and functions to manipulate character strings, for example
to combine first and last names from separate cells into a single entry;
 Insert functions into formulas the smart way;
 Use Conditional Formatting to highlight key worksheet entries automatically;
 Avoid errors, and locate their source when they occur; and
 Enter dates and times so they calculate correctly in formulas.
And, of course, every good magic show includes a few surprises.
There will be plenty of time for questions, so come prepared.

Presenter: Gerald Rosenthal, ComputerImages.com

Excel Tips and Tricks - Put Excel Magic to Work for You