Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Top 15 Excel Tips and Tricks to Save Time and Speed Up Your Work - 2024

Simon Sez IT via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Master 15 essential Excel productivity features in this comprehensive video tutorial spanning 79 minutes. Learn time-saving techniques starting with basic functions like AutoSum and Flash Fill, then progress to data management tools including Data Validation and efficient empty row deletion. Discover how to enhance spreadsheet functionality with checkboxes for cell highlighting, data splitting capabilities, and text file importing. Dive into advanced data manipulation using the FILTER function, multiple criteria lookups, and HLOOKUP operations. Explore the distinctions between Unique and Distinct functions, create dynamic PivotTables, and implement interactive elements like search bars and spin buttons. Conclude by learning how to leverage ChatGPT for creating powerful Excel macros and formulas. Each topic includes detailed timestamps for easy navigation, allowing learners to focus on specific skills or follow the complete progression of techniques.

Syllabus

- How to Use Autosum in Excel to Quickly Sum Data
- How to Flash Fill in Microsoft Excel
- How to Use Data Validation in Excel
- Best and Easiest Ways to Delete Empty Rows in Excel
- How to Highlight Cells or Rows with a Checkbox in Excel
- How to Split Data into Columns in Excel
- How to Import Data into Excel from a Text File
- How to Use the FILTER function in Excel
- How to do Lookups with Multiple Criteria in Excel
- How to Use HLOOKUP in Excel
- Unique vs Distinct in Excel
- How to Create a PivotTable in Excel
- How to Insert a Search Bar in Excel
- How to Add Spin Buttons in Excel
- How to Use ChatGPT with Excel for Macros & Formulas

Taught by

Simon Sez IT

Reviews

Start your review of Top 15 Excel Tips and Tricks to Save Time and Speed Up Your Work - 2024

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.