Skip to main content.

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

February 08, 2023 9:00 AM



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 and easy way;
  • Use Conditional Formatting to highlight key worksheet entries automatically;
  • 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,