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