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

179,000 تومان

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

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

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

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