Getting started in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 10 videos | 43m 30s
- Includes Assessment
- Earns a Badge
- CPE
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
-
55sThis 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 46sIn 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
-
3. Editing worksheets in Excel 3654m 41sAll 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
-
4. Saving & opening workbooks in Excel 3654m 45sOnce 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
-
5. Adding & removing workbook elements in Excel 3654m 35sIn 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
-
6. Undoing and redoing actions in Excel 3654m 8sExcel 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
-
7. Finding functions in Excel 3655m 3sFunctions 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
-
8. Using Office templates in Excel 3654m 48sTemplates 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
-
9. Customizing interface tools in Excel 3655m 4sThere 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
-
10. Sharing workbooks in Excel 3654m 46sExcel 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.
