Excel Pro Hacks - 101 Tips to Boost Your Productivity

Name: Excel Pro Hacks - 101 Tips to Boost Your Productivity
Rating: 4.9 (7 reviews)

101 time-saving Excel tips for formulas, PivotTables, charts, data and more - go from good to expert fast

Created byLisa Newton

Last updated 6/2026

English

What you'll learn

Apply 101 time-saving tips across data, formulas, charts, PivotTables and printing
Build and analyse data with COUNTIF, VLOOKUP, conditional formulas and PivotTables
Create professional charts and visualisations including histograms, trendlines and PivotCharts
Master paste special, format painter and copy techniques that most Excel users never learn
Customise Excel with macros, custom number formats, templates and personal views
Use AI tools including Copilot and ChatGPT to write formulas and automate spreadsheet tasks

Course content

13 sections • 106 lectures • 7h 55m total length

Introduction to what we'll cover and how2:47
Please see lecture 2, to download the template that we'll work with. There are various templates to download. Normally, they're at the start of each section. Thanks.

Enter numbers and fractions5:00
Dates and Times7:46
Name Cells and Ranges3:45
Download the template workbook and have a go at the same examples as the tutor.
Validate Data entry using a pick list7:34
Extend a series of dates with autofill4:18
You can extend a time increment series an hour at a time. Type any number in the step value of the series dialog box.
Add a symbol or special character3:56
Excel fonts are based on Unicode. To use a language other than English and set up the appropriate keyboard, click the Windows Start Menu, click Control Panel and click Regional and Language Options.
Compare multiple spreadsheets using freeze panels6:08
Hide rows4:24
Keyboard9:58
Alt + Underscored letter of the menu name > Select a menu from an Excel menu

Alt + Enter > Display the choices in a drop-down menu

Shift + Tab > Move to the previous item

Ctrl +PageDown or PageUp > Move to the next or previous worksheet in a woekbook

Excel shortcuts
Speak Cells3:48
Speech recognition is no longer in Excel 2007 ... use F1 to find out more. But there is Speak Cells. So excel can read your cells to you.
Find and replace data10:35

Add values3:08
Function wizard6:07
Try rounding 2125.123 to -2 ... the answer is 2100.000. Note - the 2,1000.000 preserves the number of digits of the original number, but rounds two places to the left of the decimal point.
Formulas with comments4:32
OneNote5:43
Define a constant4:01
Apply names in functions4:50
Figure out the best loan terms4:23
Internal Rates of Return4:16
Nth largest value3:53
Large, Small, Max, Min4:38
Conditional formula2:59
Conditional formula with names3:58
Count If2:02
Conditional sum2:53
Inner calculator2:32
Square Roots3:06
Calculate the duration between two times4:07
Calculate days between two dates4:28

Enter list data using a form4:39
Searching through a data list4:15
Import a word list into excel4:36
Sort a list1:58
Filter a list2:37
Sort by multiple criteria2:58
Find averages in a sorted group5:07
Filter by multiple criteria3:07
Remove duplicate records from a list3:03
Count filtered records6:51
Filter by multiple criteria in the same column6:03
Chart a filtered list2:24
Look up information in a List5:08

Create a PivotTable5:29
Modify a PivotTable and layout2:53
Find the average of a field4:01
Create a calculated field3:57
Calculated fields and charts1:55
Hide rows and columns in a PivotTable1:59
AutoFormat a PivotTable1:14
Create a PivotChart3:01
Turning on the Data Analysis function so that statistical information can be run2:27
Describe Data with Statistics2:59
Discover associations within your data3:30
Note - with correlations the answer is anywhere between -1 and +1. If its negative, the relationship is negative eg as age increases, batting averages decreases.... A Positive result (closer to +1) is that as the number of years in sales increases, sales increases.
Product Numbers1:46
What-if analysis5:11
Goal seek6:20

Requirements

Students will need to have Excel 2007 or more recent installed, as this is the system used in the teaching

Description

You already know the basics. Now it's time to work smarter.

Excel Pro Hacks gives you 101 practical, immediately usable tips that will transform the way you work in Excel - at your job, in your business, or on your own projects. No theory, no padding. Just tips you can apply the moment you learn them.

With 7+ hours of step-by-step video across 100+ lectures, this is one of the most comprehensive Excel productivity courses on Udemy - and with a high rating from thousands of students, it delivers.

What you'll master across 12 sections:

Data entry shortcuts: dates, fractions, autofill, freeze panels, keyboard tricks
Formulas and functions: COUNTIF, conditional sums, VLOOKUP, IRR, date calculations
Copying, formatting and paste special — the tricks most Excel users never discover
Lists: sort, filter, remove duplicates, VLOOKUP and multi-criteria filtering
PivotTables and PivotCharts: create, modify, calculate and visualise your data
Charts: create, format, trendlines, histograms, pie chart tricks and Word integration
Worksheets: formatting, percentages, currencies, Format Painter, background images
Saving and printing: templates, XML, multi-area printing, headers and footers
Extending Excel: hyperlinks, PowerPoint embedding, web data import, Access integration
Customising Excel: custom views, number formats, macros and text-to-columns
NEW: Using AI and Excel together — Copilot, ChatGPT and the future of spreadsheets

Works with Excel 2007 and all later versions including Microsoft 365. You'll be able to follow along immediately by pausing and copying what you see on screen.

Who this course is for:

Excel users who know the basics and want to work significantly faster and smarter
Office workers, analysts and business owners who spend hours in Excel every week
Anyone preparing for a job that requires strong Excel skills - finance, admin, data, operations

Excel Pro Hacks - 101 Tips to Boost Your Productivity

What you'll learn

Explore related topics

Course content

Introduction to the course and your tutor1 lecture • 3min

Data11 lectures • 1hr 7min

Formulas and Functions18 lectures • 1hr 12min

Copying Data, Formats etc.,6 lectures • 32min

Lists13 lectures • 53min

Data Patterns14 lectures • 47min

Creating Charts14 lectures • 55min

Worksheets6 lectures • 21min

Saving and Printing Worksheets8 lectures • 43min

Extending Excel6 lectures • 35min

Requirements

Description

Who this course is for: