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:
<ul>
	<li>Learn how to use What-if, LOOKUP, INDEX, and various other Advance functions of Excel</li>
	<li>Learn how to use the Data validation function of Excel</li>
	<li>Learn how to make reports using Excel</li>
	<li>Learn how to use Pivot tables and charts in Excel</li>
	<li>Importance of Advanced filters of Excel</li>
	<li>Learn how to do Advanced Sorting</li>
	<li>Learn how to Import data in Excel</li>
</ul>

ADVANCE EXCEL

Bada Business Community

Introduction

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 & Internet

WHAT IF Analysis Function

Query Editor in Excel

Creation of Macros

Summary

Description

Content