Excel Video 234 includes a couple more tips as we analyze the sample fee schedule we’ve been working on. Watch for how the F2 key not only lets you edit the formula, but Excel also color codes the formula components so you can easily find the cells that influence the...

Watch for more Excel tips as part of our fee schedule analysis example in Excel Video 233. We’ll use the division rules from Excel Video 231, format the results as a percentage, and then once we have our formulas ready, we’ll use the double-click trick to fill the...

I’m taking a different approach to the next couple Excel Videos, starting with Excel Video 232. Instead of covering a specific Excel function or feature, I’m going to use several Excel features as part of sample fee schedule analysis. I hope this approach makes it...

The next time you need to “do the math,” do it in Excel with the basic math functions explained in Excel Video 231. Excel makes it easy to add, subtract, multiply and divide. Today we’ll go through an example of each function in the context of a sample fee schedule....

Excel Video 230 shows how easy it is to get data from the internet into your Excel spreadsheet. If you’re downloading static data on a one-time basis, you can save time by having Excel enter the data for you. Not only does importing the data beat typing the data into...

Excel’s Text to Columns Wizard won’t stop any dementors, but Excel Video 229 can make importing demented data much easier. I don’t see CSV or TXT files as much as I used to, but if you have to import data from an older system, you’ll run across CSV and TXT files. CSV...

I’m taking a little different approach starting in Excel Video 228. Rather than follow along with an Excel menu, for the next several videos we’ll discuss some basic tasks and ways to accomplish those tasks in Excel. We’ll start with three ways to get data in Excel to...

If you liked the headers and footers in Excel Video 226 but want something a little more customized, watch Excel Video 227. We’ll walk through how to create a custom header or footer, the three areas of a header or footer, and how to use the icons to fill in...

Excel Video 226 introduces Headers and Footers, an easy way to have important information print at the top and/or bottom of each of your spreadsheet pages. Excel has a number of built-in headers and footers that make it easy to add today’s date, the file location,...

Do you need to customize the way your document prints? The Page Setup window, explained in Excel Video 225, has several tricks to help you change the way your spreadsheet prints. First, watch for a way to change the first page number in your document. That will come...

Are you ready for a printing shortcut? Excel Video 224 has a quick way to change both the print area and the page breaks on a page by simply dragging and dropping to create the print range you need. Even though we’re talking about printing basics, today’s trick is...

Watch Excel Video 223 for three quick printing tricks. First, we’ll create page breaks so that you can control where Excel divides one page from the next. For example, if you have about a page and a half of data, you might want two equally sized report pages instead...

If you’d like more precise control over your printing margins or which cells in your worksheet print, watch Excel Video 222. We’ll spend some time in the Page Setup menu in this Excel Video and you’ll see how to control top, bottom, left and right margins...

Excel Video 221 starts our discussion of printing spreadsheets in Excel. You’ll see how to choose a printer, set the number of copies, change the orientation of your printed report, and more. We’ll cover print margins briefly, but we’ll go into more detail on...

When you’re as old as I am, you occasionally forget what you called or where you saved a recent workbook. Excel Video 220 comes to the rescue with an easy way to find recent spreadsheets you’ve worked on. You’ll also see how to pin workbooks to the list of recent...

Happy New Year! If you’re new to Excel 2007 or 2010, save yourself 45 minutes by watching Excel Video 219. If you’re like a lot of new Excel 2007 or Excel 2010 users and are trying to find your way around the ribbon, this video will show you where a lot of good stuff...

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

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

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