Advanced Excel Keyboarding

AdvancedFull Day1 DayVersion 365Official CPE Provider

Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.

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

7 lessons · 21 topics

1Lesson 1: Getting Started with Keyboard Shortcuts

Navigate Windows/Desktop
General Microsoft Office Shortcut Keys
Common Accelerator Keys and Key Tip Badges

2Lesson 2: Working with an Excel Workbook

Ribbon and Quick Access Options
Navigate within Excel
Data Selection
Dialog Boxes
Use submenus

3Lesson 3: Modifying/Formatting Data and Worksheets

Format Worksheet
Format Data
Copy and Fill Down Formulas and Values in Large Data Sets

4Lesson 4: Managing Multiple Workbooks

View options
Work across workbooks

5Lesson 5: Data Tools

Sort, Filter
Import Data
Tables/Named Ranges

6Lesson 6: Formulas

Create and Modify Simple and Complex Formulas
Link Formulas across Workbooks
Use Function Keys within Formulas

7Lesson 7: Pivot Tables

Create and Use Pivot Tables
Create Pivot Chart

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals