Excel Tables offer an easy way to create dynamic ranges that adjust when data changes. This makes tables perfect for pivot tables, charts, and dashboards that need to show the latest data. This course covers the key benefits of tables, including a detailed review of structured references, the special formula language for tables. Examples include VLOOKUP, INDEX and MATCH, and SUMIFS. The course also covers, table styles, slicers, filtering, sorting, and removing duplicates.
The short answer: Tables are a fantastic way to create dynamic ranges, and dynamic ranges allow you to write formulas that stay up to date when data changes. This is a killer feature for many business applications.
Yes. There are some small differences in the Mac and Win interface with respect to tables, but in general this is one area in Excel where there is very good overlap between the Mac and Windows versions. The videos were recorded in Excel 2016 on Windows 10. All videos highlight shortcuts for both Windows and Mac.
Of course! If you aren't happy with the course, just let us know within 30 days and we'll give you a full refund. This a no-quibble guarantee. We want you to be completely happy.
When you purchase the course, an account will be created for you automatically on the Exceljet website. You'll receive an email immediately with a link to login, and when you do log in, you'll have full access to all videos and practice worksheets for the course(s) you purchased.
We think people learn best with lots of examples and a no-nonsense approach that is quick, clean, and to the point.
It's a lot harder to make short videos, but we think you're worth it :)
Less is more.