Mastering Microsoft Excel Formulas | Udemy


Mastering Microsoft Excel Formulas | Udemy [Update 01/2024]
English | Size: 1.7 GB
Genre: eLearning

Advance your Excel knowledge with Excel formulas

What you’ll learn
How to use 50+ everyday excel functions
How to combine multiple functions in Excel easily
Using Aggregate functions in excel
Using Text functions such as LEFT, CONCATENATE, TEXTJOIN etc
Using Date functions such as EOMONTH, EDATE, DATEDIF etc
Using Lookup functions such as VLOOKUP, XLOOKUP, INDEX&MATCH
Using Maths and Stats functions such as SUMIF, COUNTIF, AVERAGEIF etc
Using Logical functions such as IF, AND, OR etc

This excel course is taught by Ahmed Oyelowo, who is a 5-time Microsoft MVP, Microsoft Certified Trainer since 2018 and also a Microsoft Office Specialist (Excel Expert).

In this course, you will learn, with practical examples, how to use over 50 everyday Excel functions.

You will also be learning an easy way of combining multiple Excel functions inside a single Excel formula.

The course comes with 2 sets of Excel Workbook files.

  1. One used by the instructor which you should use to follow along in the lessons and
  2. The other one for your own practice. The practice file will automatically mark you once you have completed the exercises in there.

You will also learn the logic of Cell Referencing, which is the back bone of writing accurate formulas when you need to replicate formulas across multiple cells in Excel.

What functions will you learn in this course?

  1. Aggregate functions in Excel
    1. SUM
    2. AVERAGE
    3. COUNT
    4. COUNTA
    5. LARGE
    6. SMALL
    7. MIN
    8. MAX
  2. Text functions in Excel
    1. LEFT
    2. RIGHT
    3. MID
    4. FIND
    5. SEARCH
    6. LEN
    7. UPPER
    8. LOWER
    9. CONCATENATE
    10. CONCAT
    11. TEXTJOIN
  3. Date functions in Excel
    1. DATE
    2. DAY
    3. MONTH
    4. YEAR
    5. EDATE
    6. EOMONTH
    7. NETWORKDAYS
    8. NETWORKDAYS.INTL
    9. WEEKNUM
    10. WEEKDAY
    11. DATEDIF
  4. Data Analysis Function in Excel
    1. COUNTIF
    2. SUMIF
    3. COUNTIFS
    4. AVERAGEIF
    5. SUMIFS
  5. LOGICAL Functions in Excel
    1. IF
    2. AND
    3. OR
  6. Lookup functions in Excel
    1. VLOOKUP
    2. XLOOKUP
    3. MATCH
    4. INDEX

Who this course is for:

  • This course is for all category of excel learners.
  • Looking to advance your excel knowledge beyond the basics
  • Looking to start or upskill yourself in data analytics
DOWNLOAD FROM RAPIDGATOR

rapidgator.net/file/558e991065c757bcec0a692852147e8a/UD-MasteringMicrosoftExcelFormulas2024-1.part1.rar.html
rapidgator.net/file/e6296d97d75bf4e09e55ac3877880334/UD-MasteringMicrosoftExcelFormulas2024-1.part2.rar.html
rapidgator.net/file/c112c65b56dbbcd2506b4ec591929cc7/UD-MasteringMicrosoftExcelFormulas2024-1.part3.rar.html
rapidgator.net/file/60a551736cde663c428e8c1df6a85e39/UD-MasteringMicrosoftExcelFormulas2024-1.part4.rar.html
rapidgator.net/file/877a8bc69949520afb2cef57a172cc18/UD-MasteringMicrosoftExcelFormulas2024-1.part5.rar.html
rapidgator.net/file/85cc3a9079ccf03a5e7d4480fcae09b0/UD-MasteringMicrosoftExcelFormulas2024-1.part6.rar.html

DOWNLOAD FROM TURBOBIT

tbit.to/oghxj6of2669/UD-MasteringMicrosoftExcelFormulas2024-1.part1.rar.html
tbit.to/twnzmg93chy4/UD-MasteringMicrosoftExcelFormulas2024-1.part2.rar.html
tbit.to/1splj1mvykal/UD-MasteringMicrosoftExcelFormulas2024-1.part3.rar.html
tbit.to/stc0p57zc765/UD-MasteringMicrosoftExcelFormulas2024-1.part4.rar.html
tbit.to/v6graeaojclu/UD-MasteringMicrosoftExcelFormulas2024-1.part5.rar.html
tbit.to/qhjtjkountgg/UD-MasteringMicrosoftExcelFormulas2024-1.part6.rar.html

DOWNLOAD FROM NITROFLARE

nitroflare.com/view/1AB34F5425C6B7B/UD-MasteringMicrosoftExcelFormulas2024-1.part1.rar
nitroflare.com/view/17F183968E94E1C/UD-MasteringMicrosoftExcelFormulas2024-1.part2.rar
nitroflare.com/view/923D469AD4CCBD3/UD-MasteringMicrosoftExcelFormulas2024-1.part3.rar
nitroflare.com/view/F0B04B521AE8491/UD-MasteringMicrosoftExcelFormulas2024-1.part4.rar
nitroflare.com/view/C29B08CCB74395F/UD-MasteringMicrosoftExcelFormulas2024-1.part5.rar
nitroflare.com/view/718284754C640EB/UD-MasteringMicrosoftExcelFormulas2024-1.part6.rar

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.