Self-Paced
Online Course Description
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.
What
You Will Learn:
- 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
Key
Features:
- Mobile-friendly
- Audio-enabled
- Fully accessible
- Games & Flashcards
- Expert-supported
- Video content
Price: $79.00
For a course
preview and to register, click here!
|