Microsoft Excel – Advanced Formulas & Functions with GenAI

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

1 - Introduction

1 -Introduction

2 - Fundamentals of Excel Functions and Formulas

1 -Environment and Inserting our First Formula

2 -Inserting our First Function

3 -Formula Referencing - Relative Referencing

4 -Formula Referencing - Fixed Referencing

5 -Named Ranges

3 - Basic Aggregation formulas

1 -SUM and Practicing Sum

2 -Practicing SUM on business use cases

3 -Introduction to AVERAGE

4 -Practicing AVERAGE on business use cases

5 -Introduction to COUNT and COUNTA

6 -Practicing COUNT and COUNTA on business use cases

7 -Limitations of COUNT and COUNTA functions

8 -Introduction to MAX and MIN functions

9 -Practicing MAX and MIN on business use cases

4 - Office 365 Functions

1 -Unique Function and its use cases

2 -TOCOL function and its use cases

3 -TOROW Function and its use cases

5 - Advanced Logical Aggregations with IF, IFS and IFS family of formulas

1 -Introduction to SUMIF function

2 -SUMIF with WILDCARDS

3 -Introduction to AVERAGEIF formula

4 -Introduction to IFS and SUMIFS Functions

5 -SUMIFS with WILDCARDS

6 -AVERAGEIFS and COUNTIFS

6 - Basic DATE and TIME Functions

1 -Introduction to TODAY function

2 -Introduction to DAY function

3 -Introduction to MONTH function

4 -Introduction to YEAR function

5 -Introduction to TIME functions

6 -Introduction to DAYS function

7 -Introduction to NETWORKDAYS

8 -Introduction to NETWORKDAYS INTL

7 - Advanced TEXT functions

1 -Extracting Numbers from Date information using TEXT function

2 -Extract month info using TEXT function

3 -Extracting AM or PM from timestamp using TEXT function

4 -Some more basic use cases of TEXT function

5 -Another Advanced text function - SUBSTITUTE

6 -Another advanced text function - REPLACE

7 -SWITCH function for managing dynamic logical changes

8 - Doing analysis of orders table with Excel functions and formulas + GenAI

1 -Find out many orders were placed each hour

1 -Orders Table.xlsx

1 - Dataset for Practice Download.html

2 -Find out the distribution of order channels by hour

9 - Conclusion

1 -Conclusion

139,000 تومان

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

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

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

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