• Post category:StudyBullet-17
  • Reading time:6 mins read

Microsoft Excel : Top 25 Formulas in Excel You Should Know
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:


Get Instant Notification of New Courses on our Telegram channel.

Noteβž› Make sure your π”ππžπ¦π² cart has only this course you're going to enroll it now, Remove all other courses from the π”ππžπ¦π² cart before Enrolling!


  • “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
English
language

Content

About the instructor

About the instructor

Introduction

Introduction

What is Excel Formula?

What is Excel Formula?

Formulas in Excel: An Overview

Formulas in Excel: An Overview
Overview 2

Top 25 Formulas in Excel You Should Know

1. SUM
2. AVERAGE
3. COUNT
4. SUBTOTAL
5. MODULUS
6. POWER
7. CEILING
8. FLOOR
9. CONCATENATE
10. LEN
11. REPLACE
12. SUBSTITUTE
13. LEFT, RIGHT, MID
14. UPPER, LOWER, PROPER
15. NOW()
16. TODAY()
17. TIME()
18. HOUR, MINUTE, SECOND
19. DATEDIF
20. VLOOKUP
21. HLOOKUP
22. IF Formula
23. INDEX-MATCH
24. COUNTIF
25. SUMIF

Tips

Tip 1
Tip 2
Tip 3
Tip 4
Tip 5
Tip 6
Tip 7
Tip 8
Tip 9
Tip 10

7 Rules to performance Excel

Introduction
Rule 1
Rule 2
Rule 3
Rule 4
Rule 5
Rule 6
Rule 7

Conclusion

Conclusion