Shopping Cart

Our Top 3 Excel Tips from 2021

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 2021 as the year draws to a close, we thought to remind you of our top 3 most popular and helpful tips shared over the last twelve months. 

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, ctrl + v 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”. 

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 ctrl + G to call up the Go To, and click on “Special” in the bottom left corner. Then select Blanks and click OK. Finally, press ctrl + – 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

Within the Windows workspace, there’s a simple rule of thumb: dragging and dropping an item will move it; dragging while holding down ctrl on your keyboard will create a copy of said item. 

This works within any and every Windows system, including Excel. 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 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 2021.

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 every month. Alternatively, enrol for a full Beginners, Intermediate or Advanced Excel training course and start your upskill journey today. 

MS Excel Advanced Course

R 1,550

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 1,150

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

This draw is closed. Keep checking back, for the next draw.