وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Mastering Microsoft Excel Formulas and Functions

سرفصل های دوره

Excel Formulas Unleashed: Master Excel Functions for Data Mastery; includes an introduction to using ChatGPT with Excel


1. Excel Formulas and Functions Course Introduction
  • 1. Microsoft Excel Formulas and Functions Course Introduction
  • 2. Microsoft Excel Exercise File (DOWNLOAD)
  • 3. Participate in the Course QA
  • 4. Course Announcements
  • 5. Microsoft Excel Formulas and Functions Course Certificate

  • 2. Introduction to Excel Formulas and Functions
  • 1.1 01-IntroExcelFormulasFunctions.xlsx
  • 2. Overview of Excels Formula Syntax
  • 3. Basic Arithmetic Operations
  • 4. Introduction to Mathematical Order of Operations
  • 5. Mathematical Order of Operations
  • 6. Introduction to Cell References (Relative, Absolute, Mixed)
  • 7. Relative Cell References
  • 8. TIP - Excel AutoFill to Copy Formulas
  • 9. Absolute Cell References
  • 10. Absolute versus Constant Values
  • 11. Mixed Cell References
  • 12. TIP - Absolute Reference Shortcut Key
  • 13. Introduction to Basic Excel Function Syntax
  • 14. QUIZ 01 - Introduction to Excel Formulas and Functions.html

  • 3. Microsoft Excel Mathematical Functions
  • 1.1 02-ExcelMathematicalFunctions.xlsx
  • 2. Microsoft Excel SUM() Function
  • 3. TIP - Microsoft Excel SUM() Function Shortcut Key
  • 4. Microsoft Excel AVERAGE() Function
  • 5. TIP - Shortcut Keys to Select Formula Cell References
  • 6. Microsoft Excel PRODUCT() Function
  • 7. Microsoft Excel MOD() Function
  • 8. Microsoft Excel ROUND() Function
  • 9. TIP - Round to the Nearest
  • 10. Microsoft Excel ROUNDUP() Function
  • 11. Microsoft Excel ROUNDDOWN() Function
  • 12.1 02-PracticeMathematicalFunctions.xlsx
  • 12. EXERCISE 02 - Microsoft Excel Mathematical Functions.html
  • 13. QUIZ 02 - Microsoft Excel Mathematical Functions.html

  • 4. Nesting Microsoft Excel Functions
  • 1.1 03-ExcelNestingFunctions.xlsx
  • 2. Introduction to Nesting Excel Functions
  • 3. Nesting Microsoft Excel Functions Practice
  • 4. TIP - Switching Between Nested Excel Function Arguements
  • 5.1 03-ExcelNestingFunctions.xlsx
  • 5. EXERCISE 03 - Nesting Excel Functions.html
  • 6. QUIZ 03 - Nesting Excel Functions.html

  • 5. Microsoft Excel Text Functions
  • 1.1 04-ExcelTextFunctions.xlsx
  • 2. Microsoft Excel CONCAT Function
  • 3. Microsoft Excel TEXT() Function
  • 4. Microsoft Excel LEN() Function
  • 5. Microsoft Excel SEARCH() Function
  • 6. Microsoft Excel LEFT() Function
  • 7. Microsoft Excel RIGHT() Function
  • 8. Microsoft Excel MID() Function
  • 9. Microsoft Excel TRIM() Function
  • 10. Microsoft Excel PROPER() Function
  • 11. Microsoft Excel UPPER() Function
  • 12. Microsoft Excel LOWER() Function
  • 13. Microsoft Excel SUBSTITUTE() Function
  • 14. Nesting Microsoft Excel TRIM & PROPER Functions
  • 15. Nesting Microsoft Excel SEARCH Function
  • 16.1 04-PracticeExcelTextFunctions.xlsx
  • 16. EXERCISE 04 - Microsoft Excel Text Functions.html
  • 17. QUIZ 04 - Microsoft Excel Text Functions.html

  • 6. Microsoft Excel Date and Time Functions
  • 1.1 05-ExcelDateTimeFunctions.xlsx
  • 2. Microsoft Excel TODAY() Function
  • 3. Microsoft Excel NOW() Function
  • 4. Formatting Microsoft Excels TODAY() & NOW() Functions
  • 5. Adding Time to the TODAY and NOW() Functions
  • 6. TIP - Date & Time Shortcuts
  • 7. Microsoft Excel DATE() Function
  • 8. Microsoft Excel DAY() Function
  • 9. Microsoft Excel MONTH() Function
  • 10. Microsoft Excel YEAR() Function
  • 11. Microsoft Excel WEEKDAY() Function
  • 12. Microsoft Excel EOMONTH() Function
  • 13. Microsoft Excel WORKDAY() Function
  • 14. Microsoft Excel NETWORKDAYS() Function
  • 15. Microsoft Excel TIME() Function
  • 16. Microsoft Excel HOUR() Function
  • 17. Microsoft Excel MINUTE() Function
  • 18. Microsoft Excel SECOND() Function
  • 19. Nesting Microsoft Excel NETWORKDAYS & EOMONTH Functions
  • 20. Nesting Microsoft Excel TIME Functions
  • 21.1 05-PracticeExcelDataTimeFunctions.xlsx
  • 21. EXERCISE 05 - Microsoft Excel Date and Time Functions.html
  • 22. QUIZ 05 - Microsoft Excel Date and Time Functions.html

  • 7. Microsoft Excel Logical Functions
  • 1.1 06-ExcelLogicalFunctions.xlsx
  • 2. Microsoft Excel IF() Function
  • 3. Microsoft Excel IFS() Function
  • 4. Microsoft Excel AND() Function
  • 5. Microsoft Excel OR() Function
  • 6. Microsoft Excel ISNUMBER() Function
  • 7. Nested IF() Functions
  • 8. Microsoft Excel ISTEXT() Function
  • 9. Nesting Microsoft Excel Logical Functions
  • 10. QUIZ 06- Microsoft Excel Logical Functions.html

  • 8. Microsoft Excel Lookup and Reference Functions
  • 1.1 08-ExcelLookupFunctions.xlsx
  • 2. Microsoft Excel VLOOKUP() Function
  • 3. Microsoft Excel VLOOKUP Function and a Little Math
  • 4. Microsoft Excel HLOOKUP() Function
  • 5. Microsoft Excel INDEX() Function
  • 6. Microsoft Excel MATCH() Function
  • 7. Nesting INDEX() and MATCH() Functions
  • 8. Nesting Microsoft Excel HLOOKUP and MATCH Functions
  • 9. Microsoft Excel INDIRECT() Function
  • 10. Microsoft Excel OFFSET() Function
  • 11. Microsoft Excel XLOOKUP() Function
  • 12. QUIZ 08 - Microsoft Excel Reference Functions.html

  • 9. Microsoft Excel Statistical Functions
  • 1.1 09-ExcelStatisticalFunctions.xlsx
  • 2. Microsoft Excel COUNT() Function
  • 3. Microsoft Excel COUNTA() Function
  • 4. Microsoft Excel MAX() Function
  • 5. Nesting INDEX, MATCH and MAX Functions
  • 6. Microsoft Excel MIN() Function
  • 7. Microsoft Excel AVERAGEIF() Function
  • 8. Microsoft Excel AVERAGEIFS() Function
  • 9. TIP - Microsoft Excel AVERAGEIFS() Function with Numeric Conditions
  • 10. Microsoft Excel SUMIF() Function
  • 11. TIP - Subtotals with an Excel SUMIF() Function
  • 12. Microsoft Excel SUMIFS() Function
  • 13. Microsoft Excel COUNTIF() Function
  • 14. Microsoft Excel COUNTIFS() Function
  • 15. QUIZ 09 - Microsoft Excel Statistical Functions.html

  • 10. Microsoft Excel Database Functions
  • 1.1 10-ExcelDatabaseFunctions.xlsx
  • 2. Microsoft Excel DSUM() Function
  • 3. Microsoft Excel DSUM() Function Multiple Criteria - OR Statement
  • 4. Microsoft Excel DSUM() Function Multiple Criteria - AND Statement
  • 5. Microsoft Excel DAVERAGE() Function
  • 6. Microsoft Excel DCOUNT() Function
  • 7. Microsoft Excel DMIN() Function
  • 8. Microsoft Excel DMAX() Function
  • 9. QUIZ 10 - Microsoft Excel Database Functions.html

  • 11. Microsoft Excel Financial Functions
  • 1.1 11-ExcelFinancialFunctions.xlsx
  • 2. Microsoft Excel PMT() Function
  • 3. Microsoft Excel PV() Function
  • 4. Microsoft Excel FV() Function
  • 5. Microsoft Excel NPV() Function
  • 6. Microsoft Excel IRR() Function
  • 7. QUIZ 11 - Microsoft Excel Financial Functions.html

  • 12. Microsoft Excel Array Formulas
  • 1.1 12-ExcelArrayFunctions.xlsx
  • 2. Understanding Arrays
  • 3. Microsoft Excel SUMPRODUCT() Function
  • 4. Microsoft Excel SUMPRODUCT() with Conditions
  • 5. Microsoft Excel FILTER() Function
  • 6. Microsoft Excel SORT() Function
  • 7. Microsoft Excel GROUPBY() Function
  • 8. Microsoft Excel UNIQUE() Function
  • 9. Microsoft Excel TEXTAFTER() Function
  • 10. Microsoft Excel TEXTBEFORE() Function
  • 11. Microsoft Excel TEXTSPLIT() Function
  • 12. Microsoft Excel TEXTJOIN() Function
  • 13. Microsoft Excel TEXTJOIN() with Condition
  • 14. QUIZ 12 - Microsoft Excel Array Functions.html

  • 13. Introduction to Custom Functions with Microsoft Excel VBA
  • 1.1 14-ExcelCustomVBAFunctions.xlsx
  • 2. Introduction to Custom Microsoft Excel VBA Functions
  • 3. Our Custom VBA Function Overview
  • 4. Microsoft Excel Developer Tab
  • 5. Creating a Custom Microsoft Excel VBA Function
  • 6. Writing the Excel VBA Function Logic
  • 7. Using a Custom Microsoft Excel VBA Function
  • 8. Saving Microsoft Excel Files with VBA Code
  • 9. QUIZ 14 - Microsoft Excel Custom VBA Functions.html

  • 14. Introduction to Using ChatGPT with Microsoft Excel
  • 1.1 15-ExcelChatGPT.xlsx
  • 2. What is ChatGPT
  • 3. Asking ChatGPT Questions
  • 4. Quick Intro to ChatGPTs Interface
  • 5. ChatGPT Excel Scenario 1
  • 6. TIP - Ask Very Specific Questions
  • 7. ChatGPT Excel Scenario 2
  • 8. ChatGPT Excel Scenario 3

  • 15. Microsoft Excel Formulas and Functions Course Conclusion
  • 1. Congratulations on Completing the Microsoft Excel Formulas and Function Course
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 40574
    حجم: 8776 مگابایت
    مدت زمان: 496 دقیقه
    تاریخ انتشار: 1 آبان 1403
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید