Introduction to Formulae & Functions (FULL COURSE)

Paul Atwell 29th April 2021

0 Comments

This video is for those requiring an understanding of formulae construction within Excel. The usage of the functions SUM, AVERAGE, MAX, MIN, COUNT and TODAY are also demonstrated.

The topics discussed are:

How to construct a basic formula
Using Autofill
Understanding BODMAS
Absolute cell references
Creating a formula with a function
Mathematics with dates

Introduction to Formulae and Functions in Excel (FULL COURSE)

Categories: Course Recording, Excel, Microsoft

Tagged: Absolute referencing, AVERAGE, BODMAS, COUNT, Excel, Formula, Full course, Function, Introduction, Mathematical operators, MAX, MIN, Relative referencing, SUM, TODAY

Paul Atwell

I became an IT Trainer in 1990 and began working for NECS in March 2021. My training motto is "If I'm not enthusiastic then why should my delegates be?" That's my training style - enthusiastic, knowledgeable (hopefully) and, I'd like to think, quite entertaining. Who wants a dull course anyway?

Hosting Online Meetings – With More Success and Less Stress!

Online meetings with technical problems can make you hot under the collar. Here are 10 tips from the Applications Training Team to help you take the heat off yourself.

Anthony Langan 13th June 2018

0 Comments

Taking Outlook to Task

The Applications Training Team have noticed that many Outlook users are using the Calendar for to-do-items that really should be Outlook Tasks. Why not take a fresh look at Tasks and stay organised?

Anthony Langan 5th February 2019

0 Comments

Free, open access Coronavirus (COVID-19) learning programme

Health Education England e-Learning for Healthcare (HEE e-LfH) has created an e-learning programme in response to the Coronavirus (COVID-19) global pandemic that is free to…