Create and manage drop-down lists
Training To make data entry easier in Excel 2013, or to limit cell entries to certain items that you define, you can insert a drop-down list of valid entries.
Excel 2013
Create your first Excel 2013 workbook
Training Learn how to create an Excel 2013 spreadsheet from scratch. Save and print your spreadsheet, insert columns and rows, and create formulas and references in Exce...
Excel 2013, Office 365 Enterprise...
Understand and use cell references
Training Create a cell reference to cells on the same worksheet. A cell reference is a cell or cell range on a worksheet that can be used in an Excel formula.
Excel 2013
Use AutoFill and Flash Fill
Training Automatically fill data in your worksheet, like dates, numbers, text, and formulas. And Flash Fill recognizes patterns in your data and fills out the rest for y...
Excel 2013
Work with macros
Training In Excel, to automate a repetitive task, you can use the macro recorder to quickly record the steps in a macro, then do the task again with a single click.
Excel 2013
Take conditional formatting to the next level
Training Apply conditional formatting to specific cells, tables, PivotTables, and worksheets, and use formulas as the basis of a conditional formatting rule.
Excel 2013
Average a group of numbers
Training Average a group of numbers by clicking the AutoSum button, or use the AVERAGE and AVERAGEIF functions in formulas. Use the SUMPRODUCT and SUM functions to find ...
Excel 2013
Add or subtract time
Training Use simple formuls to add two different times together to get a total, and subtract one time from another to get the total time spent working on a project.
Excel 2013
Add numbers in Excel 2013
Training Excel 2013 makes it easy to add numbers using formulas, buttons, and functions (such as the SUM and SUMIF functions).
Excel 2013
Advanced IF functions
Training This course covers complex variations of the IF function in Excel, including nested IF functions, IF with AND and OR, COUNTIFS and SUMIFS, and AVERAGEIFS and IF...
Excel 2013
Basic math in Excel
Training Let Excel be your calculator. Learn how to add, subtract, multiply, and divide. With a simple formula, Excel can perform calculations on numbers using operators...
Excel 2013
Create a chart
Training Create a chart (graph) that's recommended for your data, almost as fast as using the chart wizard that's no longer available.
Excel 2013
Insert headers and footers
Training Learn what a header and footer is, where it is located, and how to print them in Excel. Add the date, time, page numbers, filename or any other text.
Excel 2013
Sort and filter data
Training Sort data in Excel quickly, in just a few clicks. To change the order of your data, sort it. To focus on a specific set of data, filter a range of cells or a ta...
Excel 2013
Make the switch to Excel 2013
Training Switch from an earlier version of Excel to Excel 2013. Get started learning new tools such as the ribbon, how to do common tasks such as saving and finding temp...
Excel 2013
VLOOKUP: When and how to use it
Training Use the VLOOKUP function to find data in large spreadsheets. You'll also learn how to find data on different worksheets, and copy the function.
Excel 2013
Freeze or lock panes
Training By freezing panes, you can scroll down or to the right and still see the rows or columns you want, wherever you are in your worksheet. Take this short training ...
Excel 2013
Office 365 Home: Share your subscription
Training This course covers the benefits of Office 365 Home. Install Office on 5 PCs or Macs and 5 tablets, share installs, and move Office to a new computer.
Excel 2013, Access 2013...
Use conditional formatting
Training Learn about creating, changing, or removing conditional formatting in Excel, including how to use conditional formatting for dates and text.
Excel 2013
Array formulas
Training Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results. Take this course to lear...
Excel 2013
Create a PivotTable and analyze your data
Training Learn what a PivotTable and PivotCharts are and how you can use them to summarize and analyze data in Excel 2013.
Excel 2013
Password protect workbooks and worksheets
Training Add a password to protect worksheets or your entire workbook and control whether others can open or make changes to them.
Excel 2013
Print worksheets and workbooks
Training Print Excel worksheets and workbooks one at a time, or several at one time. You can also print a partial worksheet, such as an Excel table.
Excel 2013
Didn't find what you were looking for?Search all of