This is a fast track excel training on formulas & with combination formulas as one formula to get the desired value and its all about in 3 hours.

Topics Covered

ROWS, COLUMNS References & Freezing references Round function RoundUp RoundDown IF Conditions Nested IF Combination of IF & Round Functions [Industry Example(s)] MATCH INDEX OFFSET IFERROR, ISERROR SMALL & LARGE Text Function (Format) Clean Function Concatenate Function Find Function Left/Right Function Mid Function REPT function Trim Function Upper/Lower/Proper Functions Workday Net workdays Weekdays Hour/Minute/Second Function VLOOKUP (Powerful formula) HLOOKUP Combination IF & Vlookup COUNTIF Sum if function Excel Challenge/Quiz

Who should attend

Anyone who has a passion towards excel usage & wants to learn new formulas & Challenges on excel. And its like a brush of the users who attend for trainings

Pre-requisites

Should have knowledge on excel basics and should have internet access to get trained

What you need to bring

Nothing

Key Takeaways

Understanding Excel Formulas Ability to handle some excel queries Knowledge of Excel Tips & Tricks