EXCEL: Swap rows into columns and vice versa
When you need to swap your rows into columns or columns into rows, it can be tricky. Not only is it time consuming, but you run the risk of mixing up your data. We’ll show you how to do it ...
EXCEL: Create ranges of data without doing any typing
If you need to create sequential numbers, dates or other data in Excel, it can take forever. Not anymore. We’ll show you how to do it with the minimum of typing.
EXCEL: Save time adding new columns or rows
Adding multiple columns and rows into spreadsheets can be time-consuming, not to mention boring. Give that trackpad a rest and add as many new columns and rows as you need in one go. Here’s how.
EXCEL: Turn numbers into money with one click
If you’re using Excel to track budgets or other financial data, it can be helpful to have your currency symbol alongside the numbers. Here’s how to turn numbers into money, with just one click.
EXCEL: Do super-fast sums without formulas
Excel is great for calculations with formulas. But if you find your head spinning trying to remember how they work, we have the ultimate Excel hack for you. This video shows you how to do super-fast sums without formulas.
EXCEL: Speed up typing
Do you find yourself typing duplicate words or numbers into Excel? You can speed up this process by using the clever Flash Fill feature. It’ll save you from typing out the same info multiple times. Here’s how to use it. ...
EXCEL: Instantly see all data in columns & rows
Sometimes in an Excel document the column sizes need to be adjusted so you can see the data clearly. Rather than trying to change all the column and row sizes manually, we show you how to do it in just ...
EXCEL: Get to the top row without scrolling
If your Excel document is very long, it can take a lot of scrolling to get back to the top. Find out how to do it quickly, without moving the mouse or endless scrolling. It’s a shortcut you’ll use over ...
EXCEL: Easily zoom in and out
When you’re looking at data in Excel, make sure you’re looking at the bigger (or smaller) picture by using the Zoom functions. This video shows you how to zoom in and out easily.
EXCEL: Always see the headings when scrolling
Excel is great for looking at lots of data, but when you can’t see the column or row headers, you must scroll back and forth to check what the data means. Did you know there’s a great time saver which ...
