Formulas Refresher - Smith Warehousing

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 basics like simple calculations, the Order of calculation, Absolute references, Named ranges, Outlining and if time allows) VLOOKUP. Introduction level.

Events

There are no upcoming events at this time.

Related Summaries

Office 365 for Dummies

"Office 365 For Dummies" is a comprehensive guide to the cloud-based productivity and collaboration suite from Microsoft. The book is written by Rosemarie Withee, Ken Withee, and Jennifer Reed and is designed to help users get up and running with Office 365 quickly and easily.

Related Courses

Office 365

2 Events

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

Next Event:

Date
Nov 14, 2023

Time
9:30 AM

Office 365

1 Events

Filters (Sorting, Including Advanced Filters)

This one-hour session explores fundamental Excel skills that every user should benefit from including Sorting on multiple fields, Changing...

Next Event:

Date
Dec 12, 2023

Time
9:30 AM

Office 365

1 Events

Hints and Tips Part 2

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

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

Hints and Tips Part 4

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

Hints and Tips Part 5

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

Next Event:

Date
Oct 12, 2023

Time
2:00 PM

Office 365

1 Events

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

Expanding a Pivot Table and Normalising Data

In the final Pivot Tables session we conclude our training on this subject by discovering how the same field can display different...

Next Event:

Date
Nov 6, 2023

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