Microsoft Excel Formulas & Functions in Depth

Introduction
Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis, reporting, tools and applications are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.

How participants will benefit after the course:
HANDS ON EXPERIENCES. Most widely practiced Excel topics are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the required Excel functionalities in course will ensure participants high performance in their career and academics.

Methodology
PRACTICAL EXAMPLES, EXCERCISES & CASE STUDIES WITH Q&A DISCUSSION SESSIONS. The course is designed for practical Excel applications at participants’ works rather than theoretical notes. Theoretical notes will be provided for participants’ after course usage. Participants will go through with many examples that they can relate to their office or educational works.
Contents of Training:

BREAKING THE EXCEL FEAR
Formula and Functions
Using Formula Bar for writing formulas Entering formulas directly in cells Using the Insert Function dialogue box Finding the appropriate function for a task Understanding Function TOOLTIP Architecture
Functions (Math and Statistics)
Adding all numbers in a range using SUM Function
Counting total numbers or texts with COUNT-COUNTA function
Finding smallest and largest values with MIN- MAX function
Finding Nth smallest and largest values
Summing data with multi conditions and criteria using SUMIF-SUMIFS
Rounding decimal numbers
Average or Mean of numbers with AVERAGE function

Functions (Text and String)
Convert texts to UPPER, LOWER or PROPER case
Technique to add NEW LINEs in cells that have formulas inside
Join multiple cell values with CONCATENATE – &
Break or extract a portion of text with LEFT-MID-RIGHT function
Search for a portion of text with FIND-SEARCH
Converting text to numbers quickly

Functions (Logical)
IF function to show certain results if specific conditions are met with
Nested IFs with multiple If-Else conditions and criteria
Join multiple criteria with logical AND-OR-NOT

Functions (Lookup)
Lookup vertically using VLOOKUP
Powerful partial VLOOKUP instead of Nested IF
Advanced Lookup using INDEX- MATCH function

Functions (Finance)
Calculate Future value of an investment with FV function
Calculate Present value of an investment with PV function

Functions (Date/Time)
Construct a Date from partial Day, Month and Year values
Construct a Date from a text format
Automatically update and show today’s Date
Automatically show present Time
Calculate Addition and Difference between two Dates
Calculate Birthday age by Year, Month and Day
Find the latest and oldest date from a date list
Understanding Excel Time formatting architecture
Calculate Addition and Difference between two Times