|Location and date:|
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.
Pricing & registration
Additional options and pricing may be available. See pricing and registration for more details.
Member $155, Non Member $185
2 CPD hour(s)
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
- financial analysts
You may also be interested in:
Learn the purpose of logical and lookup functions and how to use them with Excel for Microsoft 365.
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.
Member Development and Support
Email: [email protected]