Excel Tips and Tricks - Put Excel Magic to Work for You
February 08 • 9:00 AM
Time: 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, ComputerImages.com