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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 41257
    حجم: 2159 مگابایت
    مدت زمان: 258 دقیقه
    تاریخ انتشار: 15 آبان 1403
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید