Ultimate Microsoft Excel With Data Analysis & VBA Macros

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

Excel Data Analysis - Learn Advanced Techniques for Cleaning, Organizing, Manipulating and Visualization Your Data.

1 - Module 1 Introduction to Microsoft Excel

1 - Overview of Excel Interface and Navigation

2 - Understanding Worksheets Rows Columns and Cells

3 - Entering and Editing Data Efficiently

2 - Module 2 Basic Formatting and Cell Management

4 - Applying Cell Styles and Themes

5 - Merging and Splitting Cells

6 - Managing Rows Columns and Worksheets

3 - Module 3 Basic Formulas and Functions

7 - Introduction to Excel functions SUM AVERAGE MAX MIN

8 - Writing Basic Formulas for Calculations

9 - Absolute and Relative Cell References

10 - Using AutoSum and AutoFill for Efficiency

4 - Module 4 Intermediate Functions and Formula Techniques

11 - Utilizing Logical Functions IF AND OR

12 - Performing Text Manipulation with Functions CONCATENATE LEFT RIGHT MID

13 - Working with Date and Time Functions

5 - Module 5 Data Management and Analysis

14 - Introduction to Excel Tables for Structured Data Management

15 - Sorting and Filtering Data

16 - Using Data Validation to Control Input

17 - Removing Duplicates and Cleaning Data

18 - Using Sparkline for Quick Data Visualization

6 - Module 6 Charts and Graphs

19 - Creating and Customizing Charts bar line pie etc

20 - Adding Titles Labels and Legends to Charts

21 - Formatting Chart Elements for Clarity and Aesthetics

7 - Module 7 PivotTables and Pivot Charts

22 - Understanding PivotTables and Pivot Charts

23 - Creating PivotTables to Analyze and Summarize Data

24 - Modifying PivotTable Layout and Appearance

25 - Creating Dynamic Reports with Pivot Charts

8 - Module 8 Advanced Data Analysis

26 - Utilizing Advanced Functions VLOOKUP HLOOKUP INDEX MATCH

27 - Performing Statistical Analysis with Functions COUNTIF SUMIF AVERAGEIF

28 - Working with Array Formulas for Complex Calculations

9 - Module 9 Advanced Charting Techniques

29 - Creating Combination Charts and DualAxis Charts

30 - Adding Trendlines and Error Bars to Charts

31 - Creating Dynamic Charts with Form Controls

32 - Using Advanced Charting Features for Data Visualization

10 - Module 10 Data Visualization and Dashboards

33 - Designing Interactive Dashboards Using Excel Features

34 - Incorporating Slicers and Timelines for Data Filtering

35 - Linking Data Between Multiple Sheets and Workbooks

36 - Best Practices for Creating Effective Dashboards

11 - Module 11 Macros and Automation

37 - Introduction to Excel Macros and VBA Visual Basic for Applications

38 - Editing and Debugging Macros Using the Visual Basic Editor

39 - Customizing the Ribbon and Adding Macro Buttons

“Applied Houdini Rigids 6” به سبد خرید شما اضافه شد. مشاهده سبد خرید

139,000 تومان

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

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

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

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