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

  • Speaker:Dennis Taylor
  • Duration:75Min
  • Product Code:GRC-90450
  • NASBA CPE: 1.5
NASBA

NASBA CPE Credits: 1.5

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 on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org.

Live Session - How it works

  • Username and Password will be sent to you within 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be emailed to along with the login instructions or few hours before the meeting starts.
  • Login to the session by clicking on “Join the Meeting” in the login instructions and then dial the number to connect to the meeting audio or use your Computer to connect to audio. Please use the name and the email address you used at the time of registration to join the meeting.
  • Get answer to your queries through interactive Q&A sessions. The Q and A sessions are at the end of the meeting. The expert will complete his/ her presentation and then the phone lines will be open for the audience to discuss your questions.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve our Training programs.
  • Certificate of attendance is emailed to you within 6 working days from the date the webinar was completed. If you don’t receive an email within 6 days. Please email our support@grcts.com

Recorded Session - How it works

  • Login Information with Password to view the webinar will be emailed to you within 48 hours from the date the Live webinar was completed. The link to the recording is for a single person use only and it is valid for 6 months or the actual duration the recording was purchased.
  • Please click on the link to access the Recording and type in the password provided in the email.
  • Presentation and other handouts will be emailed to you in a pdf format.

Training CD - How it works

  • Free shipment within 2 working days, from the date the webinar was completed. The presentation and other handouts will be emailed to you in a pdf format if we are unable to attach them in the CD or USB.

(For more information 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.

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 we 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

Write a review

Please login or register to review

Available Options

Recording 6 Month Access: 2 Participants

$269

Recording: Unlimited Viewing Access for 6 Months

$239

CD-DVD: Shipped within 2 working days

$339

USB - Shipped within 2 working days

$369

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

$2,679

10 Member Group: 10 people can Attend the Live Online Meeting from any location globally

$4,569

Related Products

Project Management for Human Resources Professional- CPE Accredited (3 Hour Training)

Project Management for Human Resources Professional- CPE Accredited (3 Hour Training)

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: This webinar guides you through the process and provides you tips to improve and strengthen your project management skills. The purpose of this session is to provide you with the skills, knowledge, and tools to effectively and efficiently define, organize, plan, manage, and close h..

$359

Excel Tips, Tricks, and Shortcuts Work more efficiently (+)

Excel Tips, Tricks, and Shortcuts Work more efficiently (+)

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..

$169

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

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

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certification: NASBA CPE - 1.5Group Internet Based | 1.5 (1 CPE for 50 minutes) | Business Management & Organization - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Knowledge| Advanced Preparation: Must..

$229

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..

$269

Easy Planning and Prioritizing Using Microsoft Outlook Tasks and Calendar - NASBA HR CPE - 1.5

Easy Planning and Prioritizing Using Microsoft Outlook Tasks and Calendar - NASBA 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.  Description:  Do you face daily dilemmas trying to figure out where to start on your task list? Task lists can be overwhelming with a great range of items to complete. Some can wait but others are urgent and demand immed..

$229

Creating and Implementing Dynamic Excel Dashboards - NASBA Certification

Creating and Implementing Dynamic Excel Dashboards - NASBA Certification

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.Certification: NASBAGroup Internet Based | 1.5 (1 CPE for 50 minutes) | Accounting - 1.5CPE (1.5 CPE) | Finance- 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - Excel Knowledge | No advance preparation.Description: Excel ..

$189

Payroll Techniques and Analysis - HRCI CPE 1.5

Payroll Techniques and Analysis - HRCI 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. 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..

$259

Applying Macros in Excel Spreadsheet - NASBA CPE 1.5

Applying Macros in Excel Spreadsheet - 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. CertificationsNASBA CPE Certification - 1.5 CPEGroup Internet Based | 1.5 (1 CPE for 50 minutes) | Computer Software & App - 1.5CPE (1.5 CPE) | Specialized Knowledge - 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - None|..

$229

Excel Charts and Graphs - NASBA and SHRM 1.5

Excel Charts and Graphs - NASBA and SHRM 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 Training 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.  Certification SHRM PDCs - 1.5 GRCTS is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for [1.5] PDCs for the SHRM-CPSM or SHRM-SCPSM. For more in..

$189

Move From An Operational Manager to A Strategic Leader - HRCI and SHRM credits 1.5

Move From An Operational Manager to A Strategic Leader - HRCI and SHRM credits 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 Training 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. Certifications: SHRM PDCs - 1.5GRCTS is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for [1.5] PDCs for the SHRM-CPSM or SHRM-SCPSM. For more inform..

$259

Auditing Your Excel Spreadsheets - NASBA CPE 1.5 Hours

Auditing Your Excel Spreadsheets - NASBA CPE 1.5 Hours

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certification: NASBA CPE - 1.5Group Internet Based | 1.5  hours (1 CPE for 50 minutes) | Computer Software & Applications (1.5 CPE) | Intermediate | Prerequisites - Experience Working with Excel Spread..

$2659

Developing Effective Financial Statements - NASBA Certification

Developing Effective Financial Statements - NASBA Certification

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Use coupon code "GRCTS10" to avail a 10% Discount on your purchaseCertification: NASBA CPE - 1.5Group Internet Based | 1.5 NASBA Credits (1 CPE for 50 minutes) | Computer Software & Applications (1.5 CPE) | Inter..

$249

Project Management Best Practices: Completing Every Project On Time and On Budget

Project Management Best Practices: Completing Every Project On Time and On Budget

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. Background: Managing projects can be a big headache sometimes; well, our Webinar is the perfect prescription!  Our Webinar will provide the best practices of managing projects – you will receive tools, techniques and bes..

$425

Excel Functions - VLOOKUP, HLOOKUP, MATCH, and CHOOSE Lookup Functions

Excel Functions - VLOOKUP, HLOOKUP, MATCH, and CHOOSE Lookup Functions

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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.  Use coupon code "GRCTS10" to avail a 10% Discount on your purchase Topic Description:  Excel expert David Ringstrom, CPA, will equip you to implement Excel's lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOS..

$249

Excel Analyzing Data in QuickBooks/Excel Reports

Excel Analyzing Data in QuickBooks/Excel Reports

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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.  Topic Description:  In this valuable presentation, Excel and QuickBooks expert David Ringstrom, CPA, teaches you how to overcome the limitations of QuickBooks internal reports for faster data analysis in Excel. David sh..

$425

Project Management for Human Resources Professional- CPE Accredited (90 Minute Training)

Project Management for Human Resources Professional- CPE Accredited (90 Minute Training)

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. Use coupon code "GRCTS10" to get a 10% Discount on your purchase Description: This webinar on project management in human resources will focus on key project management skills for the HR professional. You will learn proven, successful techniques for detailed, systematic, team-invol..

$129

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

Excel PivotTables - Analyze lists in a flash with PivotTables - 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.  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 quic..

$189

Time and Task Management – Working Smarter Every Day - NASBA HR CPE - 1.5

Time and Task Management – Working Smarter Every Day - NASBA 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. Certifications:  NASBA : Group Internet Based | 1.5 (1 CPE for 50 minutes) | HR (1.5 CPE) | Intermediate | Prerequisites - None | No advance preparation USE COUPON "GRCTS10" TO AVAIL ..

$169