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, He is the founder of ComputerImages, a Boston-based software training and consulting firm, and has been using Excel since the program debuted as Macintosh only software in 1985. His professional training is in law and finance, and he describes himself as essentially a low-tech person. His interest in computers focuses more on how they can help people work smarter and better, rather than their technology.