Shopping Cart

Our Top 3 Excel Tips from 2023 (in 2024)

3-MS-Excel-Tips

Someone once said “you can’t teach an old dog new tricks”, but we tend to disagree. Whether you’re an Excel beginner or someone who has been using the program daily for the past decade, we believe there’s always something you can learn — a tip or three that you didn’t know can make all the difference. 

In fact, this belief is such a fundamental part of who we are as a business that we even have a page dedicated to sharing Excel tips with our audience. Looking back at 2023 as the year closed, we thought to remind you of our top 3 most popular and helpful tips shared over the last year. 

Excel Tip 1: Copy and Paste with Column Widths

Computers and other computer-like technologies would not be the same without the ability to copy-paste content. Our lives are certainly made easier by this little shortcut. But when used in Excel, the default ctrl + c (⌘ + c on Mac), ctrl + v (⌘ + v on Mac) copies everything, but column widths. Meaning that if you’re duplicating large amounts of content, you’ll have to manually adjust each column you’ve copied. 

We have a simple solution. Once your content is pasted, click “paste options” and select “keep source column width”. An even quicker fix is to use the keyboard shortcut ctrl + w (^ + ⌘ + v on Mac). 

Excel Tip 2: Quickest Way to Select & Delete Empty Rows

Importing data received from third-party systems often results in many empty rows and cells. Finding and removing these empty rows can time consuming. We have the simplest solution for this:

Select a column that you want to remove empty cells and rows from then press F5 (Fn + F5 on Mac) to call up the Go To, and click on “Special” in the bottom left corner. Then select Blanks and click OK. Finally, press ctrl + – (⌘ + – on Mac) to delete, and select “Entire row” followed by OK. 

And just like that, every empty row in your Excel document is gone. 

Excel Tip 3: Quickest Way to Duplicate Your Worksheet in Excel

There’s a simple rule of thumb: dragging and dropping an item will move it; dragging while holding down ctrl (^ on Mac) – sometimes labeled ‘control’ on your keyboard – will create a copy of said item. 

This works within Excel as well. Making it the easiest way to duplicate a worksheet. If you drag and drop a sheet tab it simply changes position, but if you drag and drop whilst holding down your ctrl (^ on Mac) button, you are able to duplicate a worksheet. This works across Workbooks as well, meaning you can easily copy and paste a worksheet from one workbook to another. 

There you have it, our top 3 Excel tips for 2023.

Want to learn some more? Head on over to our Excel Tips Page and sign up with your email for the latest in tips and tricks sent directly to your inbox. Alternatively, enrol for a full Beginners, Intermediate or Advanced Excel training course and start your up-skill journey today. 

Want to learn more?

Receive our Excel tips and news to your inbox!

"*" indicates required fields

Choices*
This field is for validation purposes and should be left unchanged.

Request a Consultation

MS Excel Advanced Course

R 1,750

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 750

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks