Working with tables in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 9 videos | 38m 15s
- Includes Assessment
- Earns a Badge
- CPE
Tables are a powerful tool for organizing, analyzing, and presenting data. In this course, you will learn all about creating and using tables. First, find out how to add and modify tables. See how to create a table from a range, as well as how to add, remove, and reorganize table rows and columns. Next, the course shows you how to use table styles to enhance the presentation of your data. See how to apply built in styles, configuring table style options, and creating custom styles to meet your specific needs. Finally, you will discover how to efficiently manipulate your table data. Learn how to perform calculations using calculated columns and structured references. See also how to organize your data by removing duplicates and using slicers to filter out certain values. 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 working with tables in excel 365 (2023) course
Create and remove tables
Add, remove, and reorder table columns and rows
Apply built-in table styles
Configure table style options -
Creating custom table styles
Use calculated columns and structured references to perform calculations with tables
Remove duplicate entries and use slicers to filter table data
Modify slicer caption, style, and size
IN THIS COURSE
-
58sThis video outlines the key content covered in the Working with tables in Excel 365 (2023) course, including creating tables, modifying table design, and organizing table data. FREE ACCESS
-
3m 59sUsing tables is an effective way to sort, filter, and format your data. In this video, you will see how to create a table from a range. You will also see how to remove a table by deleting it or converting it to a range. This video aligns with MO-210 Microsoft Excel Exam objectives: Create Excel tables from cell ranges, and Convert tables to cell ranges. FREE ACCESS
-
3. Modifying table columns & rows in Excel 3655m 10sOnce you have created a table, you can easily modify it to suit your needs. In this tutorial, you will see how to resize tables. See also how to insert, move, and delete table columns and rows. This video aligns with MO-210 Microsoft Excel Exam objective: Add or remove table rows and columns. FREE ACCESS
-
4. Applying table styles in Excel 3653m 31sTables make it easy to present your data with visually appealing, consistent formatting. In this video you will see how to use the Format as Table command and change your table's style. This video aligns with MO-210 Microsoft Excel Exam objective: Apply table styles. FREE ACCESS
-
5. Modifying table design in Excel 3654m 41sAfter you have assigned a style to your table, you can further modify its design by configuring table style options. In this tutorial, you will see how to hide and show the header row and total row, modify the appearance of columns and rows, and more. This video aligns with MO-210 Microsoft Excel Exam objective: Configure table style options; Insert and configure total rows. FREE ACCESS
-
6. Customizing table styles in Excel 3655m 1sExcel offers a variety of attractive built-in table styles. However, it is also possible to add your own personal touch by creating a new custom style or duplicating and modifying an existing one. Find out more in this tutorial. FREE ACCESS
-
7. Using formulas with tables in Excel 3654m 55suse calculated columns and structured references to perform calculations with tables FREE ACCESS
-
8. Organizing table data in Excel 3654m 36sTables offer a few tools to help you better organize your data. With tables, you can quickly remove duplicate entries and insert slicers to filter data based on column values. Find out more in this video. FREE ACCESS
-
9. Formatting slicers in Excel 3655m 25sLike tables, slicers are completely customizable. You can change the caption that displays on the slicer, apply built-in and custom styles, and modify them in a number of other ways. Watch the video to learn more. 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.
