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

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, ComputerImages.com