Excel Advanced Keyboarding
Work faster in Excel with your hands on the keyboard, not the mouse. Master the navigation, selection, formatting, and formula shortcuts that turn everyday tasks - even PivotTables - into a few quick keystrokes.
Course objective
Work like a Pro in Excel by keeping your hands closer to the keyboard, and eliminating the use of the mouse. This class will increase your productivity, help you become more efficient by fully using Excel, and reduce the strain on your muscles from unnecessary, time-consuming wrist movements. Build formulas, work with charts, navigate workbooks and tabs, and even build a pivot table ALL without the use of your mouse.
Prerequisites
Be familiar with formulas (VLOOKUP, MIN, MAX, SUMIFS, and AVERAGEIFS), pivot tables, and charts. Keyboarding Highlights: Get to know the most commonly used power shortcuts
Course outline
- Navigate Windows/Desktop
- General Microsoft Office Shortcut Keys
- Common Accelerator Keys and Key Tip Badges
- Ribbon and Quick Access Options
- Navigate within Excel
- Data Selection
- Dialog Boxes
- Use submenus
- Format Worksheet
- Format Data
- Copy and Fill Down Formulas and Values in Large Data Sets
- View options
- Work across workbooks
- Sort, Filter
- Import Data
- Tables/Named Ranges
- Create and Modify Simple and Complex Formulas
- Link Formulas across Workbooks
- Use Function Keys within Formulas
- Create and Use Pivot Tables
- Create Pivot Chart