Program Finder
Continuing Education
Self-Paced
Paid

Excel Tips & Tricks

Explore 25 Excel tips and tricks to improve productivity, data management, and advanced functions like VLOOKUP, HLOOKUP, and Find + Replace.

Program Finder
Continuing & Professional Education
Office Technology
Excel Tips & Tricks

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

This course is part of the Office Technology program.

Price

$225

Course Details

Units 0.3 CEUs / 3.0 PDUs

Location Online Courses

Course Type Self-Paced

Next Available Course

Classes Start Available Anytime

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

Other Courses in this Program

Explore other courses in this program to gain comprehensive knowledge and earn your certificate

View Program Details
Continuing Ed
Self-Paced
Paid

Office Technology

Excel Advanced Skills

Enhance basic Excel skills by mastering advanced techniques such as conditional formatting, data validation, and pivot tables for data analysis.

Details
Continuing Ed
Self-Paced
Paid

Office Technology

Excel Basics

Learn essential Excel skills for organizing, analyzing data, and making better business decisions.

Details
Continuing Ed
Self-Paced
Paid

Office Technology

Microsoft Word Basics

Learn essential Microsoft Word skills, including writing, proofing ,and finalizing, while exploring its interface and design elements.

Details
Continuing Ed
Self-Paced
Paid

Office Technology

PowerPoint for Business

Discover how to design and deliver effective PowerPoint presentations, including mapping, research integration, templates, and visuals tips.

Details
Continuing Ed
Self-Paced
Paid

Office Technology

Visual PowerPoint

Explore basic design principles for creating engaging PowerPoint presentations, focusing on image selection, layout, data presentation, and color/font choices.

Details

Your Instructor

Calie Waterman
Calie
Waterman

IT Project Manager III, Standard Insurance Company

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