Microsoft Excel Course with Projects

Deal Score+2
FREE $9.99 Go To Course
Deal Score+2
FREE $9.99 Go To Course

Description

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!

What you’ll 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

Requirements

  • Basic Office Application Knowledge
  • Basic Knowledge of PC and Laptop
  • Eager to know the new things

Who this course is for:

  • Job Holders
  • Students
  • Trainers
  • Job Seekers
  • Business Owners
FREE $9.99 Go To Course
×

Report Post

Tags: