Microsoft® Excel Become a Power User Seminar training classes conferences & workshops presented by National Seminars Training Group 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 National Seminars Training Group training seminar

We are an authorized partner of National Seminars Training Group

 

Price protection. The price to attend Microsoft® Excel Become a Power User 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 National Seminars Training Group.


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 Microsoft® Excel Become a Power User seminar by National Seminars Training Group.
Register online, by phone, or fax.
Who should attend Microsoft® Excel Become a Power User
Intermediate and advanced users who know the basics but want to learn how to make the most of Excel's features and functions
Reviews
Write and read National Seminars Training Group reviews and reviews about the training seminar Microsoft® Excel Become a Power User on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Microsoft® Excel Become a Power User

 
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

 

Microsoft® Excel Become a Power User  

 Email information about this seminar Microsoft® Excel Become a Power User by National Seminars Training Group to yourself your manager or associates Email this event... View and register for other training seminars like Microsoft® Excel Become a Power User by National Seminars Training Group on FindaSeminar.com Find similar training.. Find and register for other training seminars by National Seminars Training Group on FindaSeminar.com Other seminars from National Seminars Training Group

By:

training seminars by National Seminars Training Group National Seminars Training Group   

For:

Intermediate and advanced users who know the basics but want to learn how to make the most of Excel's features and functions

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

A skill-boosting one-day workshop designed specifically for those who've mastered Excel's fundamentals and are ready to get the tools required to become a  (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 Microsoft® Excel Become a Power User training seminar Register by mail for Microsoft® Excel Become a Power User training seminar Register by phone to attend Microsoft® Excel Become a Power User training seminar

Print payment approval request form Microsoft® Excel Become a Power User 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 Microsoft® Excel Become a Power User seminar

 

 

Training Course Syllabus:


Microsoft® Excel Power User  - Computer Software Office Training Seminar

This program is for Windows and Macintosh users and will cover all versions of Excel.

Program Description:

This skill-boosting one-day workshop is designed specifically for anyone who has mastered Excel’s fundamentals and is ready to get the tools, tips, techniques and shortcuts required to become a power user. Your expert instructor will use our exclusive hands-off training approach that features state-of-the-art projection equipment. This method guarantees that you’ll learn — and retain — a maximum amount of information in a minimum amount of time!

You’ll discover how to use macros to save tons of time and reduce errors, how to create eye-catching charts and graphs that bring your numbers to life, how to make more professional-looking spreadsheets, how to automate repetitive tasks, and how to work faster and more efficiently with "insider" shortcuts.

You’ll also learn “how-to’s” for analyzing data and power tips for printing your work perfectly every time. Attend this intensive workshop and you’ll create better worksheets faster than ever before. Guaranteed!
 

Who Should Attend:

  • Intermediate users who know the basics but want to learn how to make the most of Excel's features and functions
  • Self-taught users who want to push their skills to the next level
  • Advanced users who are eager to learn additional shortcuts and tips that will boost their speed and productivity in Excel
Microsoft® Excel Power User Workshop Agenda:

The Key to Spreadsheet Success: Getting Off to a Good Start

  • How to swiftly navigate Excel menus like a pro
  • Identify the toolbar commands you use most often ... and hide the rest
  • Keyboard shortcuts that reduce the mileage you put on your mouse and save tons of time
  • Don't repeat yourself ... learn the quick steps to saving a document as a template
  • Managing files when you've got tons to keep track of
  • Data safeguards: How to protect your data in case disaster strikes

Formulas and Functions

  • Using the VLOOKUP and HLOOKUP functions
  • The no-fail method of backing yourself out of mistakes
  • How to calculate percentages, averages, and more
  • How to spot potential formula goofs
  • When and how to use the "fill series" command
  • Using logical and IF functions
  • Using split and freeze panes

Lighten Your Load With Multiple Worksheet Links

  • Why an automatic update of linked worksheets makes your job easier
  • Create a linking formula with our step-by-step guidelines
  • Save valuable time by moving rapidly among multiple worksheets
  • Reduce chances for errors by linking instead of re-inputting data

The Path to Print Perfection

  • The most common Excel printing goofs and how to avoid them
  • How to add footers, headers and page numbers
  • How to create recurring titles without re-keying them on every worksheet
  • Is your page breaking right? We'll show you how to guarantee it does ... every time!
  • The easy way to print worksheet selections — and get what you ask for

High-Impact Spreadsheets, Charts and Graphs

  • Let Excel show you a variety of effective chart formats
  • When and how to use borders, shading, bold, and underline
  • Fonts and colors: More is not necessarily better
  • Impress others with charts that look like they took hours to create — when, in fact, you created them in minutes!
  • Add free-form narrative and graphics to your worksheets to facilitate understanding
  • How to change the plot direction on a chart
  • Changing the data source on a chart
  • Using and disabling the time-scale axis

Creating Custom Toolbars, Menus and Dialog Boxes

  • Redundant tasks are history! Simply replace your duplicated efforts with a single menu or toolbar command
  • Define which tools you use most often and customize your toolbar in 4 quick and easy steps
  • How to record a macro in your customized toolbox
  • Simplify data entry by limiting menu and dialog box choices

Analyzing Data and Database How-to's

  • How to perform a what-if analysis using the Scenario Manager
  • Understanding and using one- and two-variable data tables
  • Using Solver to solve problems by working backward
  • How the Auditing Toolbar helps you examine the association between cells and formulas in a worksheet
  • Fundamentals of creating Excel databases
  • How to turn any list into a useable database
  • Tracing cells that cause errors
  • Creating a Pivot Table to summarize large amounts of data quickly

SPECIAL SECTION: Making Macro Miracles Happen — It's Easy!

  • Why use a macro? 2 powerful reasons why you'll leave this workshop a macro user from now on
  • Record a simple macro in 5 simple steps
  • Automate your worksheets and kick into the "instant reply mode"
  • How to avoid input errors using macros

SEMINAR TIME:

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

Your Satisfaction Is GUARANTEED!

At National Seminars Group, our #1 goal is to give you the tools you need to succeed. That’s why every seminar, conference and training resource we offer is 100% guaranteed. Every time.

Credits:

Our training seminars offer Continuing Education Credits (based on contact hours) upon completion. Credits are issued by The Continuing Education Center, Inc. according to the guidelines set forth by IACET. Please note that Continuing Education Credit approval is at the discretion of your licensing board; not all seminar topics are approved by all boards. Contact your licensing board or agency for specific information relating to your profession

Cancellation Details: If circumstances arise that require you to cancel your enrollment in Microsoft® Excel - Become a Power User, you may substitute another person in your place or receive a credit memo for a future seminar of equal value. Or, you may receive a refund, minus a $10 enrollment processing charge, provided you notify us at least five days before the training. At that time, any additional online training materials included in your registration will be deactivated.

Seminar Summary:

A skill-boosting one-day workshop designed specifically for those who've mastered Excel's fundamentals and are ready to get the tools required to become a  (see full course description)

print this agenda print agenda for the Microsoft® Excel Become a Power User 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