by Nate Moore | Dec 14, 2011 | Basics
The code dddd mmm d, yyy may not mean anything to you now, but it will after watching Excel Video 218. I’ll walk through several date formatting options today. You’ll see how to use the d code to get a date to show up as 1, 01, Mon, or Monday. Watch how to use the m...
by Nate Moore | Dec 12, 2011 | Basics
Excel Video 217 has some easy ways to format numbers and dates in Excel. Do you want to put a dollar sign in front of your number? Add a comma as a thousands separator? Display a number as a percentage? Increase or decrease the number of places after the decimal? All...
by Nate Moore | Dec 7, 2011 | Basics
When Excel Video 216 talks about orienting cells, we’re not talking about Asia, we’re talking about the direction of the text in the cell. Like the last couple of videos, Excel Video 216 has another trick to compress the space you need to display your data on a...
by Nate Moore | Dec 5, 2011 | Basics
Now that the NBA might be starting again, Excel Video 215 talks about two types of centers. We don’t have any 7 footers, but we do have two ways to center data across columns. There’s an icon in the ribbon for our first approach, Merge and Center. You’ll see how to...