Advanced Microsoft© Excel© Techniques Seminar training classes conferences & workshops presented by SkillPath 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 SkillPath Seminars training seminar

We are an authorized partner of SkillPath Seminars

 

Price protection. The price to attend Advanced Microsoft© Excel© Techniques 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 SkillPath 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© Techniques seminar by SkillPath Seminars.
Register online, by phone, or fax.
Who should attend Advanced Microsoft© Excel© Techniques
Anyone who wants to use Excel to its full potential.
Reviews
Write and read SkillPath Seminars reviews and reviews about the training seminar Advanced Microsoft© Excel© Techniques on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Advanced Microsoft© Excel© Techniques

 
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© Techniques  

 Email information about this seminar Advanced Microsoft© Excel© Techniques by SkillPath Seminars to yourself your manager or associates Email this event... View and register for other training seminars like Advanced Microsoft© Excel© Techniques by SkillPath Seminars on FindaSeminar.com Find similar training.. Find and register for other training seminars by SkillPath Seminars on FindaSeminar.com Other seminars from SkillPath Seminars

By:

training seminars by SkillPath Seminars SkillPath Seminars   

For:

Anyone who wants to use Excel to its full potential.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

You´ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. (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© Techniques training seminar Register by mail for Advanced Microsoft© Excel© Techniques training seminar Register by phone to attend Advanced Microsoft© Excel© Techniques training seminar

Print payment approval request form Advanced Microsoft© Excel© Techniques 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© Techniques seminar

 

 

Training Course Syllabus:


Advanced Microsoft© Excel© Techniques

You’ll learn:

  • Time-saving techniques that’ll allow you to get your work done faster with Excel
  • Adding and using the Analysis ToolPak to make complex data analysis a snap
  • How to create a PivotTable report to quickly analyze volumes of data, generate summary views, see comparisons and reveal patterns in your data
  • How to add power to your spreadsheets with Visual Basic® for Applications, including a quick way to learn VBA syntax
  • And much more!

You may use Excel daily, or maybe only casually, but one thing’s for sure—you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office “family” for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop. Enroll today!

Day One: 9:00 a.m. -  4:00 p.m.

Time-saving techniques

  • How to format large blocks of cells quickly and efficiently with the power of Format Painter
  • Make your titles and headings stand out by using the Merge and Center formatting feature
  • How to fill out an entire column of data using the new Flash Fill tool
  • Why and how to create relationships between tables
  • How to quickly create custom AutoFilters to view your data the way you want to and how to take advantage of the search filter
  • Simple techniques to connect to a variety of data sources, such as SQL Server, Windows Azure Marketplace and others and import data into Excel

Designing forms and formatting

  • How to create stunning 3D effects with your cells and implement artistic effects on images in your worksheets
  • Using templates to create your worksheet can have you finished and on to the next project in a fraction of the time
  • How to use Excel to quickly create professional looking forms in minutes (not hours!)
  • How to implement conditional formatting, take advantage of icon sets and improved data labels and a dozen other formatting tips and techniques for making your data stand out
  • How to add control items to your worksheets, including combo boxes, list boxes, option buttons and many others

Data analysis and formulas

  • How to take advantage of the Quick Analysis tool to get instant data analysis
  • Using the Goal Seek function to help determine how to get your desired result
  • How to utilize the new functions added to Excel
  • How slicers can now also filter data in Excel tables, query tables and other data tables in addition to PivotTables
  • How to use the Scenario tool to do a what-if analysis

Advanced charting and graphing functions

  • How to quickly create a basic chart with a single keystroke
  • Use pictures to create exciting charts that are even more descriptive than typical line and bar charts
  • How to insert a Sparkline into a cell to instantly reveal patterns in your data
  • The best way to visualize your data in a chart by using Recommended Charts
  • The changes to the Chart ribbon and how to create a combo chart

Day Two: 9:00 a.m. - 4:00 p.m.

Getting the most out of PivotTable and PivotChart reports

  • The in’s and out’s of Excel PivotTable and PivotChart reports, including how to create a stand alone PivotChart
  • How to quickly drill down, drill up and cross drill in your PivotTable without having to go back to your source data to identify specific information
  • Use the new Recommended PivotTables feature to have Excel recommend different ways to summarize your data
  • Create PivotTables based on multiple tables
  • How to change your PivotTable field settings to a variety of options such as average, minimum, maximum or even custom settings

Maximizing the power of Excel with VBA and macros

  • A simple tool for learning VBA syntax, including how to reference specific cells, a range of cells, worksheets and more
  • How to use loops to repeat commands multiple times
  • View and modify modules, forms and other worksheet code using the Project Explorer and Visual Basic Editor
  • How to write conditional If/Then statements in your code that can be used to execute other functions, control program flow, allow user input and perform many other functions
  • How to create and use your own custom functions

Excel and the Internet

  • How to get continuously updated data from a Web site into a worksheet
  • Creating a macro that will update a chart published to a Web page at regular intervals
  • How to embed worksheet data in a Web page
  • Save time with the Excel Web Data add in feature by using Web page data as a data source in your spreadsheet
  • How to utilize the new features of Excel to share files and work with other people

Validating and securing your data

  • How to lock values and formulas in your Excel worksheets
  • Track down mistakes in your worksheet using the Formula Auditing tools
  • How to use the Trust Center settings to manage Excel security
  • How to share your Excel workbook and not worry about someone making changes that’ll ruin your work
  • How to use Data Validation to make sure the data going into any cell meets the criteria you’ve specified

Seminar Time:

Seminar Check-In: 8:15AM Seminar Program: 9:00AM - 4:00PM Each Day

Seminar Summary:

You´ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. (see full course description)

print this agenda print agenda for the Advanced Microsoft© Excel© Techniques 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