Excel allows you to enter dates but you may want to show them in different ways. This is where you can format how a date is displayed including showing the day of the week. You will also see how to fix what happens if you enter a number and displays as a date because you originally typed in a date.Gary Schwartz from http://www.jargonfreehelp.com shows us how.

If you need to format numbers in excel to increase or decrease the number of decimal places then you can do that easily. It could be that you want to specify exactly how many decimal place such as two decimal places. Gary Schwartz from http://www.jargonfreehelp.com shows us how. This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0

Here are quick ways to resize columns and rows in Excel. No menus just clicks with the mouse. Presented by Gary Schwartz

It is common to want to have more than one line in a cell in an Excel worksheet. To have multiple lines in a cell can be done using Word Wrap which is a formatting option. You can do this in format cells. Gary Schwartz from http://www.jargonfreehelp.com shows us how. This works on all versions including Windows and Mac This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

If you are looking through your spreadsheet you might want values to stand out, you might be looking for something too high or too low. It would be handy if these values automatically formatted so that you could see these values easily, that's where conditional formatting comes in. This video by Gary Schwartz from http://www.jargonfreehelp.com explains how make numbers stand out on your worksheet based on particular criteria.

Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly drawn to what you are looking for. Here Gary Schwartz from http://www.jargonfreehelp.com gets us started with highlight cells rules, data bars, color scales, icon sets and top-bottom rules. You will also see how to clear a rule. See part 2 for more customising of the rules. Related videos: Conditional formatting Part 2: https://youtu.be/Uws-DHgDtXY Using formulas in conditional formatting: https://youtu.be/oKCHuykQHuQ

In part 2 we take a look at how to manage rules and how to customise the formatting of a conditional format. You can also delete and manage rules, change icons in an icon set and see more conditions. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. Related videos: Conditional formatting Part 1: https://www.youtube.com/watch?v=lWwho3T9OCM Using formulas in conditional formatting: https://youtu.be/oKCHuykQHuQ

Excel 2010 and 2013 make headers and footers a lot easier and more accessible than previous versions like Excel 2003. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how to use them..