HRTrainingCenter.com provides Human Resource training on FMLA, COBRA, HIPAA, HRAs (Health Reimbursement Accounts), HSAs (Health Savings Accounts), FLSA, Payroll, Cafeteria Plans, and more through seminars, online training, webcasts, webinars, and audio conferences. Best sellers include FMLA seminars, COBRA seminars, online payroll training, retirement plan training, and HIPAA training.
Course/Product Description
Title:

Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More

SKU:SM-1003955
Format: In-Person Seminar
Find A Class Near You: View Dates And Locations For This Seminar
Description:

If you're comfortable building a worksheet, using cells, entering data and creating basic formulas this program will take you to the next level of Excel expertise. Instead of hovering at the "tip of the iceberg", you'll drill down through Excel's complex capabilities and discover how easily you can expand your knowledge base to become a more confident, capable user.

This advanced Excel course is jam-packed with skills, tools, ideas and strategies gathered from professional users, tech experts and Excel gurus who know this application inside and out. This is practical Excel training you can put to use immediately once you've returned to the office. You'll understand concepts you may have struggled with in the past … become familiar with a broad range of advanced Excel capabilities and functions … and see your productivity soar as you use Excel more effectively and efficiently every day!

Kick your skills up a notch in this one day advanced Excel training workshop and discover:

  • A more in-depth knowledge of Excel's ribbon, menus and functions, including how to add your own tabs and groups
  • Time-saving techniques to streamline data queries, data analysis and searches
  • Tips for creating charts, graphs and tables that will wow your audience
  • How to use PivotTable reports to filter and summarize your data and worksheets
  • Scripts to automate repetitive tasks using macros
  • A clear understanding of advanced filters so you extract only the information you need
  • Menu options that allow you to select filtering criteria from your data set with just a few simple clicks
  • The Analysis ToolPak add-in: how to fully utilize this resource for advanced data analysis
  • The most effective methods to share spreadsheets with collaborators and coworkers
  • And much more!
Seminar Overview

Master Advanced Macros
  • Use the Visual Basic® editor to modify and manage your macros
  • Learn to create customized macro toolbars featuring your most frequently used tools

Manage Your Data
  • Learn how to create data forms for viewing and entering information
  • Enter — or allow others to enter — data into a user-friendly form
  • Review individual records easily, or view only records that meet specific criteria
  • Discover the power of Backstage view

Filter, Query and Analyze Data
  • Learn tips, tools and tricks for getting the most out of AutoFilters, Custom AutoFilters and Advanced Filters
  • Find out how to search for spreadsheet data that fits within specific parameters
  • Discover menu options that allow you to select filtering criteria from your data set with just a few simple clicks
  • Specify a single criterion, or combine two or more to create a custom search of your data
  • Use AND/OR commands to extract data that meets your criteria in a whole new range
  • Create new data ranges on the fly to use with advanced filters so you can extract exactly the information you need
  • Add sparklines to show trends in a series of values, such as seasonal increases or decreases

Use Lookup and Database Functions

  • Add power and flexibility to your formulas by enabling Excel to search out data for you
  • Manage large data lists by performing calculations only on the data you specify
  • Use Excel to perform new lookups and dynamically update your calculation results
Put PivotTables to Work
  • Discover how PivotTables can help you get the most out of your data
  • Create PivotTables from single spreadsheets, external data sources or other PivotTables
  • Use AutoFormat to create your PivotTable quickly and easily
  • Learn how to modify or update a PivotTable
  • Group data in a PivotTable for better organization
  • Control how and where your PivotTable data is displayed
  • Display your data using a PivotChart®

Get to Know the Analysis Toolpak

  • Find out what tools are included in this valuable resource
  • Learn to use Excel's advanced data analysis tools to return a multitude of statistics about your data in just a few keystrokes
  • Use Excel's built-in utilities to analyze correlations in your data
Sharing Excel Across Workgroups
  • Use Excel's robust collaboration tools to control access to shared spreadsheets

  • Understand the different ways to share your spreadsheets with associates and coworkers
  • Comment on specific cells within a given sheet
  • Activate workbook sharing and distribute shared workbooks
  • Maintain control of versions of a shared workbook
  • Easily track and review changes made by multiple users
  • Seamlessly integrate Excel with other applications, the Internet and your organization's intranet
  • Create macros that work with the Web to automatically update your Web charts and graphs at regular intervals

Explore Custom Views, Formatting and Report Manager


  • Discover how to create different display and print settings for the same worksheet — or apply the settings to multiple worksheets
  • Manage saved custom views
  • Use custom views to change the look of your worksheets and workbooks
  • Create, display, print and delete custom views
  • Understand and use the Report Manager to print, edit and manage your reports
  • Expand your knowledge of charts and graphs to create eye-popping graphic images
  • Master formatting effects that make your pages look like you spent hours — when all it took was a few mouse clicks!
  • Apply different Data Bars, Color Scales and Icon Sets to your cell selections using conditional formatting

Licenses / Designations / Educational Credits:CEU
All US States: 0.6

CPE
All US States: 6
About The Provider: Fred Pryor Seminars and CareerTrack, divisions of PARK University Enterprises, Inc., create one of the most respected international providers of professional seminars.

Since pioneering the one-day seminar in 1970 as Fred Pryor Seminars, our organization has built a reputation for high-quality, convenient, and practical business-skills training around the world, in every industry and sector.

Today, with more than 8 million satisfied customers, we continue to pride ourselves in providing the superior training you've come to expect from Fred Pryor Seminars and CareerTrack. Our cutting-edge research and course development are designed to meet the adult learning needs of your employees and your organization.

Fred Pryor Seminars and CareerTrack are your number one choices for training because we offer:
  • In-depth experience in the training industry
  • Consistent and comprehensive course offerings
  • High-energy and content-rich presentations
  • Multiple training tools, including on-site training, on-line learning, seminars, and A/V products
  • 100% Satisfaction Guaranteed!
As we continue to grow, expand, and change to meet client and market needs, we always remember that every individual customer matters and that collectively, they are our most valuable assets. That's why our goal is the same today as it was 30 years ago — to provide the best choice in business skills training with maximum convenience to help you — our customer — achieve success!
Price: $149.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Seminar
Course TitleCity/StateDate
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreONTARIO, CA3/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreANAHEIM, CA3/28/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreHONOLULU, HI3/30/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreHILO, HI3/31/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreTULSA, OK4/3/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreOKLAHOMA CITY, OK4/4/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreDALLAS, TX4/5/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFORT WORTH, TX4/6/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreAMARILLO, TX4/7/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreREADING, PA4/10/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreKOKOMO, IN4/10/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreINDIANAPOLIS, IN4/11/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreKING OF PRUSSIA, PA4/11/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCHERRY HILL, NJ4/12/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreTERRE HAUTE, IN4/12/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreBLOOMINGTON, IN4/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePRINCETON, NJ4/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreROANOKE, VA4/18/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCHARLOTTESVILLE, VA4/19/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreRICHMOND, VA4/20/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreNORFOLK, VA4/21/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreATLANTIC CITY, NJ4/24/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFREDERICKSBURG, VA4/24/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreEVANSVILLE, IN4/25/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWASHINGTON, DC4/25/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreALLENTOWN, PA4/25/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreLOUISVILLE, KY4/26/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreHARRISBURG, PA4/26/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreANNAPOLIS, MD4/26/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreLANCASTER, PA4/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreLEXINGTON, KY4/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreBALTIMORE, MD4/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreDOVER, DE4/28/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFREDERICK, MD4/28/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreHICKORY, NC5/1/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCOLUMBIA, SC5/2/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFAYETTEVILLE, NC5/3/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGREENVILLE, NC5/15/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreRALEIGH, NC5/16/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCHARLOTTE, NC5/17/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGREENVILLE, SC5/18/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreASHEVILLE, NC5/19/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWINSTON-SALEM, NC5/22/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGREENSBORO, NC5/23/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWILMINGTON, NC5/24/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCHARLESTON, SC5/25/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreBLOOMINGTON, IL6/5/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCALGARY, AB6/5/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreST. LOUIS, MO6/6/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreEDMONTON, AB6/6/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGRANDE PRAIRIE, AB6/7/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCOLUMBIA, MO6/7/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreJEFFERSON CITY, MO6/8/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePRINCE GEORGE, BC6/9/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreHALIFAX, NS6/12/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreBARRIE, ON6/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGARDEN CITY, KS6/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCHARLOTTETOWN, PE6/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSALINA, KS6/14/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreNEWMARKET, ON6/14/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreMONCTON, NB6/14/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSAINT JOHN, NB6/15/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreOSHAWA, ON6/15/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWICHITA, KS6/15/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreTOPEKA, KS6/16/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreBURLINGTON, ON6/16/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSAULT STE MARIE, ON6/19/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWINNIPEG, MB6/21/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSASKATOON, SK6/22/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreREGINA, SK6/23/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreOTTAWA, ON6/26/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreOVERLAND PARK, KS6/26/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreTORONTO, ON6/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePITTSBURG, KS6/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSPRINGFIELD, MO6/28/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreKITCHENER, ON6/28/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreLONDON, ON6/29/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreDANBURY, CT7/10/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreNORTH HAVEN, CT7/11/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePROVIDENCE, RI7/12/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreTAUNTON, MA7/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePORTLAND, ME7/14/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCROMWELL, CT7/17/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSPRINGFIELD, MA7/18/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWORCESTER, MA7/19/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWOBURN, MA7/20/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreBURLINGTON, VT7/21/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePITTSBURGH, PA7/24/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreALTOONA, PA7/25/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSTATE COLLEGE, PA7/26/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCEDAR RAPIDS, IA8/14/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreDES MOINES, IA8/15/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreOMAHA, NE8/16/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreLINCOLN, NE8/17/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGRAND ISLAND, NE8/18/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePADUCAH, KY8/21/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreNASHVILLE, TN8/22/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCHATTANOOGA, TN8/23/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreKNOXVILLE, TN8/24/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreJOHNSON CITY, TN8/25/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFAYETTEVILLE, AR8/28/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreLITTLE ROCK, AR8/29/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreJONESBORO, AR8/30/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCAPE GIRARDEAU, MO8/31/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreORLANDO, FL9/11/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFLAGSTAFF, AZ9/12/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePRESCOTT, AZ9/13/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MorePORT ST. LUCIE, FL9/14/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreFORT LAUDERDALE, FL9/15/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreMCALLEN, TX9/18/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreCORPUS CHRISTI, TX9/19/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreOCALA, FL9/20/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreSAN ANTONIO, TX9/20/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreWEST PALM BEACH, FL9/22/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreGAINESVILLE, GA9/27/2017
Advanced Microsoft® Excel® - Macros, PivotTables, Charts and MoreAUSTIN, TX9/27/2017

A Post-Election Survival Guide For Employers
A Post-Election Survival Guide For Employers

Dress Code Policy Do′s and Don′ts
Dress Code Policy Do′s and Don′ts

Internal Investigations Certificate Program
Internal Investigations Certificate Program

Garnishments, Child Support Orders, And Other Levies
Garnishments, Child Support Orders, And Other Levies

Executive Taxation
Executive Taxation

Reasonable Or Unreasonable Accommodation? How To Identify Disabilities And Handle Employee Issues - Without Violating The ADA
Reasonable Or Unreasonable Accommodation? How To Identify Disabilities And Handle Employee Issues - Without Violating The ADA

Certificate Program In FMLA &ADA Compliance
Certificate Program In FMLA &ADA Compliance

Rules And Requirements For Employee Expense Reimbursements
Rules And Requirements For Employee Expense Reimbursements

Certificate Program For HR Generalists
Certificate Program For HR Generalists

How To Keep HR From Being The Employee Complaint Department
How To Keep HR From Being The Employee Complaint Department

Assertiveness Skills For HR Professionals
Assertiveness Skills For HR Professionals

HRCI / SHRM 60 Hour Re-Certification Training Suite
HRCI / SHRM 60 Hour Re-Certification Training Suite

IRS Rules For Travel Pay
IRS Rules For Travel Pay

How To Deal With Employees Who Are Chronically Late Or Absent
How To Deal With Employees Who Are Chronically Late Or Absent

Dealing with Difficult People
Dealing with Difficult People

9 Ways To Spot, Handle, and Reduce Workers′ Comp Fraud
9 Ways To Spot, Handle, and Reduce Workers′ Comp Fraud

Google+HRTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-1219 | support@HRTrainingCenter.com
Copyright HRTrainingCenter.com 2017 | Web Site Development by OTAU
Facebook