How to use advanced Microsoft Excel Functions, Filtering and Conditional Formating

In this lesson we are going to achieved the following targets enumerated below

• Evaluating single condition using “IF” function
• Evaluating multiple conditions using “AND” function
• Calculating different series outcomes by nesting the “IF” function
• Testing whether one or more of you r conditions are true with “OR” function
• Returning values from table with "VLOOKUP" Excel Function
• Duplicate checkup using conditional formatting
• Checking Excel data for entry errors using “IFERROR” function
• Summarize Excel data using “COUNTIF, SUMIF and AVERAGEIFS” functions
• Using advanced filters
• Summarize Excel data using the Database functions.