Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas
What you'll learn
- Use Date formulas to calculate time / date intelligence
- Use Text formulas to manipulate text entries
- Learn to use Data Bars, Color Scales and Icons in Spreadsheets
- Use the SUMIF, COUNTIF and AVERAGEIF functions to easily calculate filtered data
- Easily aggregate data in Tables using Sum, Count, Average, Max and Min
- Use Conditional Formatting to highlight data according to a range of conditions
- Easily create, manage and filter tables to answer key questions of your data
- Learn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilities