Working with tables in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 9 videos | 39m 56s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)
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

  • 58s
    This 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
  • 4m 7s
    Using 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
  • Locked
    3.  Modifying table columns & rows in Excel 365
    5m 31s
    Once 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
  • Locked
    4.  Applying table styles in Excel 365
    3m 48s
    Tables 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
  • Locked
    5.  Modifying table design in Excel 365
    4m 51s
    After 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
  • Locked
    6.  Customizing table styles in Excel 365
    5m 16s
    Excel 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
  • Locked
    7.  Using formulas with tables in Excel 365
    4m 55s
    Tables consist of several features that make it easy to perform calculations. Calculated columns automatically copy formulas throughout column rows. Structured references allow you to reference table cells by name from within or outside the table. Find out more in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Use structured references in formulas. FREE ACCESS
  • Locked
    8.  Organizing table data in Excel 365
    4m 55s
    Tables 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
  • Locked
    9.  Formatting slicers in Excel 365
    5m 36s
    Like 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.

YOU MIGHT ALSO LIKE

Course Exploring essential functions in Excel 365 (2023)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Course Automating tasks in Excel 365 (2024)
Rating 4.1 of 14 users Rating 4.1 of 14 users (14)
Course Using tables in Word 365
Rating 4.4 of 53 users Rating 4.4 of 53 users (53)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started with charts in Excel 365 (2023)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Formatting cells and ranges in Excel 365
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)