Excel - A Beginner's Guide to Formulas and Functions

Scope of the webinar :

Are you new to Excel and struggling to understand formulas? Look no further! This online training session is the perfect solution for you.
Think of any scenario that involves addition, subtraction, division or multiplication and that’s where you’d use a formula.

Functions are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula.

Topic Covered :

• Creating basic formulas: addition, subtraction, division, multiplication
• Using parentheses in formulas – the what and why
• Copying a formula – the gotchas you need to know about
• Make formulas logical and understandable by assigning names to your important cells
• Speed up your work by using the SUM, AVERAGE and COUNT functions

Who should attend :

This training is perfect for beginners who are new to Excel or have limited experience with formulas. Whether you are a student, professional, or simply looking to improve your Excel skills, this training is for you.

About The Speaker

In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI. Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare.

Outlook - Master Your Mailbox - Inbox Hero Inbox Zero

Overview

For most business users (and many home users too), Microsoft Outlook has become the standard application for managing emails, calendar appointments and to-dos. With an abundance of features and versions for desktop and mobile, there’s really no excuse not to be organized. Or so the theory goes.

With the average office worker receiving over 100 emails per day, the reality for most people is email overload, missed deadlines and calendars so full you have no room to stop, take stock and smell the roses (as the saying goes).

Objectives

This training session focuses on the email aspect of Outlook. In this session you’ll learn how, used in the right way, Outlook can save you time, help you to gain more control over your mailbox, improve your response time and allow you to keep up with the never-ending stream of critical actions and due dates.
Why you should attend

You’re probably reading this thinking “I use Outlook every day. I know how to send and receive emails. What more is there to learn?”

But just stop and think. How much time are you wasting searching for information stored in Outlook? Could your mailbox be better organized? Is your Inbox out of control? Are you drowning in a sea of emails?
Attend this training if you want to take control of your Outlook mailbox rather than letting it control you!
Topics covered

• Configure Outlook for distraction-free productivity
• Creating Rules to automate email processing
• Creating Quick Steps to automate a series of actions
• The 4 D’s of email management and how to apply them
• Converting emails into actionable to-do items
• Converting emails into calendar appointments
• Categories v Folders: What’s the difference and what are the pros and cons of each?

Who should attend

This introductory-level session is aimed at anyone who uses Microsoft Outlook and is looking for a way to get back those precious hours!
The training will be delivered using the latest version of Outlook although much of the functionality is available in earlier versions of the application.