Master many skills that expert Excel users possess

The Excel spreadsheet can be an intimidating sight for many of today’s professionals. In most jobs, it is required, and often expected, that you already know how to use the tool. For those who
possess the proper skill set, Excel skills can boost your career and open new doors. But first you have to learn it.

There are many tools and options in Excel and spending too much time trying to figure out one or the other kills productivity. However, if you know the most commonly used tools, such as formulas,
pivot tables, custom formatting etc. you can limit the overwhelming options in Excel and focus on the areas that most directly impact your job.

The following program will guide you through the top 20 Excel areas used in the workplace.. Each module is complete with an expert-guided, video tutorial, quizzes, and handouts. Complete the program,
earn your certificate and advance your career!

Excel Foundations: Gain Instant Access & Conquer the Fear of Excel
http://www.mydesktoptrainingcenter.com/4AA/0/?U=1_S13QY_75K34
On-Demand Training Session - Gain Instant Access within 1 Hour of Purchasing!

Learn On-Demand and at your own pace with the following modules:

Module 1 - The Spreadsheet Grid
Introduction to the spreadsheet grid & naming
Adjusting rows and columns
Tips, tricks & techniques of cell formatting

Module 2 - The Ribbon
Full navigation of the top menu, the Ribbon, in Excel
Where to find and use all tools in the Ribbon
Achieve full knowledge of location of features

Module 3 - The Home Ribbon
Detailed navigation of Home Ribbon with tutorial
Advanced cell formatting tips & tricks
Achieve mastery over all tools in Home Ribbon

Module 4 - Sort & Filter
Sorting techniques to customize data
Filtering tips to organize data how you want it
Advanced filtering techniques to gain actionable insights from data

Module 5 - Insert Ribbon
Keys to creating Tables, Pivot Tables & more!
Tips on adding graphs and sparklines
Achieve knowledge of where to insert items for reports

Module 6 - Page Layout
Keys to customizing how you view Excel
Techniques for setting your Excel print area
Data mapping on the Excel spreadsheet

Module 7 - Basic Formulas & Calculations
Discover common formulas in Excel and how to use them
Keys to testing formulas for accuracy
Learn about relative and absolute cell referencing

Module 8 - Sum Up
Finding the sum for a dataset
Different ways to sum up with conditional formatting
Using relative and absolute referencing in summing up

Module 9 - User Preferences
Discover how to customize Excel to your needs
Toolbar navigation of all customizable features
How to save for all Excel vs. individual workbooks

Module 10 - The Fill Handle
Discover the time-saving magic of the fill handles
Reduce repetitive entries to mere seconds
Create sequence data with ease

Module 11 - Stored Values vs. Display Values
Discover the difference between what you see and what Excel processes
Keys to testing display values against what is stored
Troubleshooting techniques for when you expect display to be different

Module 12 - Freeze or Lock Columns and Rows
Dig deeper into making Excel presentable
Keys to keep title headings viewable when entering long strings of data
Get more comfortable customizing your spreadsheet

Module 13 - IF Function
How to create specified conditions in your calculations
Real-world application: Using IF function to find important info
Formula shortcuts to make IF functions easy-to-use

Module 14 - Intro to Charts
Basic of creating & customizing charts
How to ensure your chart displays the data you want how you want
Making your charts look good: Advanced display techniques

Module 15 - Intro to Conditional Formatting
What is conditional formatting and what it's used for
Setting the criteria for your conditions and ensure it formats correctly
Achieve deeper knowledge of how conditional formatting will help you

Module 16 - Data Validation
What to do when you get an error in your formula
How to make sure your calculations are correct
Troubleshooting when things go wrong

Module 17 - Intro to Tables and Pivot
Dig deeper on creating and customizing tables
Discover real-world application of tables & pivot tables
Produce reports that wow and stun

Module 18 - Vlookup
Discover the secrets behind one of Excel's most challenging features
What is Vlookup and how to use it: Save yourself time and effort
Real-world Vlookup usage

Module 19 - The Many Uses of Excel
Discover how you can use Excel to save time and effort
Overview of all built-in templates and how to use them
Prepare for using Excel in the workplace

Module 20 - Bringing it All Together
Summary and review of all previous modules
Create a cohesive understanding of how Excel truly works
Take the first steps to becoming a great Excel user for life

Presenter:

Jerry O'Donnell has been teaching Microsoft Excel before the phrase Microsoft Office was coined. He has taught Introduction, Intermediate, and Advanced courses as well as programming with Excel.

On top of that, he has been in the role of spread sheet troubleshooter on more than one occasion.
Enjoying the environment of Excel, he has published tips and tricks as well as assist others in doing the same, and even has written courseware on the subject for different institutions.

Excel Foundations: Gain Instant Access & Conquer the Fear of Excel
On-Demand Training Session - Gain Instant Access within 1 Hour of Purchasing!

Begin your path to conquering the fear of Excel today!
http://www.mydesktoptrainingcenter.com/4AA/0/?U=1_S13QY_75K34
1-800-964-6033

Sincerely,
Desktop Training Academy
384 Technology Drive
Malvern, PA 19355

P.S. If not satisfied, a full refund is possible 7 days from completing the final exam.

If you do not wish to receive further notices about this program or future programs, please unsubscribe:
http://www.mydesktoptrainingcenter.com/4AA/optout/?U=1_S13QY_75K34