Excel, and indeed all of Microsoft 365, has recently been upgraded with AI-powered tools. This Hints & Tips session explores three of them specific to Excel; the Quick Analysis button, the new Add-Ins button and the Analyze Data button.
Using these tools we will add features to Excel to enhance functionality including Sparklines, Charts, Totals, Pivot tables and charts and an Infographic chart by using the People Graph Add-In. We will discover how it is now possible to interrogate your data simply by asking it questions in plain English.
Beginner level, no experience necessary.
This one-hour session is an essential for any Excel user that has never had formal training or is a bit rusty! In it we cover some...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...
In this session we discover how a simple Pivot Table and Chart can be graphically filtered to show your best performers over time,...
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...
In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...
If your role involves combining sets of data that span several periods of time, it can be tricky if they are laid out and formatted...
Auditing tools allow users to problem solve formulas and ensure accuracy and error handling is an essential skill for anyone performing...