Advanced Excel Course For Job And Real World

Advanced Excel For Beginner to Professional

What you'll learn

All the Advanced uses of MS Excel

All the Essential Skills of MS Excel

Advanced Excel Functions, Formulas

VLOOKUP, HLOOKUP

Match, Audit Report

Macro, VBA

Entry Bill, Salary Slip

Job Formula

Requirements

Basic Computer Knowledge

Basic Excel Knowledge

Understand English Language

Description

Hello Everyone are you looking for learning Micro Soft Excel from the basic level to advanced level? if you are looking to learn MS Excel from basic to advanced than you are in right place. So if you need to learn advanced methods for MS Excel than this course is appropriate for you. Lets take a look what you will learn from this course:· All the Advanced uses of MS Excel· All the Essential Skills of MS Excel· Advanced Excel Functions, Formulas· VLOOKUP· HLOOKUP· Match· Audit Report· Macro· VBA· FV and PV· Index and Match· Entry Bill· Salary Slip· Job Formula and many moreBy the end of the course you'll be writing robust, elegant formulas from scratch, allowing you to:· Easily build dynamic tools & Excel dashboards to filter, display and analyze your data· Create your own formula-based Excel formatting rules· Join datasets from multiple sources with VLOOKUP, HLOOKUP, INDEX & MATCH functions· Manipulate dates, times, text, and arraysSo if you want to take yourself in next level for MS Excel than you can join our course. During learning, if you face any problem than I am always there for you to help you out. So I am expecting you to have you in my next lesson.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 5 advanced excel formulas

Lecture 3 Excel Formulas for Job Interview

Lecture 4 Date Function

Lecture 5 Creating Entry Bill

Lecture 6 Excel Shortcut and Quick Navigation

Lecture 7 Excel Macro

Lecture 8 Excel VBA

Lecture 9 FV and PV

Lecture 10 How to create Audit report

Lecture 11 How to create monthy salary slip

Lecture 12 Index _ Match

Lecture 13 IRR

Lecture 14 NPV

Lecture 15 Offset and Match

Lecture 16 PMT _ building a complete Loan Schedule

Lecture 17 Vlook up and HLookup

Lecture 18 Vlookup and Choose

Lecture 19 Vlookup and Coloums

Lecture 20 Vlookup and Indirect

Lecture 21 Vlookup and Match

Who want to learn advanced excel