Combine text from two cells into one
When you need to combine two cells into one, there’s no need to cut and paste every cell. With this simple formula, you can do
Category: How to excel
Understand your data with super-fast graphs
Excel is such a clever tool, it can make sense of your data for you. This video will teach you how to take a sheet
Make a drop-down list to select from
Don’t waste valuable time typing the same data into Excel repeatedly. We’ll show you how to create a dropdown list that will get the job
Insert live Excel data into Word
If you need to display data from an Excel sheet in your Word document, don’t waste time trying to recreate it. We’ll show you how
Make dull data stand out and become dynamic
You may think it impossible to make Excel sheets appear interesting. Well, you’d be wrong. In this video you’ll learn how to make your data
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
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
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
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
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