For Beginner
Add numbers in Excel 2013
Watch these videos to see how Excel 2013 makes it easy to add numbers using formulas, buttons, and functions (such as the SUM and SUMIF functions).
Basic math in Excel
Let Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.
Create a chart
Charts provide a visual representation of your data, making it easier to analyze. Each type of chart highlights data differently. And some charts can’t be used with some types of data.
Create your first Excel 2013 workbook
Watch these videos to learn how to use Excel 2013. Get started with the new version to see how to do everyday tasks.
Freeze or lock panes
You want to scroll down and see your rows of data, but when you get to the bottom of the screen, your column names in the top row have disappeared. To fix this, you freeze the top row so that it's always visible. Good news – the command is easy to get to. Click View > Freeze Panes > Freeze Top Row.
Top tips for working in Excel Online
Use Excel Online to change the formatting of numbers and text to help make your information stand out. And see 3 ways to quickly add numbers, too.
Understand and use cell references
One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell's location. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.
Use AutoFill and Flash Fill
Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help. Or say you have information in Excel that isn’t formatted the way you need it to be, and going through the entire list manually to correct it is daunting. In this case, Flash Fill (a new feature in Excel 2013) can do the work for you. AutoFill and Flash Fill are tremendous time savers, and in this course, we’ll cover them in more detail.
