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 تومان

افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: Udemy