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

189,000 تومان

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

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

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

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