Microsoft Excel

Excel is a powerful spreadsheet and data processing application.

Tutorial

Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.

When you create a new Excel workbook, the app presents a blank workbook that contains one worksheet. You can add or delete worksheets, hide worksheets within the workbook without deleting them, and change the order of your worksheets within the workbook. You can also copy a worksheet to another workbook or move the worksheet without leaving a copy of the worksheet in the first workbook. If you and your colleagues work with a large number of documents, you can define property values to make your workbooks easier to find when you and your colleagues attempt to locate them by using the Windows search box.

Another way to make Excel easier to use is by customizing the Excel app window to fit your work style. If you find that you use a command frequently, you can add it to the Quick Access Toolbar so it's never more than one click away. If you use a set of commands frequently, you can create a custom ribbon tab so they appear in one place. You can also hide, display, or change the order of the tabs on the ribbon.

We will focus on

• Creating Workbooks
• Editing Sheets
• Editing Data
• Creating Tables
• Creating Charts