Advanced Excel - Beyond the Basics training seminars presented by Fred Pryor Seminars register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Advanced Excel - Beyond the Basics  

 Email information about this seminar Advanced Excel - Beyond the Basics by Fred Pryor Seminars to yourself your manager or associates Email this event... View and register for other training seminars like Advanced Excel - Beyond the Basics 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:

Microsoft Excel Spreadsheet Users who want to be POWER users!

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

You know the basics. Now become a Microsoft Excel Pro! (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

Microsoft+2003+Advanced+excel training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Advanced Excel - Beyond the Basics seminar

 

 

Training Course Syllabus:


Covers Excel 2003 and all previous versions

Shortcuts, new techniques, key codes — you thought Excel was amazing before. Now experience it on a whole new level.

"I didn't know I could do that!" — you'll say it often at Microsoft Excel: Beyond the Basics. One day never delivered so much practical, advanced Excel training. You'll improve your productivity tenfold. Complicated charts that once took hours to compile will now take only minutes to set up and assemble. You'll learn when it makes sense to use a macro, how to debug a macro, and how to create and manage a Pivot Chart. Key code shortcuts you learn will transform multistep processes into single, simple moves. Even the advanced linking and data exchange operations you once dreaded will become easier.

Our "hands-off" training method means you won't waste time entering data, correcting mistakes, or waiting for the entire group to catch up. Instead, you'll learn exactly how to do it from an expert; then, try it at your leisure, in the privacy of your own office.

Our advanced Excel training is just what you'll need to increase your productivity and take your current Excel skills to the next level! Save over 25% when you attend both Microsoft Excel Basics— A One-Day Seminar and Microsoft Excel: Beyond the Basics. Attend Both Days for just $128.00 (US Locations) 258.00 (Canada locations)

Advanced Excel Training — Seminar Overview

Microsoft Excel Setup and Editing Success

  • 7 Rules that make worksheet setup easy
  • How to conceal data in cells, columns, and rows without losing it
  • 3 steps to protect your data
  • 9 keyboard shortcuts that will cut hours from your work
  • How to add graphics — easy when you know how to customize your drawing tools
  • Tips on changing chart attributes without losing data
  • How to manipulate multiple ranges with Autofill
  • The overlooked problem-solver for naming ranges
  • The end of data entry drudgery — how to get the software to do it for you

Advanced Excel Formulas and Functions That Cut Work Down to Size

  • Tips for building complex formulas quickly and accurately
  • The amazing Function Palette — hundreds of functions at your fingertips
  • How to use absolute, mixed, and circular cells
  • Logic Functions — the If, And, and Or statements that make data more usable

Making the Most of Excel Macros

  • When to use an automated procedure or macro — and when not to
  • Tips for recording a complex macro and ensuring it runs easily
  • How to assign command buttons to macros
  • Techniques for debugging an Excel macro, as easy as 1, 2, 3
  • How to start — and use — the Microsoft Visual Basic Editor

Advanced Excel Data Exchange with Other Applications

  • Specific steps for exchanging Microsoft Excel data with Microsoft PowerPoint, Access, Word, and other platforms
  • How to save your Excel work in HTML

Demystifying Excel Tables, Databases, and Lists

  • How to sort to maximize the data's usability
  • Auditing: a visual map of your Excel formulas
  • How to build and manage an Advanced Excel Pivot Chart that's everything management wants
  • The best way to analyze equations with Scenario Manager
  • An advanced shortcut for calculating trends and projecting future ones

* NOTE: This is not a hands-on workshop. Instead, you'll learn via "computer-less" training that makes every moment count.

Attend Day 1 Microsoft Excel and pay just $49 for Advanced Excel class (99.00 for Canada locations)!

For Microsoft Excel 2007/2010 Advanced click here

Seminar Times:

Seminar Check-in 8:30 AM Seminar Program 9:00 AM-4:00 PM

Seating is Available

Seminar Summary:

You know the basics. Now become a Microsoft Excel Pro! (see full course description)

print this agenda print agenda for the Advanced Excel - Beyond the Basics training seminar

 view dates and locations for this seminar

 

 

 

Custom Search