Show findcourses.com as: Mobile
Training overview
Professional Course
E-learning
3 hours
From 79 USD
Start dates
Online
79 USD
Start anytime

Course description

Excel Tips & Tricks

This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace.

Training content

  • Employ copy and paste shortcuts
  • Arrange, filter, and sort data by text, color, and by custom criterions
  • Modify the worksheet view with various display tools, such as Freeze Panes, Hide/Unhide, Text-To Column, and Zoom In/Out
  • Understand and apply data organization tools and functions
  • Retrieve data using VLOOKUP, HLOOKUP, and Find + Replace
  • Apply patterns, gradients, cell borders, and other style elements to data
  • Experiment with the Quick Analysis Tools to create charts, graphs, and calculations
  • Make use of the lock/unlock and track changes features

Course delivery details

Course Access Time: 90 days

Certification / Credits

Credits: 3 CEUs / 3 SHRMs

About PME

Project Management Experts, LLC

Project Management Experts (PME) is just that, a consortium of project management experts with at least 20 years of experience who have re-directed their careers to improving the project management competency of our clients. Our training classes focus on building...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Excel Tips & Tricks.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Project Management Experts, LLC

18373 Fairway Oaks Square
18373 Leesburg Virginia

 Show phone number

Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote