Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas
What you will 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
Description
Hello and welcome to our course on Excel formulae, Conditional Formatting, and Tables.Β All Excel users who want to advance their knowledge and abilities should attend this course.
Your productivity will rise as a result of this course as you become more adept at using tables, conditional formatting, and formulae in your Excel spreadsheets.Β The course is provided in a straightforward, step by step manner.Β Additionally, the course includes exercises that will allow you to put the abilities you have learned to use.
WHAT STUDENTS ARE SAYING:
- “This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course.”
- “Excellent, efficient and informative course. The exercises after each set of videos was particularly useful.”
- “I found the course very informative. I am pretty good with excel but I learned quite a few tips and tricks that I can implement.”
You will gain a thorough understanding of the following during the course:
Formulas
- Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS
- Learn a range of Date formulas such as Year, Month, Weekday, NetWorkDays, and WorkDay
- Learn Text formulas such as LEFT, MID, RIGHT, and TRIM
- Learn to use the IF formula to create powerful ‘IF Then’ logic
- Learn the HLOOKUP and VLOOKUP
Content