Create your first Excel 2013 workbook
Start using ExcelThe best way to learn about Excel 2013 is to start using it. You can open an existing workbook or start with a template. Then, add some data into cells, use the ribbon, use the Mini toolbar.
Convert data to tablesOn the ribbon, click Tables > Table to convert your data to a table. You don’t have to do this, but working with data as a table has certain advantages.
Save and printGo to the Backstage, and decide where you want to save your workbook — to your computer, or to the cloud using Office 365 SharePoint or OneDrive. Also, see a preview of how the workbook will look after it’s printed, then clickPrint to print it.
Insert columns and rowsExpand your worksheet. For example, add some more columns: click in the column next to the table, start typing, then press Enter.
Formulas and referencesTables can be very helpful when it comes to formulas. But to really understand how they work, we’ll create one on our own. In doing so, we’ll learn about things like Auto fill to quickly complete cells, and functions to easily enter formulas.
Convert data to tablesOn the ribbon, click Tables > Table to convert your data to a table. You don’t have to do this, but working with data as a table has certain advantages.
Save and printGo to the Backstage, and decide where you want to save your workbook — to your computer, or to the cloud using Office 365 SharePoint or OneDrive. Also, see a preview of how the workbook will look after it’s printed, then clickPrint to print it.
Insert columns and rowsExpand your worksheet. For example, add some more columns: click in the column next to the table, start typing, then press Enter.
Formulas and referencesTables can be very helpful when it comes to formulas. But to really understand how they work, we’ll create one on our own. In doing so, we’ll learn about things like Auto fill to quickly complete cells, and functions to easily enter formulas.
Basic MathLet Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.
|
Working with DataExcel is an amazing tool for analyzing data. And Sort and Filter are some of the most commonly used features to help you.
|
Work with MacrosYou want to automate a repetitive task in Excel so that you can do the task again with a single click. The best way to do that? Record a macro.
|