Advanced Excel Training - 2 Day 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 Advanced Excel Training - 2 Day 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 Advanced Excel Training - 2 Day seminar by National Seminars Training Group.
Register online, by phone, or fax.
Who should attend Advanced Excel Training - 2 Day
Students, employees, managers, supervisors, business professionals
Reviews
Write and read National Seminars Training Group reviews and reviews about the training seminar Advanced Excel Training - 2 Day on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Advanced Excel Training - 2 Day

 
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 Excel Training - 2 Day  

 Email information about this seminar Advanced Excel Training - 2 Day by National Seminars Training Group to yourself your manager or associates Email this event... View and register for other training seminars like Advanced Excel Training - 2 Day 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:

Students, employees, managers, supervisors, business professionals

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

Go beyond the basics in this intensive two-day workshop and learn Excel's most advanced and most powerful features (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.

MS+microsoft+Advanced+Excel+Training+pivot+tables+macros 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 Training - 2 Day seminar

 

 

Training Course Syllabus:


Advanced Excel® Training - 2 Day - Microsoft Excel® / Computer Software Training Seminar

Program Description:

Don’t waste time searching for answers by trial and error.

Most people don’t need much convincing to use Excel, the world’s premier spreadsheet software. Its overwhelming popularity, especially in the business world, makes it the obvious choice for millions of number crunchers. But despite its wide use, few people know where to find Excel’s most impressive features, how to use them, or why they’d want to use them in the first place.

Advanced Excel® Training fills that void, explaining and demonstrating the most comprehensive tricks of the trade that are eye-opening, exciting, and seriously simple to learn.

You’ll get insider secrets on how Excel works and how you can put to use the hundreds of tools available to answer your real-world challenges you face every day. The Excel gurus leading this workshop will hone in on the hidden gems you can use to save time and money — and a lot of unnecessary stress.

Get ready to say “Wow, I didn’t know I could do THAT!!”

During our two decades of teaching hardworking people like you the ins and outs of Excel, we constantly ask them to describe the challenges and frustrations they face every day on the job. (You know, the things that make you want to pull your hair out and chuck your computer out the window?) We listened and did the research for you, and this intensive two-day workshop is the result.

You’ll master advanced Excel shortcuts that automate your tasks; increase the accuracy of your data; and allow you to manipulate, analyze, and extrapolate the information you and your company need to make better business decisions. You’ll learn advanced skills for:

  • Advanced filters and databases
  • Interactive macros
  • Creating custom charts
  • Custom macros
  • Logic functions IF, AND, OR, NOT
  • Advanced Filter and AutoFilter

Register Today and Get Ready for Some Power Shortcuts!

If you’re like a lot of Excel users, much of your experience was gained the old-fashioned way — through trial and error. While this approach has gotten you through so far, it’s also been a source of constant struggle. Wouldn’t it be nice to get the job done faster … with less frustration?

This workshop features dozens of powerful shortcuts, showing you the most efficient way of accomplishing dozens of tasks using Excel. You’ll learn to trade your time-consuming habits for razor-sharp Excel skills that’ll speed you through any task. But you can’t get them if you don’t register!

Free Reference Guide: You won’t leave this training empty-handed!

Not only will your seminar experience be relevant, practical, and productive, you’ll go back to the office with our Excel Desk Reference Workbook to give your training staying power. Thoroughly researched and developed by our Excel experts, this reference book will become your most useful tool for months afterward when you refer back to what you learned time and time again. We’ve left plenty of room for your personal notes so you can customize your workbook on the spot to help you overcome your most frustrating Excel problems.
 

Advanced Excel Training - 2 Day Agenda:

DAY 1

I. Manipulate and Manage Your Data to Provide Better Business Answers

 Advanced Sorting Multi-level sorting
  Sorting by color, font, or icon
  Establishing custom sort lists

 Advanced Filtering

  Create custom text filters with multiple criteria
  Filtering by color
  Advanced filter for complex OR criteria
  Advanced filter to create unique lists from repeating field data

 

Eliminating Duplicate Data

  Using the Remove Duplicate command
  Array formula to locate duplicate data

Database Analysis Tools

 Using SUMIF, COUNTIF, and other data analysis functions
 Using DSUM, DAVERAGE, and DMAX to analyze data

 

Data Validation

  Create drop-down lists
  Controlling number data
  Date/time controls
  Preventing duplicate entries

II. Creating Smarter Named Ranges

Creating range names

Creating names from selections

Modifying ranges

Apply Names command

Using range names in formulas

Using Name Manager to delete, modify, and edit range names

3-D name range

III. Advanced Text Manipulation Made Easy

Using Text to Columns

Find and Replace special characters and text

Converting dates with text functions

Converting text data to values/numbers

CONCATENATE and joining text

Text to Columns feature

Formatting special numbers and leading zeroes in zip, numerical, and text

Formatting text with PROPER, UPPER, LOWER, MID, LEFT, and RIGHT

Using Copy and Paste to transpose data

IV. Everything You Ever Wanted to Know About Tables (But Didn’t Know What to Ask!)

Converting a spreadsheet to a table

Formatting a table

Effect of inserting/deleting rows and columns in a table

Structured referencing

Working with table names

Using functions in tables

Using [#This Row] function

V. Advanced Formatting Techniques That Bring Your Data to Life

Conditional formatting

Custom conditional formatting

Adding pictures and shapes

Inserting SmartArt

 

Themes

  Create a theme
  Modify a theme

 

Templates

  Create a template
  Use a template

VI. Creating Perfect Charts for Explaining Your Data Visually

Format axes

  Adjust scale
  Data label

Format titles
  Format data points
  Combination charts
  Add graphics/pictures to a chart
  Add trendlines

DAY 2

I. Building More Intelligent and Flexible PivotTables

Creating a PivotTable

Modifying PivotTables

PivotTable calculations

Creating separate sheets for PivotTables

Using slicers in PivotTables

Summarizing pivot data

Sorting and filtering data

Conditional formatting in PivotTables

Creating PivotCharts

II. Manipulating and Managing Multiple Workbooks

Adding/deleting sheets

Copying sheets between workbooks

Linking workbooks

Applying changes to multiple sheets

Linking formulas between workbooks

Merging workbooks

Creating a workspace

III. Making Dashboards Your Most Powerful Visual and Analytical Tool

Creating a dashboard

Linking to data

Modifying a dashboard

Create hyperlinks

V. How to Make the Most Out of Your Macros

Define and record a macro

Run the macro

Assign a shortcut to the macro

Inspect the macro

Step through a macro

Import a file while running a macro

Fill in blank spaces on a worksheet

Record a relative movement

Record a macro that runs other macros

Edit with Visual Basic

Debug with Visual Basic

VI. Foolproof Auditing and Error-Checking Shortcuts

Error tracing

Creating/editing comments

Deleting comments

Protecting a worksheet

Protecting a workbook

 

Seminar Time:

Seminar Check-In:  8:30AM  Seminar Program:  9:00Am - 4:00PM (Both days)

CEU/CPE:

Credits are issued by Rockhurst University 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

Additional information for Accountants:
All program levels are basic and the delivery method is Group-Live. There are no prerequisites or advance preparation required. Rockhurst University Continuing Education Center, Inc. will offer continuing education credit that may be recognized by the customer’s professional board. Credits are issued in accordance to the guidelines set forth by NASBA. The recommended CPE awarded for each program are 7, the appropriate measure of credit is fifty (50) minute contact hours. Introductions, breaks, and viewing exhibits are not included in the calculation of contact hours.

Your Satisfaction Is GUARANTEED!

At National Seminars Training, 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.

Seminar Summary:

Go beyond the basics in this intensive two-day workshop and learn Excel's most advanced and most powerful features (see full course description)

print this agenda print agenda for the Advanced Excel Training - 2 Day 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