Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More Seminar training classes conferences & workshops presented by Fred Pryor Seminars register for training on FindaSeminar.com

Home

Add your seminars

Training Calendar Creator Seminar Venues Training Provider Directory
 

New Seminar Search:  

 
find similar training...
Search by state...
Email this event ...

Customer Support


Do you need help finding the right class, date, or location or other assistance?

Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request and receive a prompt reply.

We guarantee this Fred Pryor Seminars training seminar

We are an authorized partner of Fred Pryor Seminars

 

Price protection. The price to attend Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More is set by the training providerThere is no added charge for our services.

We honor most training provider coupons
*.   Call  a representative to see if your discount coupon applies.


Privacy. Your personal information won't be shared with anyone but the training provider Fred Pryor Seminars.


Security. When you register for this seminar on FindaSeminar.com your personal data and payment information is safely collected and processed using secure SSL encryption technology.

Flexibility. FindaSeminar.com offers you three ways to register for Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More seminar by Fred Pryor Seminars.
Register online, by phone, or fax.
Who should attend Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More
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.
Reviews
Write and read Fred Pryor Seminars reviews and reviews about the training seminar Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More

 
Find Training Near You
Use our clickable map to find training near you
Use Our Clickmap
 
Education and training domain names

Education and training news articles

hotel seminars meeting space directory
hotel meeting space training facilities restaurant and lodging

 

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

 Email information about this seminar Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More by Fred Pryor Seminars to yourself your manager or associates Email this event... View and register for other training seminars like Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More by Fred Pryor Seminars on FindaSeminar.com Find similar training.. Find and register for other training seminars by Fred Pryor Seminars on FindaSeminar.com Other seminars from Fred Pryor Seminars

By:

training seminars by Fred Pryor Seminars Fred Pryor Seminars   

For:

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.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

Understand and unleash the power of Excel’s most complex capabilities (see full course description)

 
 

 Seminar / Training class dates & locations

 
 SORT RESULTS BY:

 DATE

LOCATION

SELECTED VENUE DETAILS

Facility Name: 
Address:





Registration Information:

Event cost:  $
USD

class times and cancellation policy

 
 




 From 
 To 
 Click to register by Register by fax for Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More training seminar Register by mail for Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More training seminar Register by phone to attend Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More training seminar

Print payment approval request form Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More training seminar

Pre-Registration questions? Find answers in our registration FAQ or Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request

 
 
 

 

share this page 

print the agenda print agenda for the Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More seminar

 

 

Training Course Syllabus:


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

Understand and unleash the power of Excel’s most complex capabilities

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!

Your trainer is an accomplished Excel expert who will walk you through dozens of time-saving shortcuts, smart strategies and more with a helpful mix of computer-screen projections, demonstrations, instructor-led exercises and plenty of Q & A time. You'll get practical Excel help with your toughest questions and challenges, and come away ready and able to put your new skills to work the very next day.

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
 

*NOTE: This seminar is delivered via computer-less training to ensure you won't waste valuable time entering data, correcting mistakes and waiting for other seminar attendees to catch up. You'll receive a handy workbook guide that summarizes key tips for easy reference once you return to the office.

Continuing Education

This event is eligible for the following continuing education credits:

CEU: 0.6 credits

CPE: 6 credits

Seminar Hours:  Check-In 8:30AM  Seminar 9:00AM - 4:00PM

Seminar Summary:

Understand and unleash the power of Excel’s most complex capabilities (see full course description)

print this agenda print agenda for the Advanced Microsoft® Excel® - Macros, PivotTables, Charts and More training seminar

 view dates and locations for this seminar

 

 

     
 

 
     

 

  Also try the advanced seminar search tool

   FindaSeminar HomeComputer Training

unix training
training classes

 © 2002-2014 FindaSeminar.com™ All Rights Reserved.  Terms of Use |  Privacy Policy |  Training News Network

   

Custom Search