Excel tables and tabular data

Learn how to create tabular data sets in Excel so you can better organize and analyze financial information using Microsoft 365.

Event Details

Location and date:
Online On-Demand Event

Being effective and efficient in your daily accounting and finance work centres on your ability to create data tables. This course covers the key features of effective tabular data sets and structured references in Excel.

This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel Certificate Program.

Additional options and pricing may be available. See pricing and registration for more details.



Member $155, Non Member $185

2 CPD hour(s)
Pricing & registration

You will learn about:

  • why building data in tabular format is important
  • building data in tabular format
  • Excel’s sort, filter and subtotal features
  • creating tables using Excel’s table feature
  • structured references
  • customizing table styles
  • applying conditional formatting within a table

Who should attend?

  • advanced Excel users
  • IT professionals
  • business intelligence educators
  • consultants
  • financial analysts

More Details:

Speakers/Presenters

You may also be interested in:

Learn how to use essential functions in Excel for Microsoft 365 that will help you evaluate financial data and make better business decisions.

Deepen your understanding of Excel’s date and time functions so you can perform complex calculations using Microsoft 365.

Contacts

Please contact:

Member Development and Support
Tel: 1-800-268-3793
Email: [email protected]