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-844-384-4744
Pre Recorded Webinar
60 minutes
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 | Microsoft Excel Courses  SpeakerDavid Ringstrom CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but shou... More info

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

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team