Excel

Hints and Tips Part 7

Home
Excel
Hints and Tips Part 7

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.

Events

Date
Sep 17, 2024

Time
3:30 PM

You must be logged in to access these events.

login or register

Related Courses

Formulas Refresher

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

Date
May 7, 2024

Time
11:00 AM

Charts Part 1

One of the most used features of Excel is the ability to visualise data with charts, and this session focusses on the Types of chart,...

Date
May 8, 2024

Time
2:00 PM

Charts Part 2

This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...

Date
Jun 18, 2024

Time
12:30 PM

Hints and Tips Part 3

This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...

Date
May 13, 2024

Time
11:00 AM

Extending and Customising a Pivot Table

In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...

Date
Sep 9, 2024

Time
9:30 AM

Hints and Tips Part 1

This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some popular hints...

Date
Jun 10, 2024

Time
11:00 AM

Pivot Tables From Scratch

Pivot Tables are one of the most revered – and feared – elements Of Excel. In this one-hour session we explode some of...

Date
Jul 15, 2024

Time
11:00 AM

Logical Functions

Logical functions in Excel allow you to have the program make decisions based on criteria you specify. A simple example could be to...

Date
Jun 17, 2024

Time
9:30 AM

FAQ's

How do I view the system in my local time?

You can view the system in your local time by going to My Account > Edit Profile (Or click the timezone in the top bar > edit profile), once here you'll see a dropdown called timezone. If you change this to your timezone the platform will reflect this.

Can I access a module after completion?

If you go to the My Account area, you will see all the learning events you’ve attended. You can download the related handouts for as long as you maintain your subscription. You can watch recordings of all events for up to 30 days after the event.

How do I access a recording?

If you go to the My Account area, you will see all the learning events you’ve attended. You can access the recording of any session you attended for 30 days afterwards.

How do I receive my certificates?

They will be emailed to you automatically and are accessbile via the certificates tab on the My Account page.

Does the course or module come with accreditation?

Any courses or modules which are CPD accredited are clearly indicated

Why can’t I hear the course?

There may be an issue with your choice of speaker, please check your settings in Zoom.

Can I use a tablet or smart phone?

Yes – our courses are designed to be accessed using any mobile device

How can I update my password?

On your Login page, hit the Forgotten Password button. Follow the instructions on the next Reset Password screen and you’re done!

Duration

60 Mins

Facilitator

David Millard