Special Offers
FREE Webinar to help understand LiveOnline ***** There is no cost for this class.
The Excel Tips and Tricks mini course is a one hour free online session to review some commonly used commands. We will review the interface and introduce the Contextual ribbons, Quick Access toolbar, as well as show some of the common keyboard commands. We will also demonstrate how to create a simple formula, patch 2 cells into a single cell, and use the fill handle to copy the formula. Some of the common formatting features reviewed include the Currency method, Accounting method, use of the Font ribbon group, rotate a label, and Merge and Center. We will also define the printing area, scale the spreadsheet for printing, and repeat titles on every page.
LiveOnline training will allow you to take the class from your home or office computer. As you watch the instructor demonstrate a concept, you will then have the opportunity to try it out on your computer. A duel monitor is recommended, but two computers will also work (instructor's monitor on one computer and you practice the concept on the other computer.) A single monitor will work, as well, but you will need to minimize the screen to experiment with the concept.
Concepts Covered
Overview / Interface
Quick Access Toolbar
Keyboard Commands
Contextual Ribbons
Formulas
Autosum
Concatenate
Fill HandleFill Handle Formulas
Fill Handle Text
Formatting
Currency Method
Accounting Method
Text formatting
Borders
Rotate a cell
Merge & Center
Word Wrap
Hard Returns
Printing
Print Area
Scaling
Repeat Rows
Click Here to Learn More