Important Functions with Microsoft Excel

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

Learn what some of the most popular and powerful functions are in Microsoft Excel, as well as how and when to use them.

1. Introduction

1. Welcome

2. Course Introduction

2. Date and Time Functions

1. Functions NOW and TODAY

2. Functions DAY, MONTH, YEAR and DATE

3. Functions HOUR, MINUTE, SECOND and TIME

4. Functions NETWORKDAYS and WORKDAY

5. Functions WEEKDAY and WEEKNUM

3. Engineering Functions

1. Functions CONVERT

4. Logical and Information Functions

1. Functions ISBLANK, ISERROR, ISNUMBER, ISTEXT, ISBLANK, ISFORMULA, ISODD, ISEVEN

2. Functions AND, OR and NOT

3. Functions IF and IFS

4. Functions IFERROR

5. Lookup and Reference Functions

1. Functions VLOOKUP and HLOOKUP

2. Functions INDEX and MATCH

3. Functions ROW, COLUMN, ROWS and COLUMNS

4. Functions HYPERLINK

5. Functions TRANSPOSE

6. Statistical Functions

1. Functions COUNT, COUNTA and COUNTBLANK

2. Functions COUNTIF and COUNTIFS

3. Functions SUM, SUMIF and SUMIFS

4. Functions AVERAGE, AVERAGEIF and AVERAGEIFS

5. Functions MIN, MAX, LARGE and SMALL

6. Functions MINIFS and MAXIFS

7. Functions MODE

8. Functions RANK

7. Mathematical Functions

1. Functions RAND and RANDBETWEEN

2. Functions ROUND, ROUNDUP, ROUNDDOWN and INT

3. Functions MROUND, CEILING.MATH and FLOOR.MATH

4. Functions MOD

5. Functions SUBTOTAL and AGGRETATE

8. Functions Text Functions

1. Functions LEFT, RIGHT, MID and LEN

2. Functions FIND and SEARCH

3. Functions REPLACE and SUBSTITUTE

4. Functions TRIM and CLEAN

5. Functions CONCAT and TEXTJOIN

6. Functions UPPER, LOWER and PROPER

7. Functions TEXT

9. BONUS Section

1. BONUS Lecture

45,900 تومان

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

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

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

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