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.
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.
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
