Excel Data Management Features Manage Data with Sorting, Filtering and other tools

  • Speaker:Dennis Taylor
  • Duration:75Min
  • Product Code:GRC-90305

$269

refer

Refer Friend's


Live Session - How it works

  • Username and Password will be sent to you 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be mailed to you.
  • Login to the session using the username and password provided to you.
  • Get answer to your queries through interactive Q&A sessions via chat.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve.
  • Get certification of attendance.

Recorded Session - How it works

  • Login Information with Password to view the webinar, 24 hours after the Live webinar (link valid for 6 months).
  • A link will be provided to you upon purchase of the recorded session.
  • Please click on the link to access the session.
  • Presentation handouts in pdf format will be mailed to you.
  • Get certification of attendance.

Training CD - How it works

  • Free shipment within 72 Hours, from the date of webinar completion.

(More about our products contact +1- 248-233-2049)

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.

NASBA

Group Internet Based | 1.5 (1CPE for 50 minutes) | Specialized Knowledge (1.5 CPE) | Intermediate | Prerequisites - Comfortable working with Excel; some knowledge of sort and filter is helpful, but not required | No advance preparation

Description:

You can do more with Microsoft Excel worksheets than just calculate data -- you can tackle powerful data management needs with ease too! With just a bit of know-how, you can take advantage of the power of Excel to validate data (including the creation of pick lists to ease data entry chores), sort data (based on content, color, or icon), insert automatic subtotals, filter the data to see just what you need to see, convert data to a table and then filter interactively with Slicers, restructure columnar data that has been improperly grouped, eliminate duplicate records in a flash, and use powerful expanded functions to analyze the data in any list, regardless of size.

Key Learning Objectives of your Topic:

  • Learn the fastest, most efficient ways to sort data; sort by content, by color, or based on the order of data in a custom list; sort in random order or by re-arranging columns left-to-right
  • Re-structure improperly grouped columnar data with Flash Fill or the Text to Columns feature
  • Master the myriad ways of filtering data to display just the data you need
  • Eliminate duplicate records from a large database
  • Insert a row of subtotals in a sorted list without tediously creating new rows and formulas
  • Create drop-down lists to accelerate data entry, with improved accuracy and consistency
  • Convert lists into tables – gain easier data-handling, filtering with Slicers, and enhanced visual features
  • Learn valuable functions that help you understand your data – COUNTIF, SUMIF, and more… 

Areas you will be touching during the Session:

  • Data Validation
  • Sorting
  • Filtering
  • Advanced Filter
  • Converting data to a Table
  • Using Slicers to accentuate fields currently being shown (and which ones are not)
  • Automatic insertion of Subtotals
  • Eliminating duplicate entries in a list
  • Use functions designed to work with list-like data

What industries will benefit from your training:
If you are familiar with many of Excel’s features, but have limited use with data management tools, you are a good candidate for this course. Also, those users familiar with sorting and filtering but new to using tables will also benefit from this session. These features are potentially valuable to nearly all Excel users.

Who will benefit from this topic:
Anyone needing to manage lists of data by using validation, sorting, filtering, using slicers, and other data management features will benefit from this presentation.

Instructor Profile:
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90’s, is the author/presenter of over 600 Excel webinars, and authored or co-authored six books on spreadsheet software. 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.

GRCTS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority o

Available Options

Recording: Access the training Recording for 6 months from any location

$269

CD: Shipped within 2 working days

$389

USB - Shipped within 2 working days

$409

5 Member Group: 5 can Attend Live Meeting Online from any location globally

$2,569

10 Member group: 10 can Attend Live Meeting Online from any location globally

$3,549

Related Products

Excel PivotTables - Analyze lists in a flash with PivotTables - NASBA CPE- 1.5

Excel PivotTables - Analyze lists in a flash with PivotTables - NASBA CPE- 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. Description:Although Excel has many tools, like sorting and filtering, to manage large lists of data, if you need to analyze all that data and do it fast, there’s no better feature than a PivotTable. You can quickly create a compact summary report (based on tons of data) without needing to write..

$279

Excel Tips, Tricks, and Shortcuts Work more efficiently - NASBA CPE - 1.5

Excel Tips, Tricks, and Shortcuts Work more efficiently - NASBA CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA: Group Internet Based | 1.5 (1 CPE for 50 minutes) | Specialized Knowledge - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Excel Knowledge| Advanced Preparation: Must have basic Excel Knowledge.Descrip..

$279

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA 1.5 CPE

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA 1.5 CPE

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications.NASBA CPE - 1.5Group Internet Based | 1.5 (1 CPE for 50 minutes) | Specialized Knowledge - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Knowledge| Advanced Preparation: Must have basic Knowledge.Topic Description: Don’t let email be the bane of your daily work existence. Optim..

$269

Dealing With Difficult People: The 5 Most Difficult Types of People And How To Effectively Approach Them - HRCI 1.5

Dealing With Difficult People: The 5 Most Difficult Types of People And How To Effectively Approach Them - HRCI 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. HRCI CPE - 1.5HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recer..

$269

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA CPE - 1.5 | Field - HRDescription:Outlook is a powerful productivity tool and can be treated as a programming tool. The savvy users of Outlook can program its features to be more productive – taking into account their job desc..

$179