Tags
Language
Tags
July 2025
Su Mo Tu We Th Fr Sa
29 30 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Microsoft Excel : Top 25 Formulas In Excel You Should Know

    Posted By: ELK1nG
    Microsoft Excel : Top 25 Formulas In Excel You Should Know

    Microsoft Excel : Top 25 Formulas In Excel You Should Know
    Published 10/2023
    MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
    Language: English | Size: 157.04 MB | Duration: 0h 34m

    Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas

    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

    Requirements

    Users should be familiar with Excel and entering data into Excel

    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:FormulasLearn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFSLearn a range of Date formulas such as Year, Month, Weekday, NetWorkDays, and WorkDayLearn Text formulas such as LEFT, MID, RIGHT, and TRIMLearn to use the IF formula to create powerful 'IF Then' logicLearn the HLOOKUP and VLOOKUP

    Overview

    Section 1: About the instructor

    Lecture 1 About the instructor

    Section 2: Introduction

    Lecture 2 Introduction

    Section 3: What is Excel Formula?

    Lecture 3 What is Excel Formula?

    Section 4: Formulas in Excel: An Overview

    Lecture 4 Formulas in Excel: An Overview

    Lecture 5 Overview 2

    Section 5: Top 25 Formulas in Excel You Should Know

    Lecture 6 1. SUM

    Lecture 7 2. AVERAGE

    Lecture 8 3. COUNT

    Lecture 9 4. SUBTOTAL

    Lecture 10 5. MODULUS

    Lecture 11 6. POWER

    Lecture 12 7. CEILING

    Lecture 13 8. FLOOR

    Lecture 14 9. CONCATENATE

    Lecture 15 10. LEN

    Lecture 16 11. REPLACE

    Lecture 17 12. SUBSTITUTE

    Lecture 18 13. LEFT, RIGHT, MID

    Lecture 19 14. UPPER, LOWER, PROPER

    Lecture 20 15. NOW()

    Lecture 21 16. TODAY()

    Lecture 22 17. TIME()

    Lecture 23 18. HOUR, MINUTE, SECOND

    Lecture 24 19. DATEDIF

    Lecture 25 20. VLOOKUP

    Lecture 26 21. HLOOKUP

    Lecture 27 22. IF Formula

    Lecture 28 23. INDEX-MATCH

    Lecture 29 24. COUNTIF

    Lecture 30 25. SUMIF

    Section 6: Tips

    Lecture 31 Tip 1

    Lecture 32 Tip 2

    Lecture 33 Tip 3

    Lecture 34 Tip 4

    Lecture 35 Tip 5

    Lecture 36 Tip 6

    Lecture 37 Tip 7

    Lecture 38 Tip 8

    Lecture 39 Tip 9

    Lecture 40 Tip 10

    Section 7: 7 Rules to performance Excel

    Lecture 41 Introduction

    Lecture 42 Rule 1

    Lecture 43 Rule 2

    Lecture 44 Rule 3

    Lecture 45 Rule 4

    Lecture 46 Rule 5

    Lecture 47 Rule 6

    Lecture 48 Rule 7

    Section 8: Conclusion

    Lecture 49 Conclusion

    Excel users and people learning Excel