Dear ,
Using Excel in the workplace remains a source of frustration for many users. But Excel mastery can accelerate your career. If you want to go from fearing Excel to being your office's Excel superstar, look no further:
Excel Foundations: Gain Instant Access & Conquer the Fear of Excel
On-Demand Training Session - Gain Instant Access within 1 Hour of Purchasing!
http://www.events.DesktopTrainingAcademy.com/4AA/0/?U=1_SJ1C_J2BXL
Program Highlights
Module 1 - The Spreadsheet Grid
Module 2 - The Ribbon
Module 3 - The Home Ribbon
Module 4 - Sort & Filter
Module 5 - Insert Ribbon
Module 6 - Page Layout
Module 7 - Basic Formulas & Calculations
Module 8 - Sum Up
Module 9 - User Preferences
Module 10 - The Fill Handle
Module 11 - Stored Values vs. Display Values
Module 12 - Freeze or Lock Columns and Rows
Module 13 - IF Function
Module 14 - Intro to Charts
Module 15 - Intro to Conditional Formatting
Module 16 - Data Validation
Module 17 - Intro to Tables and Pivot Tables
Module 18 - Vlookup
Module 19 - The Many Uses of Excel
Module 20 - Bringing it All Together
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.
* Excel Foundations: Gain Instant Access & Conquer the Fear of Excel
* On-Demand Training Session - Gain Instant Access within 1 Hour of Purchasing!
Register today to begin your path to conquering the fear of Excel by clicking the following link or calling 1-800-964-6033:
http://www.events.DesktopTrainingAcademy.com/4AA/0/?U=1_SJ1C_J2BXL
We hope you'll join us.
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 click here:
http://www.events.DesktopTrainingAcademy.com/4AA/optout/?U=1_SJ1C_J2BXL
Please do not reply directly to this e-mail, as we are unable to process it. We sent this using a "send only" address.
If registering by phone, please refer to your priority
code:
1_SJ1C_J2BXL
Contact ID#: /CONFIRMATION#/
Using Excel in the workplace remains a source of frustration for many users. But Excel mastery can accelerate your career. If you want to go from fearing Excel to being your office's Excel superstar, look no further:
Excel Foundations: Gain Instant Access & Conquer the Fear of Excel
On-Demand Training Session - Gain Instant Access within 1 Hour of Purchasing!
http://www.events.DesktopTrainingAcademy.com/4AA/0/?U=1_SJ1C_J2BXL
Program Highlights
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 Tables
- 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!
Register today to begin your path to conquering the fear of Excel by clicking the following link or calling 1-800-964-6033:
http://www.events.DesktopTrainingAcademy.com/4AA/0/?U=1_SJ1C_J2BXL
We hope you'll join us.
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 click here:
http://www.events.DesktopTrainingAcademy.com/4AA/optout/?U=1_SJ1C_J2BXL
Please do not reply directly to this e-mail, as we are unable to process it. We sent this using a "send only" address.
If registering by phone, please refer to your priority
code:
1_SJ1C_J2BXL
Contact ID#: /CONFIRMATION#/
