Getting started in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 10 videos | 43m 30s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Microsoft Excel 365 is a powerful spreadsheet application that can help you organize, analyze, and present data. This course introduces you to the fundamental skills you need to start using the app. First, you will see how to open Excel and navigate its interface. You will also learn how to input and edit worksheet data, as well as insert and remove worksheets, columns, rows, and cells. Next, the course teaches you how to save your work and open saved spreadsheets. In addition, you will learn how to remove data from a worksheet, as well as how to undo and redo actions as you edit. Finally, discover how to find and use basic functions to manipulate spreadsheet data. See also how to create a worksheet from a template, customize the application interface, and share your worksheets with other users. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the getting started in excel 365 course
    Open excel in a new workbook and navigate the interface
    Enter, edit, and remove spreadsheet data
    Save and open workbooks
    Insert and delete worksheets, columns, rows, and cells
  • Undo, redo, and repeat actions while editing a spreadsheet
    Insert functions using the function library and insert function tool
    Find, open, and use office online templates
    Configure user interface tools and customize the status bar
    Share workbooks via onedrive and send a copy by email

IN THIS COURSE

  • 55s
    This video outlines the key content covered in the Getting started in Excel 365 course, including exploring the interface, adding and removing workbook elements, and sharing workbooks. FREE ACCESS
  • 4m 46s
    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 see how to open Excel and identify the main parts of the interface, including the Office Ribbon and Backstage View. FREE ACCESS
  • Locked
    3.  Editing worksheets in Excel 365
    4m 41s
    All data in Excel is entered in a worksheet. In this tutorial, you will learn to identify the different components of a worksheet. You will also see how to enter, edit, and clear data in worksheet cells. FREE ACCESS
  • Locked
    4.  Saving & opening workbooks in Excel 365
    4m 45s
    Once you have begun entering data in Excel, you will need to save your work. After you have saved a workbook, you can easily retrieve and open it in Excel. Watch the tutorial to see how to save and open workbooks. FREE ACCESS
  • Locked
    5.  Adding & removing workbook elements in Excel 365
    4m 35s
    In Excel, you can easily add new worksheets to your workbook and new rows, columns, and cells to your worksheets. If you no longer need these items, you can delete them as well. Find out how in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objectives: Insert and delete multiple columns or rows; and Insert and delete cells. FREE ACCESS
  • Locked
    6.  Undoing and redoing actions in Excel 365
    4m 8s
    Excel 365 automatically keeps track of your recent actions so you can easily undo them if you make a mistake. In addition, you can redo actions that have been undone and repeat the last action. See how to undo, redo, and repeat in this tutorial. FREE ACCESS
  • Locked
    7.  Finding functions in Excel 365
    5m 3s
    Functions are built-in formulas used to manipulate data in a number of ways. In Excel, you can quickly insert SUM and a number of other functions from the Home Tab. You can also explore the Function Library and use the Insert Function tool to perform a wide variety of calculations. Find out more in this tutorial. FREE ACCESS
  • Locked
    8.  Using Office templates in Excel 365
    4m 48s
    Templates are a great way to enhance your workflow and learn more about how workbooks are structured. In this tutorial, you will see how to access the online template library and create a new workbook from a template. FREE ACCESS
  • Locked
    9.  Customizing interface tools in Excel 365
    5m 4s
    There are a number of tools built in to the Excel user interface to enhance your experience in various ways. Several of these tools, like the Search Bar, Mini Toolbar, Screen Tips, and Status Bar are customizable. In this video, you will see how to configure user interface options in Excel 365. FREE ACCESS
  • Locked
    10.  Sharing workbooks in Excel 365
    4m 46s
    Excel 365 makes it easy to collaborate on spreadsheets. You can send a copy of a file as an email attachment for others to consult. Or if you need your colleagues to edit or view the workbook, you can share the file over OneDrive instead. See how in this tutorial. 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

Course Adding & arranging data in Excel 365
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Working with tables in Excel 365 (2023)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)