Taming Unwieldy Lists of Data in Excel Webinar training seminars presented by Online Compliance Panel register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Taming Unwieldy Lists of Data in Excel Webinar  

 Email information about this seminar Taming Unwieldy Lists of Data in Excel Webinar by Online Compliance Panel to yourself your manager or associates Email this event... View and register for other training seminars like Taming Unwieldy Lists of Data in Excel Webinar by Online Compliance Panel on FindaSeminar.com Find similar training.. Find and register for other training seminars by Online Compliance Panel on FindaSeminar.com Other seminars from Online Compliance Panel

By:

Online Compliance Panel   

For:

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

Learn how to tame long data in Microsoft Excel, avoid retyping data or cumbersome formulas by way of Excels Text to Columns feature, and simplify repetitive tasks, more. (see full course description)

 

 Seminar / Training class dates & locations

 
 SORT RESULTS BY:

 DATE

LOCATION

SELECTED VENUE DETAILS

Facility Name: 
Address:





Registration Information:

Event cost:  $
USD

class times and cancellation policy

 
 




 From 
 To 
 Click to register by Register by fax for Taming Unwieldy Lists of Data in Excel Webinar training seminar Register by mail for Taming Unwieldy Lists of Data in Excel Webinar training seminar Register by phone to attend Taming Unwieldy Lists of Data in Excel Webinar training seminar

Print payment approval request form Taming Unwieldy Lists of Data in Excel Webinar training seminar

Pre-Registration questions? Find answers in our registration FAQ or Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request

 
 

 

share this page 

print the agenda print agenda for the Taming Unwieldy Lists of Data in Excel Webinar seminar

 

 

Training Course Syllabus:


Taming Unwieldy Lists of Data in Excel Webinar


Description:

Many users are unaware of the many data visualization and manipulation tools available in Microsoft Excel. In this informative session, Excel expert David Ringstrom, CPA, demonstrates various ways you can streamline your filtering tasks. Little-known filtering shortcuts, such Custom Views and the hidden AutoFilter command, are covered. David also discusses the Conditional Formatting feature and reveals new features in Excel 2013 that enable you to manage cumbersome lists of data quickly and easily.


Why Should you Attend

Learn powerful Excel techniques to quickly tame large sets of data.


Objectives of the Presentation:


  • Wrangle long lists of data by filtering instead of sorting

  • Avoid retyping data or cumbersome formulas by way of Excel´s Text to Columns feature

  • Simplify repetitive tasks by creating keyboard shortcuts

  • Use Custom Views to quickly apply different filter settings with a couple of mouse clicks

  • Understand how the Table feature allows you to transform filtering tasks

  • Learn which features, such as Custom Views, that can´t be used when one or more tables exist in a workbook

  • Transform text by way of Excel´s UPPER, LOWER, PROPER, and TRIM formulas

  • Use the CLEAN and TRIM formulas or the CODE function to eliminate non-printing characters, such as tabs, carriage returns, and extra spaces, from your data

  • Identify duplicates in a list, color-code data, and apply icons using the conditional formatting feature


Seminar Summary:

Learn how to tame long data in Microsoft Excel, avoid retyping data or cumbersome formulas by way of Excels Text to Columns feature, and simplify repetitive tasks, more. (see full course description)

print this agenda print agenda for the Taming Unwieldy Lists of Data in Excel Webinar training seminar

 view dates and locations for this seminar

 

 

 

Custom Search