What you will learn
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?
How To Use Sparklines?
If Function And Its Usage
Vlookup And Hlookup Function
Index Match
Data Validation And Indirect Function
Report Making In Excel
Excel โ Offset Function
Usage Of Pivot Table
Creating Dashboard Using Pivot Table
Advanced Filters
Advance Sorting
Importing Data From Csv
What If Analysis Function
Query Editor In Excel
Creation Of Macros
Creating & Navigating Through A Worksheet
How To Format Data In Excel Worksheet?
How To Customize And View A Worksheet?
Configure Worksheets To Save & Print .
How To Insert And Format Data In Excel Worksheet?
Conditional Formatting & Group Cells & Ranges
Different Formulas & Functions In Excel
Averageif & Countif Functions In Excel
How To Create & Format Charts In Excel Worksheet?
Images And Smartart In Excel
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
Content