FREE Excel Class

TOP 10 EXCEL FORMULAS YOU NEED TO KNOW

 

About this Class

 

Excel is one of the most powerful tools in business, yet too many people have a basic understanding of how to get the most out of it. Knowing which formulas to use and being able to combine or nest different formulas can quickly make you one of the most valuable people in your organisation. Formulas save time and allow us to perform complex calculations with relative ease. With over 400 functions available it can be difficult to find the ones that are going to be the most useful. This session aims to de-mystify functions and show you the most popular and useful formulas in Excel. The best thing is, it’s completely free.

 

Click The Register Now Button to See Available Times

 

register-button-png-16

 

Class Tutor

deb-edited

 

This webinar is brought to you by Skillsology’s in-house IT trainer, Deborah Ashby. Deborah Ashby specializes in Microsoft Office training and content creation. Deborah has been an IT Trainer for 9 years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

 

Webinar Syllabus

 

An introduction to Formulas and Functions

 

  • What is a formula?
  • The formula bar
  • Identifying operators
  • The BODMAS principle

 

Popular Formulas

 

  • Using SUM
  • Using MIN and MAX to extract the highest and lowest values
  • Using AVERAGE
  • Using COUNT and COUNTA to count cells
  • Using AutoSum and AutoFill

 

Formulas to Manipulate Text

 

  • Using LEN to count the number of characters in a ell
  • Using TRIM to remove any spaces
  • Using RIGHT, LEFT and MID to return a specified number of characters from a text string
  • Using CONCATENATE to combine data into one cell
  • Using Flash Fill

 

Lookup Formulas

 

  • Using VLOOKUP and HLOOKUP to lookup data in a table
  • Use the TRANSPOSE feature
  • Using INDEX MATCH

 

IF Statements

 

  • Using IF statements
  • Using SUMIF and COUNTIF

 

Technical Details

 

  • This training is suitable for Excel 2010/2013/2016 users
  • A basic understanding of Microsoft Excel is useful for this class

 

Click The Register Now Button to See Available Times

 

register-button-png-16[/vc_column_text][/vc_column][/vc_row]