Discover How You Can Use Excel for Better Reporting & Presentations - Live Training on 7/12

Dear ,

Excel skills increase your value to your company and your earning potential. In this instructor-led training session with labs, you will discover how to create amazing looking professional reports built upon well-organized data:

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Tuesday, July 12, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4P2/0/?U=1_JQCF_R72UR

In addition to charts, Excel has a wealth of visual tools and effects that let you present information with greater clarity, making your worksheets come alive. In this 90-minute hands-on training, discover those techniques that you can use to impress your clients and colleagues, save time and make more informed decisions. Join Excel expert Dennis Taylor in this instructor-led, live training to learn:

• Conditional Formatting: Highlight data with color bars, icons, & more
• Convert data to tables to simplify list organization & set up dynamic charts
• Dynamic charts: Converting data to tables to simplify list organization
• Create interactive worksheets & forms with check boxes, spin buttons & more
• Smart Arts for organization charts, process flow diagrams, Venn diagrams
• Make quick adjustments to your workbooks for consistent colors & fonts

The DTA Difference: Also get these additional training tools for greater retention:

• 15 minutes of assisted exercises to boost your performance right away
• 30 minutes of interaction & live Q&A session!
• Graded final exam to test your skills!

Our Expert Presenter:

Microsoft Excel expert Dennis Taylor is recognized nationally as an author, computer trainer and facilitator.

• Mr. Taylor is author of "Teach Yourself Microsoft Excel 2000," co-author of six books on spreadsheet software, and Author/Presenter of over 50 Excel Training CD courses.
• Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 25 years.
• He has over 25 years of training and consulting experience and has taught over 250 Excel seminars, hundreds of webinars, and over 3,000 classes.

Register now for this exciting event by clicking the following links or calling:
1-800-964-6033

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Tuesday, July 12, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4P2/0/?U=1_JQCF_R72UR

We hope you'll join us.

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

P.S. If not satisfied, a full refund will be given from now until 7 days after the event.

If you do not wish to receive further notices about this conference or future conferences, please click here:
http://www.events.DesktopTrainingAcademy.com/4P2/optout/?U=1_JQCF_R72UR

If you prefer to register over the phone, please reference your priority code:
1_JQCF_R72UR

Excel Foundations: Gain Instant Access & Conquer the Fear of Excel - On-Demand Training

Dear ,

Being proficient in Excel can boost your career, but how do you get there? This self-paced training consists of 20 modules covering the most essential topics in Excel to give you the knowledge and skill base to become great in Excel:

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_4Q3Y_AEAQM

Each Module below varies between 10-20 minutes:
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:
hhttp://www.events.DesktopTrainingAcademy.com/4AA/0/?U=1_4Q3Y_AEAQM

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_4Q3Y_AEAQM

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_4Q3Y_AEAQM

Contact ID#: /CONFIRMATION#/

Your 2016 CMO Social Media Landscape Cheat Sheet

Hello,

I hope this finds you well.

As a CMO, did you ever wonder how Periscope or Snapchat impact your brand awareness? Or how LinkedIn and Facebook impact your SEO? Or how Pinterest and Instagram impact customer communication? We've done the legwork and put together a one-page infographic that answers all those questions at a glance. Hopefully, this will be a useful tool for you and your marketing team to develop and nurture successful campaigns in the future.

View 2016 CMO Social Media Landscape

Talk soon,

Dave Burnett | AOK Marketing Group | Email |

AOK Marketing, 350 5th Ave, Suite 7412, New York, NY, 10118, US If you do not want to receive emails from AOK Marketing you may unsubscribe at any time.

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro - 7/12 Live Online Training

Dear ,

Excel skills increase your value to your company and your earning potential. In this instructor-led training session with labs, you will discover how to create amazing looking professional reports built upon well-organized data:

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Tuesday, July 12, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4P2/0/?U=1_KQ7P_475RS

In addition to charts, Excel has a wealth of visual tools and effects that let you present information with greater clarity, making your worksheets come alive. In this 90-minute hands-on training, discover those techniques that you can use to impress your clients and colleagues, save time and make more informed decisions. Join Excel expert Dennis Taylor in this instructor-led, live training to learn:

• Conditional Formatting: Highlight data with color bars, icons, & more
• Convert data to tables to simplify list organization & set up dynamic charts
• Dynamic charts: Converting data to tables to simplify list organization
• Create interactive worksheets & forms with check boxes, spin buttons & more
• Smart Arts for organization charts, process flow diagrams, Venn diagrams
• Make quick adjustments to your workbooks for consistent colors & fonts

The DTA Difference: Also get these additional training tools for greater retention:

• 15 minutes of assisted exercises to boost your performance right away
• 30 minutes of interaction & live Q&A session!
• Graded final exam to test your skills!

Our Expert Presenter:

Microsoft Excel expert Dennis Taylor is recognized nationally as an author, computer trainer and facilitator.

• Mr. Taylor is author of "Teach Yourself Microsoft Excel 2000," co-author of six books on spreadsheet software, and Author/Presenter of over 50 Excel Training CD courses.
• Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 25 years.
• He has over 25 years of training and consulting experience and has taught over 250 Excel seminars, hundreds of webinars, and over 3,000 classes.

Register now for this exciting event by clicking the following links or calling:
1-800-964-6033

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Tuesday, July 12, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4P2/0/?U=1_KQ7P_475RS

We hope you'll join us.

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

P.S. If not satisfied, a full refund will be given from now until 7 days after the event.

If you do not wish to receive further notices about this conference or future conferences, please click here:
http://www.events.DesktopTrainingAcademy.com/4P2/optout/?U=1_KQ7P_475RS

If you prefer to register over the phone, please reference your priority code:
1_KQ7P_475RS

Your Free Excel Pivot Tables Step-by-Step Guide

This guide will give you step-by-step guidance on how to create Excel Pivot Tables. Complete with easy-to-follow instructions in a "cheatsheet" format, this guide is your perfect tool to understand pivot tables and be able to quickly create them! Get the eBook Safe Unsubscribe Excel Training | 384 Technology Drive | Malvern, PA 19355

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro - 7/12 Live Online Training

Dear ,

Excel skills increase your value to your company and your earning potential. In this instructor-led training session with labs, you will discover how to create amazing looking professional reports built upon well-organized data:

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Tuesday, July 12, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4P2/0/?U=1_8Q2Z_476AQ

In addition to charts, Excel has a wealth of visual tools and effects that let you present information with greater clarity, making your worksheets come alive. In this 90-minute hands-on training, discover those techniques that you can use to impress your clients and colleagues, save time and make more informed decisions. Join Excel expert Dennis Taylor in this instructor-led, live training to learn:

• Conditional Formatting: Highlight data with color bars, icons, & more
• Convert data to tables to simplify list organization & set up dynamic charts
• Dynamic charts: Converting data to tables to simplify list organization
• Create interactive worksheets & forms with check boxes, spin buttons & more
• Smart Arts for organization charts, process flow diagrams, Venn diagrams
• Make quick adjustments to your workbooks for consistent colors & fonts

The DTA Difference: Also get these additional training tools for greater retention:

• 15 minutes of assisted exercises to boost your performance right away
• 30 minutes of interaction & live Q&A session!
• Graded final exam to test your skills!

Our Expert Presenter:

Microsoft Excel expert Dennis Taylor is recognized nationally as an author, computer trainer and facilitator.

• Mr. Taylor is author of "Teach Yourself Microsoft Excel 2000," co-author of six books on spreadsheet software, and Author/Presenter of over 50 Excel Training CD courses.
• Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 25 years.
• He has over 25 years of training and consulting experience and has taught over 250 Excel seminars, hundreds of webinars, and over 3,000 classes.

Register now for this exciting event by clicking the following links or calling:
1-800-964-6033

Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Tuesday, July 12, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4P2/0/?U=1_8Q2Z_476AQ

We hope you'll join us.

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

P.S. If not satisfied, a full refund will be given from now until 7 days after the event.

If you do not wish to receive further notices about this conference or future conferences, please click here:
http://www.events.DesktopTrainingAcademy.com/4P2/optout/?U=1_8Q2Z_476AQ

If you prefer to register over the phone, please reference your priority code:
1_8Q2Z_476AQ

Your Free eBook: 7 Time-Saving Excel Shortcuts for Beginners

Discover the Excel time-saving shortcuts for beginners that will improve your workflow and simplify your life! Get the eBook Safe Unsubscribe Excel Training | 384 Technology Drive | Malvern, PA 19355

Excel & Microsoft Office: Using Programs Together for Better Reporting - Last Chance! - 6/17 Live Online Training

Dear ,

Don't miss out on your last chance to register! Using Excel for reporting, sharing data and making key business decisions requires knowing how to bring Excel data into other MS Office programs. Join us for:

Excel & Microsoft Office: Using Programs Together for Better Reporting
Friday, June 17, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4JN/0/?U=1_UPVM_7ELVQ

Using the built-in, cross-program functionality of the Microsoft Office suite will save you countless hours and improve work quality. In this 90-minute, interactive training webinar, MS Office guru Mitzi Katz will show you how to get Excel, Word, PowerPoint, Outlook and OneNote to work together seamlessly. Save time and create more professional spreadsheets, documents, presentations and emails. Join us to discover:

• Creating auto mail merge with Word & Excel to pull into Outlook
• How to import & export data between Excel and Word
• Charts & tables from Excel and Word to PowerPoint
• Hyperlinking from one application to another for quick access
• One-Note to everything: Keys to storing all Office data

The DTA Difference: Also get these additional training tools for greater retention:

• 15 minutes of assisted exercises to boost your performance right away
• 30 minutes of interaction & live Q&A session!
• Graded final exam to test your skills!

Our Expert Presenter:

Mitzi Gibson Katz has trained thousands of end users and developed curriculum for over twenty-five years.

• As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more.
• After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market. She made the change in careers from public school education to private computer training and has been teaching students how to use software applications ever since.
• Mitzi helps students understand Excel by her passion: "It's the people part of the business that keeps me involved.

Register now for this exciting event by clicking the following links or calling:
1-800-964-6033

Excel & Microsoft Office: Using Programs Together for Better Reporting
Friday, June 17, 2016 1:00-2:30 PM ET
http://www.events.DesktopTrainingAcademy.com/4JN/0/?U=1_UPVM_7ELVQ

We hope you'll join us.

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

P.S. If not satisfied, a full refund will be given from now until 7 days after the event.

If you do not wish to receive further notices about this conference or future conferences, please click here:
http://www.events.DesktopTrainingAcademy.com/4JN/optout/?U=1_UPVM_7ELVQ

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 you prefer to register over the phone, please reference your priority code:
1_UPVM_7ELVQ

Get Your Free eBook: 5 Things You Need to Know Before Creating Pivot Tables

Discover how Pivot Tables will simplify your life Get the eBook Safe Unsubscribe Excel Training | 384 Technology Drive | Malvern, PA 19355