Select Page

Excel Video 231 Add, Subtract, Multiply and Divide

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 Downloading Data from the Internet

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 Video 229 Text to Columns

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

Excel Video 228 Three Ways to get Your Data in Excel

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