Requirements
- Ms Office
- Basic Hindi Urdu
Description
This course explains the advanced features of Microsoft Excel. The course discusses how to use different tools and functions of Excel to increase the productivity and efficiency of business processes and create dashboards for better understanding. The course will help you to:
- Learn how to use What-if, LOOKUP, INDEX, and various other Advance functions of Excel
- Learn how to use the Data validation function of Excel
- Learn how to make reports using Excel
- Learn how to use Pivot tables and charts in Excel
- Importance of Advanced filters of Excel
- Learn how to do Advanced Sorting
- Learn how to Import data in Excel
- Learn how to work on an Excel Worksheet
- Ways to format data in Excel
- Learn how to customize Excel Worksheets
- Different formulas and short cuts in Excel to make calculation easier
- Learn how to insert tables, charts, and images in Excel for presentation purposes
Key Learnings of the Course
- How to work on an Excel Worksheet?
- What are the different ways to format data in Excel?
- How to customize the Excel Worksheets?
- What are the different formulas and shortcuts in Excel to make the calculation easier?
- How to insert tables, charts, and images in Excel for presentation purposes?
- How to use What-if, LOOKUP, INDEX, and various other Advance functions of Excel?
- How to use the Data validation function of Excel?
- How to make reports using Excel?
- How to use Pivot tables and charts in Excel?
- What is the importance of advanced filters of Excel?
- How to do Advanced Sorting?
- How to Import data in Excel?
Course Benefits & Outcomes
- Understand how to work on an Excel Worksheet
- Know the ways to format data in Excel
- Learn how to customize Excel Worksheets
- Different formulas and short cuts in Excel to make calculation easier Learn how to insert tables, charts, and images in Excel for presentation purposes
- Learn the What-if, LOOKUP, INDEX, and various other Advance functions of Excel
- Use the Data validation function of Excel
- Make reports using Excel
- Use Pivot tables and charts in Excel
- Importance of Advanced filters of Excel
- Learn the Advanced Sorting
- Import data in Excel
Who this course is for:
- This course explains the advanced features of Microsoft Excel. The course discusses how to use different tools and functions of Excel to increase the productivity and efficiency of business processes and create dashboards for better understanding.
Join us on Telegram
https://t.me/udemyfreedown
