Microsoft Excel Data Analysis with Formulas and VBA

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

Microsoft Excel Data Analysis with Formulas and VBA. Learn Mastering Excel Data Analysis and Visualization.

1 - Module 1 Introduction to Advanced Functions and Formulas

1 - Overview of Advanced Excel Functions and Formulas

2 - Benefits of Using Advanced Functions in Data Analysis

2 - Module 2 Advanced Lookup and Reference Functions

3 - Using INDEX and MATCH Functions for Flexible Data Retrieval

4 - Understanding the OFFSET Function for Dynamic Range Selection

3 - Module 3 Text Manipulation and Analysis Functions

5 - Concatenating Text Strings Using CONCATENATE and CONCAT Functions

6 - Splitting Text Strings with the TEXTJOIN and SPLIT Functions

7 - Extracting Substrings with the LEFT RIGHT and MID Functions

4 - Module 4 Date and Time Functions

8 - Working with Date and Time Values in Excel

9 - Calculating Time Differences and Durations

10 - Using Date and Time Functions for Data Analysis and Reporting

5 - Module 5 Logical Functions

11 - Understanding Logical Operators

12 - Using IF AND OR and NOT Functions for DecisionMaking

13 - Applying Logical Functions in Data Filtering and Validation

6 - Module 6 Financial Functions

14 - Overview of Common Financial Functions

15 - Calculating Present and Future Values Loan Payments and Interest Rates

16 - Using Financial Functions for Investment Analysis and Financial Modeling

7 - Module 7 Introduction to Visual Basic for Applications VBA

17 - Understanding the Basics of VBA Programming

18 - Creating Custom Functions Using VBA

19 - Automating Repetitive Tasks with VBA Macros

8 - Module 8 Advanced Excel Tips and Tricks

20 - Efficiency Tips for Working with Large Datasets

21 - Data Validation Techniques for Ensuring Data Integrity

22 - Troubleshooting Common Errors in Excel Formulas

179,000 تومان

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

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

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

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