Tables and Formulas with Excel
Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas
4.58 (3280 reviews)
11,120
students
3.5 hours
content
Sep 2023
last update
$74.99
regular price
What you will learn
Easily create, manage and filter tables to answer key questions of your data
Learn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilities
Easily aggregate data in Tables using Sum, Count, Average, Max and Min
Use Conditional Formatting to highlight data according to a range of conditions
Learn to use Data Bars, Color Scales and Icons in Spreadsheets
Use the SUMIF, COUNTIF and AVERAGEIF functions to easily calculate filtered data
Use Date formulas to calculate time / date intelligence
Use Text formulas to manipulate text entries
Screenshots
Related Topics
474102
udemy ID
4/12/2015
course created date
11/6/2019
course indexed date
Bot
course submited by