Advance Microsoft Excel Zoom

 

Total Lectures 14

Available Languages: English & Hindi

Overview\Course \Content\Eligibility\Career Options

Overview

We’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including: IF statements VLOOKUP and HLOOKUP Pivot Tables and Charts Macro Operations The Ability to Master Excel By the completion of this computer based advanced Excel training video for Microsoft Excel, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Requirements

 

Course Content

Lecture 1 - Introduction

Lecture 2 - Adv. Conditional Formatting

Lecture 3 - Adv. Data Validation

Lecture 4 - SUMIF & SUMIFS / COUNTIF & COUNTIFS

Lecture 5 - VLOOKUP & HLOOKUP

Lecture 6 - Index Match & SUMPRODUCT

Lecture 7 - Pivot Chart / Table

Lecture 8 - Chart & Sorting of Data

Lecture 9 - Filter & Macros Recording

Lecture 10 - Dashboard / Power Pivot

Lecture 11 - Import of Data from Other Sources & Data Merging / Power Query

Lecture 12 - Page Layout & Add Ins

Career Options

Data Anaylyis

MIS Department in Corporate

Eligibility

Basics of Excel