Hello Excellers. Welcome back to another Excel Tip. Today I will show you how to fit longer text into Excel. This is a simple trick. I have been asked this question recently so thought it was worthy of a short Excel blog post. Do you ever have a long line of text in Excel? It may look at bit like my screengrab below. Sometimes if you have a free text notes column or even longer names or addresses you end up with text running over multiple Excel cells. So, if you look at … [Read more...]
How To Use The Quick Analysis Tool In Excel.
From Excel 2013 onwards, the quick Analysis Tool makes it really easy to analyse your data quickly and easily. It contains a variety of Excel tools. The tool can be used with data from a range of cells or an Excel data table. How To Access The Quick Analysis Tool. So, it is really easy to get started with the Quick Analysis tool. Once you select a range of cells or an Excel data table, the tool appears at the bottom right of your data set. A range of analysis tools is now available to … [Read more...]
Absolute References With Excel Tables.
Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today's blog will show you all you need to know about how to use Absolute (and Relative) references when you are using an Excel table and structured references. Absolute Cell References. I think one of the most useful and first thing we learn when using Excel is the value of using the $ symbol. (Or the F4) key. This allows you to freeze a column or row, so when dragging a formula down a … [Read more...]
Excel Tip. Copy A Worksheet And Create A New Excel Workbook.
Hello, Excellers. Time for another Excel tip. I want to share with you a question from a subscriber. How to copy a worksheet It is going back to basics. They needed to take one worksheet from a sales workbook and create another workbook with just that one worksheet. They previously had been making a copy of the workbook and then deleting the extra unnecessary worksheets they did not need. Copy Your Excel Worksheet. There is a quick and easy way to do … [Read more...]
Get Quick Statistics About Your Excel Workbook.
Hello, Excellers. I think this next #Excel tip will come as a relief, especially if you have inherited a workbook. Yes, quick statistics about your Excel workbook are now available.!. You may need to know how many Pivot Tables, Macros, formulas and tables you have in a workbook. This new feature was made available in April 2020. It is now available in the following versions. Watch The YouTube Video. https://youtu.be/j9yinn3cJAw Excel for Microsoft 365 Mac Excel … [Read more...]
- 1
- 2
- 3
- …
- 47
- Next Page »
Recommended Excel Resources
