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

Excel Mastery | Become a Master At Excel From Start to End

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

Max Excel's Power: Master Data Management and Analysis from Basic to Advanced Levels, Enhanced with ChatGPT Integration


1. 0 Excel Masterclass
  • 1. (PART 1) Basic Excel Introduction
  • 2. (PART 2) Basic Excel Inputting Data
  • 3. (PART 3) Basic Excel Formatting Data
  • 4. (PART 4) Basic Excel Formulas
  • 5. (PART 5) Basic Excel Basic Functions
  • 6. (PART 6) Basic Excel Creating Charts

  • 2. 1 Excel For Beginners Excel 101
  • 1. Module 1 Introduction to Excel
  • 2. Module 2 Essential Excel Functions PART1
  • 3. Module 2 Essential Excel Functions PART2
  • 4. Module 3 Formatting and Styling
  • 5. Module 4 Managing Data
  • 6. Module 5 Working With Charts Graphs
  • 7. Module 6 Data Analysis and Manipulation PART1
  • 8. Module 6 Data Analysis and Manipulation PART2
  • 9. Module 7 Collaboration and Sharing PART1
  • 10. Module 7 Collaboration and Sharing PART2
  • 11. Module 8 Tips and Tricks for Efficiency PART1
  • 12. Module 8 Tips and Tricks for Efficiency PART2
  • 13. Module 9 Advanced Excel Concepts (Optional) PART1
  • 14. Module 9 Advanced Excel Concepts (Optional) PART2
  • 15. Module 9 Advanced Excel Concepts (Optional) PART3
  • 16. Module 10 Final Project and Recap PART1
  • 17.1 FILE MS EXCEL.xlsx
  • 17.2 Final Project.xlsx
  • 17.3 macros file.zip
  • 17.4 Project1.xlsx
  • 17.5 shortcuts.xlsx
  • 17.6 Supplementary Files.xlsx
  • 17.7 VLOOKUP, IF, INDEX MATCH.xlsx
  • 17. Module 10 Final Project and Recap PART2

  • 3. 2 Advanced Excel Techniques Dive deeper into Excels advanced features
  • 1. 1 - Adv Excel Functions
  • 2. 2 - Data Validation Conditional Formatting
  • 3. 3 - Pivot Tables
  • 4.1 Data Validation.xlsx
  • 4.2 Sort Filter.xlsx
  • 4. 4 - Filter and Sort
  • 5. 4 - Filter and Sort part2

  • 4. Section 2 Advanced Charting and Visualization
  • 1. 2.1 - Dynamic and Interactive
  • 2. 2.2 - Advanced Charting Features
  • 3.1 2.2 - Trends.xlsx
  • 3.2 2.3 Data Bars and Heat Map.xlsx
  • 3.3 Dynamic Charts.xlsx
  • 3.4 Interactive Dashboard.xlsx
  • 3. 2.3 - Adv Data Visualization Tech
  • 4. 2.3 - Adv Data Visualization Tech part2

  • 5. Section 3 Automation and Efficiency Techniques
  • 1. 3.1 - Macros and VBA Fundamentals
  • 2. 3.2 - Automated Workflows and Processes
  • 3.1 3.2 macros.zip
  • 3.2 3.3 Nested If.xlsx
  • 3.3 copy of macros file.zip
  • 3. 3.3 - Conditional Logic and Nested Formulas

  • 6. Section 4 Data Analysis Tools
  • 1. 4.1 - Analysis ToolPak for Statistical Analysis
  • 2. 4.2 - What-If Analysis and Scenario Planning
  • 3. 4.3 - Introduction to Power Query
  • 4.1 4.1 Stat.xlsx
  • 4.2 4.2 What if.xlsx
  • 4.3 4.3 CSV.xlsx
  • 4.4 4.4.xlsx
  • 4. 4.4 - Advanced Data Analysis Techniques with Power Pivot
  • 5. 4.4 - Advanced Data Analysis Techniques with Power Pivot part2

  • 7. Section 5 Collaborative and Advanced Excel Features
  • 1. 5.1 - Sharing Workbooks and Collaborating with Others
  • 2. 5.2 - Protecting and Securing Excel Files
  • 3. 5.3 - Customizing Excel with Add-ins and Advanced Settings

  • 8. Section 6 Case Studies and Real-World Applications
  • 1. 6.1 - Applying Advanced Excel Techniques to Real-World Problems
  • 2.1 Project Dataset.xlsx
  • 2. 6.2 - Presenting Findings and Insights with Advanced Excel Features

  • 9. Section 7 Final Project
  • 1. 7.1 - Project Planning and Execution
  • 2.1 7.1.xlsx
  • 2. 7.2 - Project Presentation and Feedback

  • 10. 3 ChatGPT for Excel
  • 1. (PART 1) CHATGPT with EXCELSum, If
  • 2. (PART 2)CHATGPT with EXCEL Left, Right, DatedIf, NetworkDays
  • 3. (PART 3) CHATGPT with EXCEL VLookUp
  • 4. (PART 4) CHATGPT with EXCEL SumIf, CountIf
  • 5. (PART 5) CHATGPT with EXCEL Lets Practice!
  • 6. (Part 6) COMPLEX CHATGPT W EXCEL
  • 7. (Part 7) COMPLEX CHATGPT W EXCEL
  • 8. (Part 8 )Integrate CHATGPT to EXCEL
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 20669
    حجم: 7578 مگابایت
    مدت زمان: 638 دقیقه
    تاریخ انتشار: ۱۵ مهر ۱۴۰۲
    دسته بندی محصول
    طراحی سایت و خدمات سئو

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