Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas 2023
Sub Category
- Microsoft
{inAds}
Objectives
- 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
- Learn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilities
- Easily create, manage and filter tables to answer key questions of your data
Pre Requisites
- Users should be familiar with Excel and entering data into Excel
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)