Excel Tips & Tricks
Explore 25 Excel tips and tricks to improve productivity, data management, and advanced functions like VLOOKUP, HLOOKUP, and Find + Replace.
Classes Start Available Anytime
Course Overview
This course offers 25 essential Excel tips and tricks for both beginners and advanced users, focusing on time-saving techniques to enhance efficiency, productivity, and skills. Topics covered include data entry, organization, cleaning, sorting, filtering, style elements, and spreadsheet display. The course also explores key lookup and reference functions, such as VLOOKUP, HLOOKUP, and Find + Replace. To participate, you will need Microsoft Excel, with the course specifically using Excel 2019, which may differ from other versions.
Course Format
This 3 hour self-paced course offers a dynamic and engaging learning experience, combining interactive elements such as games, flashcards, video content, real-world case studies, and curated readings. Participants have the flexibility to progress at their own pace, while interactive games and quizzes reinforce key concepts and track progress. Students have 90 days of access per course, with progress tracked through interactive elements. Flashcards, expert-led videos, real-world case studies, and carefully curated readings deepen knowledge.
Price
$225Course Details
Units 0.3 CEUs / 3.0 PDUs
Location Online Courses
Course Type Self-Paced
What You’ll Learn
After successful completion of this course, you will be able to:
-
Use copy and paste shortcuts to streamline data management
-
Organize, filter, and sort data by text, color, and custom criteria
-
Modify worksheet view with tools like Freeze Panes, Hide/Unhide, Text-to-Column, and Zoom
-
Apply data organization tools and use lookup functions like VLOOKUP, HLOOKUP, and Find + Replace
-
Utilize Quick Analysis Tools for charts, graphs, calculations, and lock/unlock or track changes features
Your Instructor
IT Project Manager III, Standard Insurance Company
Calie Waterman is an experienced Project Manager with a demonstrated history of leading and delivering complex projects in both IT and business environments since early 2019. Her background includes managing large-scale software implementations, IT infrastructure upgrades, and business process improvements, showcasing her ability to manage diverse project environments while employing a mix of methodologies to ensure adaptive and efficient project execution. Her professional experience allows her to effectively integrate technology with business needs, fostering collaborative environments that drive projects to successful completion and achieve results.