Excel for Business: Analyzing Sales Data

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

Master Data Analysis: Sales Insights and Decision-Making with Advanced Formulas, Charts, Pivot Tables, and Visualization

1. Introduction to the Sales Data

1.1 Data.xlsx

1.2 Overview of the sales data and its structure.pptx

1. Overview of the sales data and its structure

2.1 Exploring the data using basic Excel functions.pptx

2. Exploring the data using basic Excel functions

3.1 Creating basic charts to visualize the data.pptx

3. Creating basic charts to visualize the data

2. Data Filtering and Sorting

1.1 Using filters to extract specific data from the table.pptx

1. Using filters to extract specific data from the table

2.1 Sorting the data by various criteria.pptx

2. Sorting the data by various criteria

3. PivotTables

1.1 Introduction to Pivot Tables.pptx

1. Introduction to PivotTables

2. Creating PivotTables to analyze sales data

3.1 Section 3 Solutions.xlsx

3. Using PivotCharts to visualize PivotTable data

4. Advanced Formulas and Functions

1.1 Data - 2.xlsx

1.2 Removing Duplicates.pptx

1. Removing duplicates

2.1 Using Data validation to ensure data entered is accurate.pptx

2. Using Data validation to ensure data entered is accurate

3.1 Using Data validation to ensure data entered is accurate.pptx

3. Using advanced Excel formulas

4.1 Using conditional formatting to highlight important data points.pptx

4. Using conditional formatting to highlight important data points

5. Dashboards

1.1 Data - Dashboard.xlsx

1. Introduction to Dashboards

2. Setting Up A Dashboard

3. Creating the Dashboard Charts

4. Creating the Dashboard Tables

5.1 Section 5 Solution.xlsx

5. Finishing the Dashboard Slicers and Timeline

6.1 Bonus Material.pptx

6. Bonus Lecture.html

189,000 تومان

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

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

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

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