Become an Expert in Excel & Google Sheet Formula & Functions

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

Master key formulas and functions in Excel and Google Sheets for better data insights and faster workflows.

1 - Introduction to Microsoft Excel & Google Sheet

1 -Understanding Formulas and Functions

2 - Microsoft Excel

1 -Basic Arithmetic Operations

2 -Writing and Editing Formulas

3 -Using Cell References Relative, Absolute, Mixed

4 -SUM, AVERAGE, MIN, MAX

5 -COUNT and COUNTA Functions

6 -IF Function and Conditional Logic

7 -CONCATENATE and TEXTJOIN Functions

8 -LEFT, RIGHT, MID Functions

9 -DATE, TODAY, and NOW Functions

10 -Formatting Dates and Times

11 -VLOOKUP and HLOOKUP Functions

12 -INDEX and MATCH Functions

13 -Using Named Ranges for Enhanced Readability

14 -SUMIF, SUMIFS, COUNTIF, COUNTIFS

15 -Statistical Analysis with Functions MEDIAN, MODE, STDEV, etc

16 -Analyzing Data Distributions and Variability

17 -Nested Functions and Formula Nesting

18 -Array Formulas for Complex Calculations

19 -Financial Functions PV, FV, NPV, IRR

20 -Summarizing Data with PivotTables

21 -Filtering and Analyzing Data with Slicers

22 -Introduction to Power Query for Data Transformation

23 -Integrating Power Query Results with Excel Functions

24 -Formula Auditing and Error Handling

25 -Using Trace Precedents and Dependents

26 -Error Checking and Correction Techniques

27 -Optimizing Formulas for Performance

28 -Using Excels Formula AutoComplete Feature

29 -Utilizing Keyboard Shortcuts for Formula Writing

30 -Customizing Excels Calculation Options

3 - Google Sheet

1 -Math Functions (SUM, AVERAGE, MAX, MIN, COUNT )

2 -Logical Functions (AND, OR IF)

3 -Text Functions (LOWER, UPPER, CONCATENATE, PROPER)

4 -Left and Right (LEFT, RIGHT)

5 -Line, Area, Bar & Pie Charts in Google Sheets

6 -VLOOKUP & HLOOKUP

7 -XLOOKUP

8 -Data Import (Web and HTML Table)

9 -Macros

139,000 تومان

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

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

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

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