Unit 1: Working with TEXT Function Category
• CONCATENATE
• LEFT, RIGHT
• UPPER, LOWER
• LEN
• FIND
• Nested Functions using the Functions listed above
Unit 2: Working with MATH & TRIG Function Category
• SUMIF and SUMIFS
• SUBTOTAL
• ROUND
Unit 3: Working with STATISTICAL Function Category
• COUNTIF and COUNTIFS
• AVERAGE – MEDIAN
• MAXIF, MINIF
• Variance, Standard Deviation
• T.Test, Z.Test
• Nested functions
Unit 4: Conditional Formatting
• Highlighting top and bottom ranks
• Highlighting based on values
• Converging cells into small charts
• Using Color Scales to view the trend
Unit 5: Conditional Formatting with Functions
• Highlight dates where you have a weekend
• Highlight those employees with below average KPIs using Conditional Formatting and Functions
Unit 6: Creating Nested Lists
• The Function INDIRECT
• Combining Data Validation with Functions
Unit 7: Comparing Lists
• Using VLOOKUP
• Nested functions with IF and VLOOKUP
• Automating Calculations with IF and formulae
Unit 8: Finding Duplicates
• Using Conditional Formatting
• Using the Remove Duplicates Tool
• Using function combinations
Unit 9: Importing Data
• Connecting to External Data Sources
• Importing from text files
• Importing csv files
• Using TRIM to spot redundant spaces