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
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
Who this course is for:
- Excel users and people learning Excel
How to Get this course FREE?
Get a 100% Discount On Udemy Paid Courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Apply this Coupon: C146E9324DDC400C4F04 (For 100% Discount)
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course 100% Free. After that, you will get this course at a discounted price. (Still, It’s a good deal for you to get this course at a discounted price).
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase. Read our disclosure.
