Excel: Shortcuts

Excel: Shortcuts

Learning Outcomes:

• Correctly create toolbars to customize worksheets and job functions as shown in the exercise.
• Accurately demonstrate the most efficient ways to enter text using information in the Lesson Lab.
• Using directions in the Activity Lab, correctly show skill in working with numeric formats, creating codes, and working with Styles.
• Efficiently describe the “shortcut” techniques available with the AutoFill function, how to customize AutoFill and work with ranges using the scenarios presented.
• Given the criteria, successfully develop calculations and formulae.

This highly intensive one-day class will provide the student with real life examples and will be a fast paced session. Learn how to make your job quicker and easier by taking “Shortcuts”.

-Navigating the worksheet and workbook
-Customizing the workbook and toolbars
-Tips for entering text
-Working with text and numbers
-Calculations
-Formulas
-Filters
-Sorting
-Formatting techniques

Excel: Shortcuts

Learn the quickest way to navigate among worksheets. Create your own toolbars to help customize your worksheets and job functions. Learn shortcut menus, the most efficient ways to enter text and many, many formatting tips. Spend time working with numeric formats, creating codes, working with Styles. Learn the “shortcut” techniques available with the AutoFill function, how to customize AutoFill and work with ranges. Develop your calculation and formula skills. All throughout the day, keyboard shortcuts will be examined to help you quickly access each function. This class is full of task specific topics to help you better manage your workflow. Feel free to ask questions or bring up problem areas you have encountered in working with Excel.

Class targeted to: Students who want to learn to use Excel to its fullest; taking advantage of the many time saving tips and techniques that are available.

Prerequisites: Windows: Introduction and Excel: Introduction or equivalent knowledge.

Click here for Registration Form


Request More Information