What you'll learn

How to use 50+ everyday excel functions

How to combine multiple functions in Excel easily

Using Aggregate functions in excel

Using Text functions such as LEFT, CONCATENATE, TEXTJOIN etc

Using Date functions such as EOMONTH, EDATE, DATEDIF etc

Using Lookup functions such as VLOOKUP, XLOOKUP, INDEX&MATCH

Using Maths and Stats functions such as SUMIF, COUNTIF, AVERAGEIF etc

Using Logical functions such as IF, AND, OR etc

Requirements

Familiarity with basic excel

Microsoft Excel for Windows

Description

This excel course is taught by Ahmed Oyelowo, who is a 4 time Microsoft MVP, Microsoft Certified Trainer since 2018 and also a Microsoft Office Specialist (Excel Expert).In this course, you will learn, with practical examples, how to use over 50 everyday Excel functions.You will also be learning an easy way of combining multiple Excel functions inside a single Excel formula.The course comes with 2 sets of Excel Workbook files.One used by the instructor which you should use to follow along in the lessons andThe other one for your own practice. The practice file will automatically mark you once you have completed the exercises in there.You will also learn the logic of Cell Referencing, which is the back bone of writing accurate formulas when you need to replicate formulas across multiple cells in Excel.What functions will you learn in this course?Aggregate functions in ExcelSUMAVERAGECOUNTCOUNTALARGESMALLMINMAXText functions in ExcelLEFTRIGHTMIDFINDSEARCHLENUPPERLOWERCONCATENATECONCATTEXTJOINDate functions in ExcelDATEDAYMONTHYEAREDATEEOMONTHNETWORKDAYSNETWORKDAYS.INTLWEEKNUMWEEKDAYDATEDIFData Analysis Function in ExcelCOUNTIFSUMIFCOUNTIFSAVERAGEIFSUMIFSLOGICAL Functions in ExcelIFANDORLookup functions in ExcelVLOOKUPXLOOKUPMATCHINDEX