Manipulate Data Using Tables 
in Microsoft Excel

Overview:

This module is designed to help learners effectively use tables in Microsoft Excel to manipulate and analyse data. Tables are a powerful feature in Excel that allow for easy organisation, sorting, filtering, and analysis of data sets. By mastering table functionality, participants will be able to work more efficiently with large amounts of data and gain valuable insights from their spreadsheets.

Target Audience:

This course is ideal for:

  • Beginners with little to no Excel experience
  • Professionals looking to refresh their basic Excel skills
  • Anyone wanting to improve their productivity with spreadsheets

By the end of this course, you'll be able to:

  • Create and format tables in Microsoft Excel
  • Apply sorting and filtering techniques to organise data within tables
  • Structured references to create formulas that automatically adjust as the table expands
  • Implement calculated columns to perform operations across entire table columns
  • Apply conditional formatting rules to highlight important information in tables
  • Utilise a data form to input and search for data
  • Use table styles to quickly change the appearance of tables

Topics include:

  • Understanding the concept of tables in Excel
  • Converting data ranges into tables
  • Applying table styles for visual appeal
  • Customising table headers and row formatting
  • Introduction to structured references in tables
  • Creating formulas using structured references
  • Defining calculated columns within tables
  • Creating formulas that apply to entire column
  • Understanding how structured references adjust with table changes
  • Utilise a data form to input and search for data
  • Enabling the Total Row in tables
  • Selecting summary functions (e.g., sum, average, count)
  • Understanding when to convert tables back to ranges
  • Overview of conditional formatting in tables
  • Exploring built-in table styles
  • Customizing table styles for branding or preference

All Microsoft Excel Modules

Automate Decisions with Logical Functions

Search and Retrieve Data from tables with Lookup Functions

Analyse and Visualise Date with Pivot Tables

Add Automation to Your Workbooks with Macros

Transform Your Data with Power Query

Use AI in Excel to Turbo Charge Your Excel Experience

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data


Back to Training Courses
Submit
Thank you! Your message has been sent.
Unable to send your message. Please fix errors then try again.
Smiling professional man giviing okay gesture and holding a laptop

Contact Us

To find out more about our products and services or to discuss how we can help  improve communications and collaboration using Microsoft 365 apps within your organisation, give us a call on the telephone number below or complete the contact form.

  01274 024 353

Last Updated : 04/08/2024