Microsoft Excel to Manage the Daily Business Activities

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

Boost your career and boost your work by learning excel with business examples in fast time with less efforts

1 - Introduction

1 - 7 ways you can use excel in business to save time money.zip

1 - Introduction

1 - excel cheat sheet.zip

2 - Data Formatting and Preparation

2 - Data Formatting with Formatting Tools

2 - Data-Formatting.xlsx

3 - Conditional Formatting

3 - Conditional-Formating-Sales-Data-Base.xlsx

3 - Data Filtration

4 - Data Filtration Using Filtration Tool

4 - Data-Filteration-Using-Filteration-Tool.xlsx

5 - Data-Filteration-Using-Filteration-Tool-Selected-Data.xlsx

5 - Using Filtration Tool Selected data

6 - Data Filtration Using Slicer

6 - Data-Filteration-Using-Slicer.xlsx

4 - Data Cleansing

7 - Data-Cleansing-Check-and-Remove-Duplication.xlsx

7 - Remove Duplication

8 - Check Spelling

8 - Data-Cleansing-Check-Spelling.xlsx

9 - Data-Cleansing-Len-Function.xlsx

9 - Len Function Adjust Length of characters

10 - Data-Cleansing-Replace-Tool.xlsx

10 - Replacement Tool Remove Unneeded Words

11 - Trim Function Remove Spaces

5 - Data Sorting

12 - Data Sorting with Sorting Tool

12 - Data-Sorting-with-Sorting-Tool.xlsx

13 - Data Sorting with Conditional Formatting

13 - Data-Sorting-with-Conditional-Formatting.xlsx

6 - Data Representation with Charts

14 - How to Insert Chart

14 - Insert-a-Chart.xlsx

15 - Formating-a-Chart.xlsx

15 - Format Chart

16 - Customize Chart Axis

16 - Customize-your-chart-axis.xlsx

17 - Labeling the chart

17 - Labling-a-Chart.xlsx

18 - How to represent the negative values in your chart

18 - Presenting-negative-values-on-your-charts.xlsx

19 - Create a Pie Chart

19 - Creating-a-Pie-Chart.xlsx

20 - Create Radar Chart KPIs

20 - Creating-radar-Chart.xlsx

7 - Data Extraction and Matching

21 - Retrieve Information with Dates

21 - Retrive-information-with-dates.xlsx

22 - Combining Data Value in One Cell

22 - Combining-data-value-in-one-cell.xlsx

23 - Cross reference and Inserting Data AutomaticallyVLOOKUP

23 - Cross-reference-and-inserting-data-automatically-Vlookup.xlsx

8 - Data Visualization with Dashboard

24 - Create-Pivot-Table.xlsx

24 - How to Create Pivot Table

25 - Create-Pivot-Chart.xlsx

25 - How to Create Pivot Chart

26 - Create Recommended Pivot Table

26 - Create-Recommended-Pivot-Table.xlsx

27 - Adjust and Format the Pivot Table

27 - Adjust-and-Format-Pivot-table.xlsx

28 - Build Analytical Reports

28 - Build-Analytical-Report-Using-Pivot-Tables.xlsx

29 - Connect Multiple Pivot Charts to Create a Dashboard

29 - Connect-multiple-pivot-charts-to-have-one-Dynamic-Report.xlsx

9 - Work with Complexity

30 - Using Forecasting Tool Forecast Sales Revenue

30 - Using-Forcasting-Tool-Sales-Revenue.xlsx

31 - Automatic Report with Sumproduct Function

31 - Automatic-report-with-SUMPRODUCT-function.xlsx

32 - HR-Payroll-Sheet-Prevent-Duplication.xlsx

32 - Prevent Duplication in Data

139,000 تومان

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

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

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

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