50s
This video outlines the key content covered in the Microsoft 365: Getting started in Excel 365 course, including how to create and open a spreadsheet, insert a formula from the Function Library, and how to share your spreadsheet. FREE ACCESS
4m 48s
In order to get the most out of Excel 365, you need to understand how to open the application and navigate the interface. In this video, you will explore how to open the Excel 365 application and discover its features, including a ribbon with multiple tabs, a status bar, a Quick Access Toolbar, and various tools for visualizing spreadsheet data. FREE ACCESS
3. Creating and opening a spreadsheet
3m 6s
The first step in presenting your data in Excel 365 is creating or opening a spreadsheet. In this video, you will explore how to quickly create a new workbook to start entering your data or open an existing workbook in Excel 365. FREE ACCESS
4. Inputting data
2m 59s
The cells found in your Excel 365 spreadsheet can contain both numerical and textual data. In this video, you will discover different ways to insert, edit, and replace data in your spreadsheet. FREE ACCESS
5. Copying and pasting data
4m 8s
When you start copying and pasting data in Excel 365, you will find that you have various options available to you. In this video, you will discover that you can, for example, paste content that you have copied to a new location. You can also paste formatting that has been applied, paste values, and even remove any formulas from your copied data. FREE ACCESS
6. Resizing columns and rows
3m 29s
In Excel 365, you're able to resize your columns and rows to ensure your spreadsheet data is readable and displays correctly. In this video, you will explore how to resize columns and rows manually, or let Excel 365 automatically resize your columns or rows. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.3.2 Adjust row height and column width. FREE ACCESS
7. Deleting items in your spreadsheet
3m 23s
If you need to remove data from your Excel 365 spreadsheet, you can use the delete tools. In this video, you will discover how to remove the contents of a cell. You'll also discover how to remove single cells, cell selections, and even entire rows or columns from a spreadsheet. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.1.3 Insert and delete multiple columns or rows. As well as MOS MO-200 / Excel Associate Certification exam objective: 2.1.4 Insert and delete cells. FREE ACCESS
8. Undoing and redoing actions
3m 3s
Excel 365 keeps a record of your recent actions and operations so you can undo them easily. This is useful if you've made a mistake, for instance. You're also able to redo actions that you have undone. In this video, you will explore how to cancel recent actions or return your worksheet to a previous state using the undo and redo features. FREE ACCESS
9. Inserting a formula from the Function Library
4m 11s
Excel 365 includes a Function Library, which holds various formulas grouped by category. In this video, you will explore how to use the Function Library in Excel 365 to help you locate and insert the formula you need. If you are unable to find the formula you want, you can also launch a search query. FREE ACCESS
10. Saving your spreadsheet
4m 8s
Knowing how to save your Excel 365 spreadsheet is essential to being able to work on your workbooks over multiple sessions. When saving the spreadsheet, you can specify the name of your workbook, where you'd like to store it, and the Excel-compatible version to save it in. FREE ACCESS
11. Sharing a spreadsheet
2m 54s
When using Excel 365, you can share your workbooks with other users. In this video, you will learn how to share spreadsheets with other users. This can be done by uploading a copy of a workbook to OneDrive, which is Microsoft's file repository hosted online. But if you don't use OneDrive, you can also share a workbook via email, as an attachment, or as a PDF. FREE ACCESS
12. Using spreadsheet templates
4m 2s
It can be time-consuming to create a workbook from scratch. Excel 365 comes with a large library of predefined, preformatted workbooks that can be used to get started on a project quickly. In this video, you will explore how to download a spreadsheet template and input your data or make your own changes to it. FREE ACCESS
