Microsoft Excel to Manage the Daily Business Activities

Focused View

Hany Khalil

1:54:54

125 View

1 - Introduction

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

1 - Introduction.mp4

03:14

1 - excel cheat sheet.zip

2 - Data Formatting and Preparation

2 - Data Formatting with Formatting Tools.mp4

05:32

2 - Data-Formatting.xlsx

3 - Conditional Formatting.mp4

05:25

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

3 - Data Filtration

4 - Data Filtration Using Filtration Tool.mp4

03:01

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

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

5 - Using Filtration Tool Selected data.mp4

03:02

6 - Data Filtration Using Slicer.mp4

04:25

6 - Data-Filteration-Using-Slicer.xlsx

4 - Data Cleansing

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

7 - Remove Duplication.mp4

01:37

8 - Check Spelling.mp4

01:39

8 - Data-Cleansing-Check-Spelling.xlsx

9 - Data-Cleansing-Len-Function.xlsx

9 - Len Function Adjust Length of characters.mp4

01:46

10 - Data-Cleansing-Replace-Tool.xlsx

10 - Replacement Tool Remove Unneeded Words.mp4

02:30

11 - Trim Function Remove Spaces.mp4

03:42

5 - Data Sorting

12 - Data Sorting with Sorting Tool.mp4

01:52

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

13 - Data Sorting with Conditional Formatting.mp4

02:06

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

6 - Data Representation with Charts

14 - How to Insert Chart.mp4

02:18

14 - Insert-a-Chart.xlsx

15 - Formating-a-Chart.xlsx

15 - Format Chart.mp4

02:15

16 - Customize Chart Axis.mp4

03:42

16 - Customize-your-chart-axis.xlsx

17 - Labeling the chart.mp4

02:38

17 - Labling-a-Chart.xlsx

18 - How to represent the negative values in your chart.mp4

02:49

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

19 - Create a Pie Chart.mp4

03:17

19 - Creating-a-Pie-Chart.xlsx

20 - Create Radar Chart KPIs.mp4

04:45

20 - Creating-radar-Chart.xlsx

7 - Data Extraction and Matching

21 - Retrieve Information with Dates.mp4

05:08

21 - Retrive-information-with-dates.xlsx

22 - Combining Data Value in One Cell.mp4

02:08

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

23 - Cross reference and Inserting Data AutomaticallyVLOOKUP.mp4

05:07

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.mp4

03:57

25 - Create-Pivot-Chart.xlsx

25 - How to Create Pivot Chart.mp4

01:53

26 - Create Recommended Pivot Table.mp4

03:25

26 - Create-Recommended-Pivot-Table.xlsx

27 - Adjust and Format the Pivot Table.mp4

08:03

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

28 - Build Analytical Reports.mp4

10:10

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

29 - Connect Multiple Pivot Charts to Create a Dashboard.mp4

04:23

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

9 - Work with Complexity

30 - Using Forecasting Tool Forecast Sales Revenue.mp4

02:00

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

31 - Automatic Report with Sumproduct Function.mp4

04:02

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

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

32 - Prevent Duplication in Data.mp4

03:03

Description

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

What You'll Learn?

Learn Microsoft Excel with Business Examples
How to perform Formatting, Filtration, Cleaning, and Sorting for the data using Microsoft Excel
How to present the data using different Charts, and format these charts
How to extract and match the data
How to Visualize the data with dashboard
How to use the most important functions of excel which are needed in daily business

Who is this for?

All officers who use Microsoft Excel in business activities

All Managers and their subordinates who use excel to prepare reports and management presentations

All business leaders who are in direct contact with data needed for decision making

Business Analysts who deal with daily activities and need focused course to master the Excel base of knowledge to achieve their objectives

All new managers or who prepare for managerial position, people who are in need in clear and direct course in excel to lead daily business activities using business examples

More details

Description
As a business member, I understand the importance of staying organized and efficient in the workplace. Excel is one of the most powerful tools I use to manage my business. It allows you to quickly analyze data, create reports and track key metrics. Excel enables you to make better decisions faster and increase efficiency. With its vast array of features and options, you can customize your spreadsheets to fit your unique needs.
You can rely on Excel to keep track of inventory, customer information, financial data, and more. For example, you can use a pivot table feature to quickly summarize large amounts of data. This helps you identify trends and make better decisions about product pricing and inventory management.
Excel also has powerful visualization tools that allow you to represent complex data in clear graphs and charts. This makes it easier for you to present results to stakeholders in an easy-to-understand format.
Overall, Excel is an invaluable tool for helping you manage your business efficiently and effectively. Its versatility allows you to customize your spreadsheets for specific tasks, providing useful insights into areas such as budgeting, performance measurement, and analysis.
Business management with Excel is a powerful tool for any organization. It helps you keep track of your businessâ€™s financial performance, sales, and marketing processes, and make more informed decisions. With Excel, you can analyze data quickly, create charts and graphs to visualize trends, and set up automated processes. You can also use it to track progress and measure success against goals. In this course, you will learn the most excel capabilities with business examples. You will find multiple excel sheets attached to the course as a guide for your to make more practice.
Who this course is for:
All officers who use Microsoft Excel in business activities
All Managers and their subordinates who use excel to prepare reports and management presentations
All business leaders who are in direct contact with data needed for decision making
Business Analysts who deal with daily activities and need focused course to master the Excel base of knowledge to achieve their objectives
All new managers or who prepare for managerial position, people who are in need in clear and direct course in excel to lead daily business activities using business examples

User Reviews

Rating

average 0

Total votes0

Focused display

Hany is an Experienced, Certified, and Accredited Manager and Trainer with 19 years of experience in Industrial management. He has an Executive Doctorate in Business and a Master's Degree in Engineering Management, Also, Professional Certified in Engineering Management. He is a Certified Trainer in addition to some published scientific papers. He participated in multiple professional projects in the field of management

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.