Seminar Advanced Microsoft® Excel® Techniques Seminar

Presented by SkillPath Seminars

Skillpath Seminars

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

Learn ways to make your job easier and increase the sophistication of your data reporting and analyzing.

Course Description


You’ll learn:

  • Time-saving techniques that’ll allow you to get your work done faster with Excel
  • Adding and using the Analysis ToolPak to make complex data analysis a snap
  • How to create a PivotTable report to quickly analyze volumes of data, generate summary views, see comparisons and reveal patterns in your data
  • How to add power to your spreadsheets with Visual Basic® for Applications, including a quick way to learn VBA syntax
  • And much more!

You may use Excel daily, or maybe only casually, but one thing’s for sure—you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office “family” for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop. Enroll today!

Day One: 9:00 a.m. – 4:00 p.m.

Time-saving techniques

  • How to format large blocks of cells quickly and efficiently with the power of Format Painter
  • Make your titles and headings stand out by using the Merge and Center formatting feature
  • How to fill out an entire column of data using the new Flash Fill tool
  • Why and how to create relationships between tables
  • How to quickly create custom AutoFilters to view your data the way you want to and how to take advantage of the search filter
  • Simple techniques to connect to a variety of data sources, such as SQL Server®, Windows Azure™ Marketplace and others and import data into Excel

Designing forms and formatting

  • How to create stunning 3-D effects with your cells and implement artistic effects on images in your worksheets
  • Using templates to create your worksheet can have you finished and on to the next project in a fraction of the time
  • How to use Excel to quickly create professional-looking forms in minutes (not hours!)
  • How to implement conditional formatting, take advantage of icon sets and improved data labels and a dozen other formatting tips and techniques for making your data stand out
  • How to add control items to your worksheets, including combo boxes, list boxes, option buttons and many others

Data analysis and formulas

  • How to take advantage of the Quick Analysis tool to get instant data analysis
  • Using the Goal Seek function to help determine how to get your desired result
  • How to utilize the new functions added to Excel
  • How slicers can now also filter data in Excel tables, query tables and other data tables in addition to PivotTables
  • How to use the Scenario tool to do a what-if analysis

Advanced charting and graphing functions

  • How to quickly create a basic chart with a single keystroke
  • Use pictures to create exciting charts that are even more descriptive than typical line and bar charts
  • How to insert a Sparkline into a cell to instantly reveal patterns in your data
  • The best way to visualize your data in a chart by using Recommended Charts
  • The changes to the Chart ribbon and how to create a combo chart

Day Two: 9:00 a.m. – 4:00 p.m.

Getting the most out of PivotTable and PivotChart reports

  • The in’s and out’s of Excel PivotTable and PivotChart reports, including how to create a stand-alone PivotChart
  • How to quickly drill down, drill up and cross drill in your PivotTable without having to go back to your source data to identify specific information
  • Use the new Recommended PivotTables feature to have Excel recommend different ways to summarize your data
  • Create PivotTables based on multiple tables
  • How to change your PivotTable field settings to a variety of options such as average, minimum, maximum or even custom settings

Maximizing the power of Excel with VBA and macros

  • A simple tool for learning VBA syntax, including how to reference specific cells, a range of cells, worksheets and more
  • How to use loops to repeat commands multiple times
  • View and modify modules, forms and other worksheet code using the Project Explorer and Visual Basic Editor
  • How to write conditional If/Then statements in your code that can be used to execute other functions, control program flow, allow user input and perform many other functions
  • How to create and use your own custom functions

Excel and the Internet

  • How to get continuously updated data from a Web site into a worksheet
  • Creating a macro that will update a chart published to a Web page at regular intervals
  • How to embed worksheet data in a Web page
  • Save time with the Excel Web Data add-in feature by using Web page data as a data source in your spreadsheet
  • How to utilize the new features of Excel to share files and work with other people

Validating and securing your data

  • How to lock values and formulas in your Excel worksheets
  • Track down mistakes in your worksheet using the Formula Auditing tools
  • How to use the Trust Center settings to manage Excel security
  • How to share your Excel workbook and not worry about someone making changes that’ll ruin your work
  • How to use Data Validation to make sure the data going into any cell meets the criteria you’ve specified

 

More Seminar Information

SkillPath Seminars
Skillpath Seminars

Summary

Learn ways to make your job easier and increase the sophistication of your data reporting and analyzing.

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

Lafayette, IN
7/29/2019 - 7/30/2019
Tuition: $399

New York City, NY
7/29/2019 - 7/30/2019
Tuition: $399

Baltimore, MD
7/31/2019 - 8/1/2019
Tuition: $399

Farmington Hills, MI
7/31/2019 - 8/1/2019
Tuition: $399

Spencer, IA
8/6/2019 - 8/7/2019
Tuition: $399

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

Alabama (Find training in Alabama)
11/12/2019-11/13/2019 in Birmingham, AL         Find a seminar in Birmingham AL
11/14/2019-11/15/2019 in Huntsville, AL         Find a seminar in Huntsville AL

Arkansas (Find training in Arkansas)
10/29/2019-10/30/2019 in Ft Smith, AR         Find a seminar in Ft Smith AR

California (Find training in California)
11/20/2019-11/21/2019 in Anaheim, CA         Find a seminar in Anaheim CA
11/12/2019-11/13/2019 in Concord, CA         Find a seminar in Concord CA
12/16/2019-12/17/2019 in Irvine, CA         Find a seminar in Irvine CA
11/18/2019-11/19/2019 in Pasadena, CA         Find a seminar in Pasadena CA
11/14/2019-11/15/2019 in Sacramento, CA         Find a seminar in Sacramento CA
10/16/2019-10/17/2019 in San Francisco, CA         Find a seminar in San Francisco CA
11/25/2019-11/26/2019 in San Jose, CA         Find a seminar in San Jose CA

Colorado (Find training in Colorado)
12/17/2019-12/18/2019 in Colorado Springs, CO         Find a seminar in Colorado Springs CO
8/26/2019-8/27/2019 in Denver, CO         Find a seminar in Denver CO
9/16/2019-9/17/2019 in Denver, CO         Find a seminar in Denver CO

Connecticut (Find training in Connecticut)
9/19/2019-9/20/2019 in North Haven, CT         Find a seminar in North Haven CT
10/10/2019-10/11/2019 in Waterbury, CT         Find a seminar in Waterbury CT

Georgia (Find training in Georgia)
8/22/2019-8/23/2019 in Atlanta, GA         Find a seminar in Atlanta GA
12/9/2019-12/10/2019 in Atlanta, GA         Find a seminar in Atlanta GA

Iowa (Find training in Iowa)
8/8/2019-8/9/2019 in Des Moines, IA         Find a seminar in Des Moines IA
8/6/2019-8/7/2019 in Spencer, IA         Find a seminar in Spencer IA

Illinois (Find training in Illinois)
11/21/2019-11/22/2019 in Oak Brook, IL         Find a seminar in Oak Brook IL
12/12/2019-12/13/2019 in Oakbrook Terrace, IL         Find a seminar in Oakbrook Terrace IL

Indiana (Find training in Indiana)
7/29/2019-7/30/2019 in Lafayette, IN         Find a seminar in Lafayette IN

Kansas (Find training in Kansas)
12/2/2019-12/3/2019 in Mission, KS         Find a seminar in Mission KS

Massachusetts (Find training in Massachusetts)
10/15/2019-10/16/2019 in Danvers, MA         Find a seminar in Danvers MA
10/17/2019-10/18/2019 in Leominster, MA         Find a seminar in Leominster MA
9/17/2019-9/18/2019 in Taunton, MA         Find a seminar in Taunton MA

Maryland (Find training in Maryland)
11/6/2019-11/7/2019 in Annapolis, MD         Find a seminar in Annapolis MD
7/31/2019-8/1/2019 in Baltimore, MD         Find a seminar in Baltimore MD
12/10/2019-12/11/2019 in College Park, MD         Find a seminar in College Park MD
11/4/2019-11/5/2019 in Frederick, MD         Find a seminar in Frederick MD

Maine (Find training in Maine)
8/21/2019-8/22/2019 in Portland, ME         Find a seminar in Portland ME

Michigan (Find training in Michigan)
7/31/2019-8/1/2019 in Farmington Hills, MI         Find a seminar in Farmington Hills MI
11/21/2019-11/22/2019 in Lansing, MI         Find a seminar in Lansing MI
9/3/2019-9/4/2019 in Troy, MI         Find a seminar in Troy MI

Minnesota (Find training in Minnesota)
9/12/2019-9/13/2019 in Bloomington, MN         Find a seminar in Bloomington MN
10/17/2019-10/18/2019 in Bloomington, MN         Find a seminar in Bloomington MN

Missouri (Find training in Missouri)
12/4/2019-12/5/2019 in St Louis, MO         Find a seminar in St Louis MO

North Carolina (Find training in North Carolina)
9/26/2019-9/27/2019 in Charlotte, NC         Find a seminar in Charlotte NC
9/24/2019-9/25/2019 in Kinston, NC         Find a seminar in Kinston NC

New Hampshire (Find training in New Hampshire)
8/19/2019-8/20/2019 in Manchester, NH         Find a seminar in Manchester NH

New Jersey (Find training in New Jersey)
8/12/2019-8/13/2019 in Cherry Hill, NJ         Find a seminar in Cherry Hill NJ
11/25/2019-11/26/2019 in Princeton, NJ         Find a seminar in Princeton NJ
8/14/2019-8/15/2019 in Saddle Brook, NJ         Find a seminar in Saddle Brook NJ

New Mexico (Find training in New Mexico)
11/14/2019-11/15/2019 in Alamogordo, NM         Find a seminar in Alamogordo NM
11/4/2019-11/5/2019 in Albuquerque, NM         Find a seminar in Albuquerque NM
11/12/2019-11/13/2019 in Carlsbad, NM         Find a seminar in Carlsbad NM
11/6/2019-11/7/2019 in Farmington, NM         Find a seminar in Farmington NM

New York (Find training in New York)
7/29/2019-7/30/2019 in New York City, NY         Find a seminar in New York City NY
9/9/2019-9/10/2019 in New York City, NY         Find a seminar in New York City NY

Ohio (Find training in Ohio)
10/1/2019-10/2/2019 in Cincinnati, OH         Find a seminar in Cincinnati OH
9/5/2019-9/6/2019 in Youngstown, OH         Find a seminar in Youngstown OH

Pennsylvania (Find training in Pennsylvania)
9/11/2019-9/12/2019 in Lancaster, PA         Find a seminar in Lancaster PA

Texas (Find training in Texas)
11/6/2019-11/7/2019 in Dallas, TX         Find a seminar in Dallas TX
12/4/2019-12/5/2019 in Dallas, TX         Find a seminar in Dallas TX
11/19/2019-11/20/2019 in San Antonio, TX         Find a seminar in San Antonio TX

Utah (Find training in Utah)
9/18/2019-9/19/2019 in Salt Lake City, UT         Find a seminar in Salt Lake City UT

Virginia (Find training in Virginia)
12/12/2019-12/13/2019 in Arlington, VA         Find a seminar in Arlington VA