Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.
How to use VLOOKUP in Excel
VLOOKUP allows you to look for a specified value in a column of data inside a table, and then fetch a value from another column in the same row. An example might be where you need to find the sales for a specific salesperson from within a monthly sales report. In this lesson you’ll learn how to use VLOOKUP in your spreadsheets by walking you through several simple examples. The lesson will also highlight some shortcomings of VLOOKUP, plus a solution to those shortcomings.
How to use the IF function in Excel to calculate values based on different criteria
The IF statement is a simple function in Excel that is one of the building blocks you need when you are working with large spreadsheets. You may not know you need it yet, but once you know how to use it, you won’t want to live without it.
Using multiple IF statements in Excel
The IF() function in Excel allows you to evaluate a situation which has two possible outcomes (e.g. sales are greater than $1000) and calculate a different value for each outcome. However, sometimes you need to work with situations where there are more than two possible outcomes. That’s where multiple, or nested, IF functions come in handy. In this tutorial we’ll cover how to use nested IF functions to calculate sales commission for a team of sales people, given a range of different commission rates.
Manage user accounts at the command line in Linux
This lesson covers various aspects of managing users at the command line in Linux.
Use the SUM function to add up a column or row of cells in Excel
There are a variety of ways to add up the numbers found in two or more cells in Excel. This lesson shows you how to use the SUM function to add up cells, rows and columns of cells in Excel.
Scale your spreadsheet to fit on one page when printing from Excel
Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.
You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you’ve entered. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page.
Scale your Excel spreadsheet to fit your screen
If you work with large Excel spreadsheets, you’ll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn’t always give you the result you want. Often, it will make your spreadsheet too small or not small enough.
Select cells quickly and easily in Excel using the keyboard instead of the mouse
Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here’s a quick technique for selecting a range of cells in Excel.
Use the keyboard to move between worksheets in a workbook
One of the last keyboard shortcuts I mastered in Excel was moving between worksheets. Fortunately it’s easy, and you don’t need to wait as long as I did.
Quickly enter a formula in multiple cells
Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you an even faster way to do it.
Additional Info
Join our mailing list
