In this popular Free Excel Formulas & Functions Webinar Training which goes for 60 minutes you will learn the MUST KNOW Excel Formulas to ADVANCE your Excel skills!

You will learn the following Excel Formulas & Functions: IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE…!

Plus we will teach you:

  • The most popular Excel Formulas that get asked during interviews & ones that you NEED to know!
  • A proven step by step guide to creating Excel Formulas in SECONDS!
  • The limitations of using a VLOOKUP and why INDEX&MATCH is better!
  • 3 TIPS that the Excel experts & MVPS use that will enhance your Formula knowledge!
  • You will receive a BONUS Excel Formulas Cheat Sheet and also  download the Excel workbook used in the training so you can follow along & practice!

 

The times are shown on your local timezone, so please click the link below to register for a day and time that works for you…

REGISTER FOR THIS FREE WEBINAR

free excel formuls training

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

IFERROR Function: Introduction If you have a calculation that results in an error like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, then you can clean it up by using the IFERROR function which allows you to replace the error it with a 0 or a blank cell.I show you both IFERROR examples below.DOWNLOAD ...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...
Calculate Elapsed Time in Excel When you have two points in time and you want to calculate the amount of time elapsed, then you will need to use Excel´s TEXT functionSometimes data gets dumped into Excel with the following date & time format:24/01/2015  19:48:00.Using the TEXT function and enter...
Index Match 2 Criteria with Data Validation We can use the INDEX-MATCH formula and combine it with Data Validation drop down menus to return a value based on 2 criteria.This is a little advanced so you will need to drop what you are doing and really focus.  Let's go...First we need to convert our data into an Excel...