Mastering Excel Data Analysis & Dashboard Reporting

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

Unlocking Insights and Visualizing Trends for Informed Decision-Making

1. Course Overview

1. Course Introduction

2. Managing Unprocessed Data

3. Comprehensive Guide to Excel Dashboards

4.1 customer orders1.zip

4. Commencing the Journey

2. Efficient Data Analysis Using Microsoft Excel

1.1 Customer Orders.xlsx

1. Important Section Instructions

2. Working On Text Visuals Through Proper() Function

3. Establish Uniformity Using Excels UPPER() Function

4. Harnessing MS Excels Paste Special Feature

5. Substituting Nonsensical Data with the CHOOSE() Function

6. Utilizing the TEXT() Function for Date Value Extraction

3. Part A - Excel Dashboard Construction Data Lookup

1.1 Customer Orders1.xlsx

1. Customer Information Lookup

2. Data Preparation Formatting as a Table

3. Generating a Dropdown Menu using Data Validation

4. Data Retrieval using Excels VLOOKUP() Function

5. Data Cleansing using Excels IF() Function

6.1 INDEX MATCH.xlsx

6. Exploring INDEX() and MATCH() VLOOKUP() Alternative

4. Part B - Excel Dashboard Construction Data Filtering Techniques

1. Incorporating the Order History Table

2. Converting Orders into a Table Format

3. Exploring Excels Advanced Filter Functionality

4. Creating a Macro for Advanced Filtering

5. Implementing Customer-Triggered Order Record Filtering (VBA)

6. Adjusting the VBA Filter Code

5. Part C - Excel Dashboard Construction SUBTOTALS

1. The Benefits of Utilizing Excels SUBTOTAL() Function

2. Applying the SUBTOTAL() Function in Practice

6. Part D - Excel Dashboard Construction Pivoting Data with Pivot Tables and Chart

1. The Advantages of Using PivotTables

2. Condensing Order Information using PivotTables

3. Setting Up PivotTable for Customer Filtering

4. Crafting the VBA Process

5. Defining Variables in VBA

6. Setting Values for VBA Variables

7.1 Downloadable Content -- Codes till Lecture 31.txt

7. Linking the Filter with the PivotTable

8. Updating Pivot Chart with Customer Selection (VBA)

9. Handling Errors for Customers with No Orders

7. Part E - Excel Dashboard Construction Creating Interactive Button Controls

1. Generating Dynamic Charts using Slicers

2. Customizing the Chart Slicer

8. Part F - Excel Dashboard Construction Adding Finishing Details

1. Concealing Redundant Worksheets and Columns

2. Optimizing Excels Default Configuration

3. Concealing Chart and Slicer Reset (VBA)

4. Securing the Dashboard Content

9. Completing the Course Congratulations!

1. Achievement Unlocked Congratulations!

45,900 تومان

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

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

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

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