Seminar Getting the Most From Microsoft® Excel® Seminar

Presented by SkillPath Seminars

Skillpath Seminars

Bring this seminar on-site to your facility for groups of 10 or more.

This workshop will show you how to end your Excel frustrations for good by providing the “how-to’s” for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques.

Course Description


You’ll learn:

  • How to customize the ribbon to increase your productivity and even create new tabs and hide the ones you never use
  • Data, reports, graphs and formulas—making the most of Excel’s many talents
  • How to solve print problems and get your information to look the way you want it to
  • Spreadsheets, charts and more—easy ways to make spreadsheets and figures into colorful, clear and precise presentations
  • And much more

Do you ever find yourself searching through an Excel manual … wishing you had an Excel expert to ask … or even giving up in frustration by “working around” features that you know Excel is capable of because you don’t know how to use them? This workshop will show you how to end your Excel frustrations for good by providing the “how-to’s” for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques. Work smarter, not harder, by enrolling in this workshop today!

Program hours: 9:00 a.m. – 4:00 p.m.

Getting started—Excel essentials

  • Installation tips and tricks—how to decide which version, the 32-bit or the 64-bit, to install and the issues you may face if you install the 64-bit version
  • What you need to know about the Excel interface including working with the ribbon
  • How to customize the ribbon to increase your productivity and even create new tabs and hide the ones you never use
  • The Microsoft Office button is gone—how to use the new Microsoft Office Backstage view
  • Workbook and worksheet essentials—how to create, manage, save and rename workbooks and worksheets
  • How to increase your productivity with special keyboard shortcuts and mouse techniques
  • How to get started quickly with one of the many templates Excel has to offer
  • Uncover all the different Options settings and find out which ones you may want to change depending on how you use Excel

Formatting and styles—Getting the look you want

  • How to modify the format of numerical data in your worksheets
  • How to format large blocks of cells quickly and efficiently with the power of Format Painter
  • How to add, change, find or clear conditional formats
  • What icon sets are and how to use them to make your important data stand out
  • Quick cell formatting from predefined styles
  • How to easily select a range of cells and convert it into a great-looking table that stands out on your worksheet
  • Secrets of the Merge and Center button and how to use it to create professional-looking headings
  • How to use the Format option to modify cell sizes and visibility, and organize and protect your worksheets

Formulas and functions—The real power of Excel

  • Master the mysteries of relative and absolute cell references—“must-know” information for working with formulas
  • Discover the Function Library and how to add functions to your formulas and make sure you’re using the correct syntax
  • How to use the Insert Function dialog box to insert functions and to quickly get help on how the selected function works
  • How to use the Name Manager to name a data range and use it in your formulas to save time and effort
  • How to use the Error Checking feature to check for common errors in formulas
  • How to use the Watch Window to watch the values of selected cells as you change values on your worksheet
  • How to use the Evaluate Formula dialog box to evaluate each part of your complex formulas individually to locate and correct any errors
  • Understanding and using the Trace Precedents and Trace Dependents features

Objects, charts and Sparklines

  • How to quickly insert objects such as pictures, clip art, shapes and more with just a few clicks of the mouse
  • How to insert complex mathematical equations and symbols into your worksheets
  • How to use the new Screenshot feature to easily insert a screenshot of any open application
  • How to quickly select your data and insert a chart into your worksheet
  • Bar chart, pie chart, line chart—how to choose and use the right type of chart to get your point across
  • How to use the Chart Tools to create stunning charts that have that professional look
  • How to save your finished chart as a template that you can apply to future charts
  • Stock, Surface, Doughnut, Bubble and Radar—how using advanced chart types can capture your audience’s attention

Managing your data—Connections, sorting, filtering and data tools

  • How to create data connections to virtually any type of data, including simple text files, Web pages and other Microsoft Office applications
  • How to use the Sort feature to sort on not only values of cells but the color of the cells, color of the cell font and more
  • How to prevent bad data from being entered by using the Data Validation feature
  • How to automatically add subtotals to several rows of related data with just a couple of mouse clicks
  • Use the powerful filter features of Excel to view only the data you need
  • How to insert a Slicer to interactively filter data
  • How to easily separate the contents of one cell into multiple columns such as first and last names
  • How to dramatically speed up data input with the powerful AutoFill feature and increase the power of the AutoFill feature by using Custom Lists

Reviewing, sharing and printing

  • How to add comments to a worksheet
  • Keep track of the changes made to a spreadsheet by others so you can decide which to keep and which to discard
  • How to protect a workbook so that only those you choose can open it
  • The steps you’ll need to take in order to share your workbook with others
  • How to quickly check for issues such as compatibility with previous versions before you share your workbook
  • How to create a range of cells that other users can edit while the rest of the worksheet is locked
  • How to save time by creating a Custom view to select a print area you need to print on a regular basis
  • How to use the Print Titles feature to specify rows and columns to repeat on each printed page

 

More Seminar Information

SkillPath Seminars
Skillpath Seminars

Summary

This workshop will show you how to end your Excel frustrations for good by providing the “how-to’s” for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques.

Delivery Method

Seminar Seminar

Also Available As

On-Site Training On-Site Training

Who Should Attend

Excel® Users

 
Search similar training
Email this page
Print this document
 

Dates and Locations

Taunton, MA
7/22/2019 - 7/22/2019
Tuition: $149

Eugene, OR
7/22/2019 - 7/22/2019
Tuition: $149

Salem, OR
7/23/2019 - 7/23/2019
Tuition: $149

Portland, OR
7/24/2019 - 7/24/2019
Tuition: $149

Lansing, MI
8/2/2019 - 8/2/2019
Tuition: $149

see all dates/locations

 

Frequently Asked
Questions

Payment Options
Bill Me/Invoice
Credit Card

Register
Online
Fax Form

Availability
Select a date from the list at the bottom of the page for specific information about that class.

Other Information
Seminar

All Date/Location Information

Arkansas (Find training in Arkansas)
9/24/2019-9/24/2019 in Batesville, AR         Find a seminar in Batesville AR

Arizona (Find training in Arizona)
8/7/2019-8/7/2019 in Flagstaff, AZ         Find a seminar in Flagstaff AZ
8/8/2019-8/8/2019 in Tempe, AZ         Find a seminar in Tempe AZ
8/9/2019-8/9/2019 in Tucson, AZ         Find a seminar in Tucson AZ

California (Find training in California)
10/15/2019-10/15/2019 in Concord, CA         Find a seminar in Concord CA
9/3/2019-9/3/2019 in Oakland, CA         Find a seminar in Oakland CA
9/4/2019-9/4/2019 in San Jose, CA         Find a seminar in San Jose CA
9/6/2019-9/6/2019 in Ventura, CA         Find a seminar in Ventura CA

Colorado (Find training in Colorado)
11/7/2019-11/7/2019 in Boulder, CO         Find a seminar in Boulder CO
11/4/2019-11/4/2019 in Colorado Springs, CO         Find a seminar in Colorado Springs CO
11/6/2019-11/6/2019 in Denver, CO         Find a seminar in Denver CO
12/16/2019-12/16/2019 in Denver, CO         Find a seminar in Denver CO
11/8/2019-11/8/2019 in Ft Collins, CO         Find a seminar in Ft Collins CO
11/5/2019-11/5/2019 in Golden, CO         Find a seminar in Golden CO
8/28/2019-8/28/2019 in Greeley, CO         Find a seminar in Greeley CO

Florida (Find training in Florida)
12/2/2019-12/2/2019 in Lakeland, FL         Find a seminar in Lakeland FL
12/3/2019-12/3/2019 in Melbourne, FL         Find a seminar in Melbourne FL

Iowa (Find training in Iowa)
11/18/2019-11/18/2019 in Ft Dodge, IA         Find a seminar in Ft Dodge IA
11/19/2019-11/19/2019 in Waterloo, IA         Find a seminar in Waterloo IA

Illinois (Find training in Illinois)
10/4/2019-10/4/2019 in Oak Brook, IL         Find a seminar in Oak Brook IL

Indiana (Find training in Indiana)
10/3/2019-10/3/2019 in Ft Wayne, IN         Find a seminar in Ft Wayne IN

Kansas (Find training in Kansas)
10/15/2019-10/15/2019 in Mission, KS         Find a seminar in Mission KS

Kentucky (Find training in Kentucky)
9/30/2019-9/30/2019 in Louisville, KY         Find a seminar in Louisville KY

Massachusetts (Find training in Massachusetts)
7/22/2019-7/22/2019 in Taunton, MA         Find a seminar in Taunton MA

Maryland (Find training in Maryland)
8/29/2019-8/29/2019 in Annapolis, MD         Find a seminar in Annapolis MD
11/1/2019-11/1/2019 in Frederick, MD         Find a seminar in Frederick MD

Michigan (Find training in Michigan)
8/2/2019-8/2/2019 in Lansing, MI         Find a seminar in Lansing MI

Minnesota (Find training in Minnesota)
12/9/2019-12/9/2019 in Mankato, MN         Find a seminar in Mankato MN

New Jersey (Find training in New Jersey)
10/9/2019-10/9/2019 in Freehold, NJ         Find a seminar in Freehold NJ

Oregon (Find training in Oregon)
7/22/2019-7/22/2019 in Eugene, OR         Find a seminar in Eugene OR
7/24/2019-7/24/2019 in Portland, OR         Find a seminar in Portland OR
7/23/2019-7/23/2019 in Salem, OR         Find a seminar in Salem OR

Pennsylvania (Find training in Pennsylvania)
8/2/2019-8/2/2019 in Butler, PA         Find a seminar in Butler PA
8/27/2019-8/27/2019 in Reading, PA         Find a seminar in Reading PA
8/26/2019-8/26/2019 in Scranton, PA         Find a seminar in Scranton PA
8/28/2019-8/28/2019 in York, PA         Find a seminar in York PA

Texas (Find training in Texas)
11/8/2019-11/8/2019 in Austin, TX         Find a seminar in Austin TX

Virginia (Find training in Virginia)
10/31/2019-10/31/2019 in Richmond, VA         Find a seminar in Richmond VA
10/30/2019-10/30/2019 in Virginia Beach, VA         Find a seminar in Virginia Beach VA

Wisconsin (Find training in Wisconsin)
12/10/2019-12/10/2019 in La Crosse, WI         Find a seminar in La Crosse WI
12/11/2019-12/11/2019 in Madison, WI         Find a seminar in Madison WI

West Virginia (Find training in West Virginia)
11/25/2019-11/25/2019 in Morgantown, WV         Find a seminar in Morgantown WV
11/26/2019-11/26/2019 in Wheeling, WV         Find a seminar in Wheeling WV