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

  • Speaker:Dennis Taylor
  • Duration:90Min
  • Product Code:GRC-90382
  • NASBA CPE: 1.5

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. 

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.

Description:

Microsoft Excel has a tremendous amount of capability and features and is filled with shortcuts and methods not always visible to the casual user. Whether it’s a keystroke shortcut or a hidden command sequence, such shortcuts can make you much more proficient and productive as you use this powerful and popular software. Most users are under-utilizing Excel and could be saving minutes every day and hours every week if they learn some of the many tips presented in this fast-paced webinar. In these days of tight budgets and hiring freezes, its’ all the more important for you to use your existing software more efficiently. This webinar will give you the productivity boost you need as you become a more proficient Excel user.

 Objectives of Topic:

  • Master Navigation Techniques
  • Simplify Copy/Move/Paste actions
  • Write Formula more efficiently
  • Reduce the drudgery of Data Entry
  • Minimize Chart Creation and manipulation
  • Formatting and Command Shortcuts
  • Master over 100 tips to make you a Power User! 

Areas touching during the Session:

Topics include:

  • Write formulas more efficiently 
  • Navigate seamlessly through workbooks and worksheets with keystroke and mouse shortcuts
  • Copy or move data with simple dragging instead of multi-step command sequences
  • Display/hide all worksheet formulas instantly; select all formula cells with two mouse clicks 
  • Use keystroke shortcuts for a various number formats
  • Build lists of dates, times or values without using time-consuming commands
  • Create charts instantly and learn manipulation tips
  • Create formulas faster with entire column references

Who will benefit from this topic:

Nearly all Excel users, except for those just getting started, and in all industries, are candidates for this webinar.

  • HR
  • Auditing
  • Banking
  • Finance
  • Life Science 
  • Nearly everyone who wants to grow and develop their excel skills - People in all types of industries and designations. 

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.

Available Options

Recording: 6 Months Access to the Training which can be accessed from any location

$259

CD-DVD: Shipped within 2 working days

$359

USB - Shipped within 2 working days

$389

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

$2,849

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

$4,789

Recording Access to 10 Members: 10 Participants can access the training Recording for 6 months from any location

$829

Related Products

Financial Modeling with Excel Tools or Dashboard Reporting and Balanced Scorecards |  NASBA CPE - 1.5

Financial Modeling with Excel Tools or Dashboard Reporting and Balanced Scorecards | 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|..

$249

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

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

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

$189

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

Effective Manager's Communication Skills: Active Listening, Constructive Feedback, Conflict Resolution and Coaching Work For You and Your Team

Effective Manager's Communication Skills: Active Listening, Constructive Feedback, Conflict Resolution and Coaching Work For You and Your Team

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

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 preparationBackground:Background of the topic if any Take ..

$249

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

Steps to Critical Thinking in Workplace: Engage your Team - CPE Available

Steps to Critical Thinking in Workplace: Engage your Team - CPE Available

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. Why You Must Attend This Session:New research has discovered that college graduates do not possess the necessary Critical Thinking skills employers are searching for.  Pick up almost any trade journal, magazine or newspaper and..

$259

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

How to Implement Criminal Background Checks without Violating Current “Ban the Box” Regulations - HRCI CPE - 1.5

How to Implement Criminal Background Checks without Violating Current “Ban the Box” Regulations - 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..

$249

Enhancing Your Managerial Effectiveness: Managing People and Processes to Generate Better Performance and Results - HRCI and SHRM 1.5

Enhancing Your Managerial Effectiveness: Managing People and Processes to Generate Better Performance and Results - HRCI 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 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. CertificationsSHRM 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 information ab..

$249

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

Domestic Violence, Sexual Assault & Stalking Regulations! What Should Employers do to Ensure Compliance? HRCI and SHRM PDCs - 1.5

Domestic Violence, Sexual Assault & Stalking Regulations! What Should Employers do to Ensure Compliance? HRCI and SHRM PDCs - 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. CertificationsSHRM 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 information ab..

$2659

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. CertificationSHRM 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 information ab..

$249

Working with H1B Sponsored Employees? Are you Complying With New Immigration Regulations? - SHRM and HRCI - 1.5

Working with H1B Sponsored Employees? Are you Complying With New Immigration Regulations? - SHRM and 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 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. CertificationsSHRM 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 information a..

$259

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

Courageous Dialogue— Tools for Talking When the Stakes are High - NASBA Certificate

Courageous Dialogue— Tools for Talking When the Stakes are High - 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. NASBA CPE - 1.5Group Internet Based | 1.5 (1 CPE for 50 minutes) | Personal Development  (1.5 CPE) | Intermediate | Prerequisites - None | No advance preparationSHRM PDCs - 1.5GRCTS is recognized by SHRM to offer Professional ..

$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

HR Files Know-How: Keeping Your Employment Records (and You) Organized - HRCI & SHRM Certification Available

HR Files Know-How: Keeping Your Employment Records (and You) Organized - HRCI & SHRM Certification Available

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

The Power of the Written Word: Punctuation, Proofreading and Grammar Skills - SHRM Certification

The Power of the Written Word: Punctuation, Proofreading and Grammar Skills - SHRM 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. Certification: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 information a..

$249

New Transgender Protections Are in Place in Federal, State, and Local Regulatory Agencies! Time to Update Policies/Employee Handbooks or Risk Fines and Penalties!

New Transgender Protections Are in Place in Federal, State, and Local Regulatory Agencies! Time to Update Policies/Employee Handbooks or Risk Fines and Penalties!

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

$229

Managing People for the First Time: the “Not-So-Common” Common Sense Principles for Supervisors and Managers - SHRM Certification

Managing People for the First Time: the “Not-So-Common” Common Sense Principles for Supervisors and Managers - SHRM 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: SHRM PDCs - 1.5GRCTS is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is vali..

$249

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

$389

Stay Interviews: Engaging Talented Employees with Focus and Intention

Stay Interviews: Engaging Talented Employees with Focus and Intention

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.  Course Summary: In today’s dynamic job marketplace, employees have multiple options for where to work. As a result, employers need to understand not only how to recruit the best candidates, but also how to retain their bes..

$429

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 Certification:  NASBA CPE - 1.5 Group Internet Based | 1.5 NASBA Credits (1 CPE for 50 minutes) | Computer Software & Applications (..

$189