Microsoft Excel Course with Projects

Microsoft Excel Course with Projects, available at $49.99, has an average rating of 3.6, with 53 lectures, based on 11 reviews, and has 952 subscribers.

You will learn about A good knowledge on Excel Learn the uses of tools under different menus Good operational knowledge on Excel Full expertise on Excel working on projects This course is ideal for individuals who are Job Holders or Students or Trainers or Job Seekers or Business Owners It is particularly useful for Job Holders or Students or Trainers or Job Seekers or Business Owners.

Enroll now: Microsoft Excel Course with Projects

Summary

Title: Microsoft Excel Course with Projects

Price: $49.99

Average Rating: 3.6

Number of Lectures: 53

Number of Published Lectures: 53

Number of Curriculum Items: 53

Number of Published Curriculum Objects: 53

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will Learn

A good knowledge on Excel
Learn the uses of tools under different menus
Good operational knowledge on Excel
Full expertise on Excel working on projects

Who Should Attend

Job Holders
Students
Trainers
Job Seekers
Business Owners

Target Audiences

Job Holders
Students
Trainers
Job Seekers
Business Owners

This Excel course is designed to give you overall knowledge of Microsoft Excel Application with practical based projects.

This course is designed to fulfil the demand of the corporate platform and also divided into two parts. In Learning part you will learn how to use Microsoft Excel tools function that will enable you to handle Microsoft Excel application efficiently and effectively and in Project part you will learn real applications of Excel.

After completion of this course, you will

1. Achieve a Course Completion Certificate

2. Get a competitive advantage on job market

3. Be able to handle Microsoft Excel efficiently and effectively

4. Introduce Excel training to your organization

5. Train up your employees to grow excel skills to bring efficiency in their day-to-day work

Learning Part

01. Getting Started with Excel

02. Use of Cut Copy and Paste and Format Painter

03. Use of Font Tools under Home Menu

04. Use of Alignment Tools under Home Menu

05. Use of Number Tools under Home Menu

06. How to use of Style Tools under Home Menu

07. Use of Cells tool under home menu

08. Use of Editing Tools under Home Menu

09. How to Work with Multiple worksheet

10. How to use tables tool under insert menu

11. How to use illustrator tool under the insert menu

12. How to use Charts & Sparkline’s tool under insert menu

13. How to use Pivot Table and Slicer in Excel

14. How to use text tool under insert menu

15. How to use text & symbol tool under insert menu

16. How to use different tools under Draw menu

17. Use of Page Layout Tools in Excel

18. Use of different functions in Excel

19. How to Check and fix Function Errors

20. Use of Formula Auditing tools under Formula Menu

21. Use of IF function in Excel

22. How to import data, sorting, filtering and remove data duplication

23. How to use Data Validation tool in Excel

24. Text to Columns tool

25. What IF Analysis – Goal Seek for decision-making

26. What IF Analysis – Data Table for decision-making

27. What IF Analysis – Scenario Manager for Scenario Analysis

28. Data Forecasting Manually and Automatically

29. How to activate solver in Excel for Data Analysis

30. Use of Spelling checker tool under Review Menu

31. How to use Thesaurus and Translate Tool

32. How to use comments and Protection in Excel

33. Workbook Different Views

34. How to use Show and Zoom Tools in Excel

35. How to use Window Tools under view menu

36. How to activate Macro Tool in Excel

37. Tell me what to do Tool in Excel

Project Part

01. Salary Sheet Preparation Part – 1

02. Salary Sheet Preparation Part – 2

03. Net Salary Sheet Preparation Part – 1

04. Net Salary Sheet Preparation Part – 2

05. Government Tax Calculation on Salary

06. Employees Position Determination from Salary

07. Simple Profit or Loss Calculation of a Company

08. Electricity Bill Calculation

09. Student Mark Sheet Preparation Part – 1

10. Student Mark Sheet Preparation Part – 2

11. Employees Performance and Bonus Evaluation

12. Collect Employee Information from Data Table by VLOOKUP

13. Create Macro to work Efficiently in Excel (Data Formatting)

14. Production Unit Decision-Making by Solver

15. Data Modeling to Measure KPI with Power Pivot Part – 1

16. Data Modeling to Measure KPI with Power Pivot Part – 2

I wish you all the best!

Course Curriculum

Chapter 1: Learning Part

Lecture 1: Getting Started with Excel

Lecture 2: Use of Cut Copy Paste and Format Painter

Lecture 3: Use of Font Tools under Home Menu

Lecture 4: Use of Alignment Tools under Home Menu

Lecture 5: Use of Number Tools under Home Menu

Lecture 6: How to use of Style Tools under Home Menu

Lecture 7: Use of Cells tool under home menu

Lecture 8: Use of Editing Tools under Home Menu

Lecture 9: How to Work with Multiple worksheet

Lecture 10: How to use tables tool under insert menu

Lecture 11: How to use illustrator tool under the insert menu

Lecture 12: How to use Charts & Sparkline's tool under insert menu

Lecture 13: How to use Pivot Table and Slicer in Excel

Lecture 14: How to use text tool under insert menu

Lecture 15: How to use text & symbol tool under insert menu

Lecture 16: How to use different tools under Draw menu

Lecture 17: Use of Page Layout Tools in Excel

Lecture 18: Use of different functions in Excel

Lecture 19: How to Check and fix Function Errors

Lecture 20: Use of Formula Auditing tools under Formula Menu

Lecture 21: Use of IF function in Excel

Lecture 22: How to import data, sorting, filtering and remove data duplication

Lecture 23: How to use Data Validation tool in Excel

Lecture 24: Text to Columns tool

Lecture 25: What IF Analysis – Goal Seek for decision making

Lecture 26: What IF Analysis – Data Table for decision making

Lecture 27: What IF Analysis – Scenario Manager for Scenario Analysis

Lecture 28: Data Forecasting Manually and Automatically

Lecture 29: How to activate solver in Excel for Data Analysis

Lecture 30: Use of Spelling checker tool under Review Menu

Lecture 31: How to use Tresaurus and Translate Tool

Lecture 32: How to use comments and Protection in Excel

Lecture 33: Workbook Different Views

Lecture 34: How to use Show and Zoom Tools in Excel

Lecture 35: How to use Window Tools under view menu

Lecture 36: How to activate Macro Tool in Excel

Lecture 37: Tell me what to do Tool in Excel

Chapter 2: Project Part

Lecture 1: Salary Sheet Preparation Part – 1

Lecture 2: Salary Sheet Preparation Part – 2

Lecture 3: Net Salary Sheet Preparation Part – 1

Lecture 4: Net Salary Sheet Preparation Part – 2

Lecture 5: Government Tax Calculation on Salary

Lecture 6: Employees Position Determination from Salary

Lecture 7: Simple Profit or Loss Calculation of a Company

Lecture 8: Electricity Bill Calculation

Lecture 9: Student Mark Sheet Preparation Part – 1

Lecture 10: Student Mark Sheet Preparation Part – 2

Lecture 11: Employees Performance and Bonus Evaluation

Lecture 12: Collect Employee Information from Data Table by VLOOKUP

Lecture 13: Create Macro to work Efficiently in Excel (Data Formatting)

Lecture 14: Production Unit Decision Making by Solver

Lecture 15: Data Modeling to Measure KPI with Power Pivot Part – 1

Lecture 16: Data Modeling to Measure KPI with Power Pivot Part – 2

Instructors

Tajvir Chowdhury
Soft Skills Trainer

Rating Distribution

1 stars: 2 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 3 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu