Length
14 hours (2 days)
Class Time
8:30 a.m. – 4:30 p.m.
One-hour break for lunch and a 15-minute morning and afternoon break.
Location:
Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423
Course Description
This class is designed for the intermediate to advanced Excel user who wants to expand their knowledge of Excel. The focus of this class are topics such as Formulas, PivotTables, Charts, working with Multiple sheets and files and much more. Also we focus on learning shortcuts, keystrokes and the most efficient way to accomplish a task. In the class, you will learn:
FORMULA BASICS, ABSOLUTE REFERENCES AND NAMED RANGES
Review Basic Formulas
Work with Relative and Absolute References
Use Formula Auditing Tools
Create and use Named Ranges
Understand Guidelines and Scope of Named Ranges
Work with Shortcuts and Common Keystrokes
ADVANCED FORMULAS
Understand the Parts of a Function
Use Auto-Calculate
Create Subtotals and Grand Totals
Work with Order of Calculation
Learn the IF and VLOOKUP Function
Work with text functions like CONCATENATE, LEFT, RIGHT, LEN
More text Functions such as UPPER, LOWER AND PROPER
Use the Text-to-Columns feature
Look at the new Flash Fill feature
Use Paste Special
Protect your formulas and files
Work with Date Functions like TODAY and NOW
Perform Date Calculations
WORKING WITH MULTIPLE SHEETS AND LINKS
Learn Excel’s sheet options
Learn to quickly navigate sheets
Learn to Copy and Insert sheets
Rename and Color sheet tabs
Group sheets and work with all sheets simultaneously
Ungroup sheets
Move and Copy sheets within the workbook and to new workbooks
Create three-dimensional formulas
View multiple sheets at the same time
Link workbooks and manage the links
Use Comments
Freeze Rows and Columns
Learn to Split Views
CHARTING
Create a Chart
Change the Chart Layout and Style
Use the new Recommended Charts and Chart Types
Change the Chart Type
Modifying Charts and Work with Chart Elements
Expand the Chart Data
Create and use Chart Templates
Look at the new Sparkline feature
EXCEL’S DATABASE FEATURES
Setup your spreadsheet correctly for Data features
Learn to Sort alphabetically, numerically, chronologically, colors, by icons and by custom list
Use Data Subtotals
Learn various ways to Filter data
Create Tables and Understand their benefits
Create and Modify PivotTables
Work with PivotTable Slicers and Timelines
Work with Recommended PivotTables
QUICK LOOK AT OTHER EXCEL FEATURES
Modify the Quick Access Toolbar
Customize the Status bar
Learn the benefit of using Styles
Work with Conditional Formatting
Modify the Ribbon and use Text to Speech
Work with Custom Views
Who Should Attend
Intermediate or Advanced Excel users who would like to expand their knowledge of Excel
Prerequisites
Students must have a beginner level knowledge of Microsoft Excel.
Class must be canceled 5 days before start date