Helpful Tips for Microsoft Excel
EXCEL: 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 it quickly and accurately.
List of Published Articles for Excel Help and Tips
EXCEL: 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...
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...
EXCEL: 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...
EXCEL: 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...
EXCEL: 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...
EXCEL: Save time adding new columns or rows
Adding multiple columns and rows into spreadsheets can be time-consuming, not to mention boring....
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...
EXCEL: Do super-fast sums without formulas
Excel is great for calculations with formulas. But if you find your head spinning trying to...
EXCEL: Speed up typing
Do you find yourself typing duplicate words or numbers into Excel? You can speed up this process...
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...
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...
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...
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...
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...
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...