Excel Tips, Tricks, And Shortcuts

Speaker: Dennis Taylor – Excel Trainer

Date: December 14th Wednesday

Time: 01:00 PM EST | 10:00 AM PST

Duration: 75 Minutes

Product Code: 300189

Level: Beginner

Key Take Away

This webinar will help you to understand how to re-arrange data (sort), see just what you want to see (filter), create quick summaries (subtotals), restructure fields containing too much data (the exciting new Flash Fill tool and the Text to Columns feature) and eliminate redundant records in Excel.

Overview

Most Excel users are under-utilizing the power of this vital software package – they could be saving minutes every day and hours every week if they learn some of the many tips presented in this fast-paced webinar.

Excel has a tremendous amount of capability and features and is filled with shortcuts and methods not always visible to the casual user. Whether it’s a keystroke shortcut or a hidden command sequence, such shortcuts can make you much more proficient and productive as you use Excel. When budgets are tight and you need to work more efficiently, it’s all the more important for you to use your existing software resourcefully.

Why Should You Attend

Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. It’s all the more important as data collection has become more automated and you’re getting swamped with tons of data.

If you are setting up new lists, you need to know the powerful validation tools that keep out bad data from the start and how to drastically reduce data entry with drop-down clickable lists.

Areas Covered In This Webinar

  • Master the keystroke shortcuts that will become indispensable to accelerate Excel usage
  • Navigate seamlessly through workbooks and work-sheets with keystroke and mouse shortcuts
  • Copy or move data with simple dragging instead of multi-step command sequences
  • Display/ hide all worksheet formulas instantly; select all formula cells with two mouse clicks
  • Use keystroke shortcuts for various number formats
  • Build lists of dates, times or values without using time-consuming commands
  • Create charts instantly and learn manipulation tips
  • Create formulas faster with entire column references

Learning Objectives

  • Get the productivity boost as you become a more proficient Excel user
  • Master over 100 tips to make you a PowerUser

Who Will Benefit

  • Banking
  • Financial Professionals
  • Sales and Marketing Personnel
  • Investments
  • Administrative Assistants
  • Accounts
  • Audit
  • Nearly all Excel users, except for those just getting started, are candidates for this webinar
  • Any Excel User who wants to accelerate his use of this software and become more productive by learning the numerous shortcuts available

Speakers Profile

Dennis Taylor has taught thousands of Excel seminars and classes since the early 90’s, is the author/presenter of over 500 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses both for online and DVD distribution.

Source Link: https://www.atozcompliance.com/trainings-webinar/banking-financial-services/accounting-taxation/excel-tips-tricks-and-shortcuts/dennis-taylor/300189

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s