Select Page

Excel Video 218 Custom Date Formats

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...

Excel Video 217 Number and Date Formatting

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...

Excel Video 216 Orienting Cells

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...

Excel Video 215 Two Ways to Center Data

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...