by Nate Moore | Feb 13, 2012 | Basics
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....
by Nate Moore | Feb 8, 2012 | Basics
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...
by Nate Moore | Feb 6, 2012 | Basics
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...
by Nate Moore | Feb 1, 2012 | Basics
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...
by Nate Moore | Jan 30, 2012 | Basics
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...
by Nate Moore | Jan 25, 2012 | Basics
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,...
