Getting started in Excel 365

Excel    |    Beginner
  • 12 videos | 41m
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Excel 365 is the spreadsheet application in the Microsoft 365 suite. In this course, you will explore how to find and open the Excel 365 application, navigate the interface and create spreadsheets. Key concepts covered in this course include accessing the app and exploring the interface, which features a ribbon with multiple tabs, a status bar, and a Quick Access Toolbar with multiple tools for visualizing your spreadsheet data. You will also learn how to open a new workbook and how to create a worksheet from a template. You will explore how to add data to a spreadsheet, copy and paste data into a spreadsheet, resize columns and rows; and delete items from a spreadsheet. In addition, you will discover how to undo recent actions you may have performed in error, or redo an action to save time. You will also look at how to insert one of the built-in formulas from the Function library to perform calculations on your data; how to save a worksheet or workbook that you've created; and how to share your spreadsheets with others. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this microsoft 365: getting started in excel 365 course
    Open and explore excel 365
    Create and open a spreadsheet in excel 365
    Input data in an excel 365 spreadsheet
    Copy and paste data in excel 365
    Resize columns and rows in an excel 365 spreadsheet
  • Delete items in an excel 365 spreadsheet
    Undo and redo actions in excel 365
    Insert formulas using the excel 365 function library
    Save a spreadsheet in excel 365
    Share a copy of a workbook online or send it
    Use excel 365 spreadsheet templates

IN THIS COURSE

  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1014 users Rating 4.6 of 1014 users (1014)
Rating 4.3 of 603 users Rating 4.3 of 603 users (603)
Rating 4.2 of 123 users Rating 4.2 of 123 users (123)