My Shopping Cart
 
There are no items in your shopping cart.


Practical Tips and Tricks for Excel Worksheets and Charts (IME150A)

Presented By : David Ringstrom , CPA
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, January 21, 2015
Event Description

Get your Hands on Various Tips and Tricks which will help you Work Easily on Excel Worksheets and Charts and Save Time.

In this webcast Excel expert David Ringstrom, CPA shares dozens of tricks he uses to work with Excel more effectively every day. Remember, either you work Excel, or it works you! David will teach from Excel 2010, but his materials include tips and techniques specific to Excel 2013, Excel 2010 and Excel 2007. Coverage of 2003 will be limited to questions posed by the audience during or after the presentation.

You will learn mouse clicks and keyboard shortcuts that transform how you work in Excel and will be able to avoid retyping text with techniques such as concatenation. Going further, you will also learn how to automatically back-up key Excel files.

Session Highlights:

  • Discover how to quickly access folders and workbooks, either from network or your personal computer
  • Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
  • Save time when saving workbooks as .XLS files by dispatching the Compatibility Checker
  • Work through large workbooks easily, taking help from a hidden menu, as well as keyboard shortcuts.
  • Know how to simplify repetitive tasks by creating your own keyboard shortcuts
  • Minimize repeat work by creating keyboard shortcuts for Excel's Freeze Panes feature.
  • Restore 'classic' Print Preview functionality to Excel 2007 and later.
  • Keep an eye on how much your text is being reduced as you try to squeeze more onto a page.
  • Wrangle long lists of data by filtering instead of sorting.
  • Create a report to track customer longevity in a way that shows first and last invoice dates by customer.
  • Use Table feature of Excel 2007 and later to create charts that expand or contract automatically as your source data changes
  • Learn how to create self-updating chart titles which are linked to formulas within a worksheet cell

Who Should Attend

Practitioners who may benefit from using Excel more effectively

About Our Speaker(s)

David Ringstrom, Excel ExpertDavid Ringstrom CPA
David is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Excel, and written dozens of freelance articles about spreadsheets. David\'s webinars receive rave reviews, and attendees particularly lik... More info

 
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Practical Tips and Tricks for Excel Worksheets and Charts
    Presenter(s): David Ringstrom , CPA

 
DMCA.com Protection Status