
Advance Professional Excel
Product Price
₹1,500
Description
"Working with worksheets, Number Formatting, Cell Reference Fill Series working with Functions :- Mathematical , statistical , Logical Function, financial Function, Lookup Functions (VLOOKUP, HLOOKUP) Match & Index, Depreciation, database information Function, Conditional Formatting , Data Validation
what if analysis Tool, Pivot Table.
Functions
SUM, ABS, IF, ROUND , PRODUCT,
SUMIF, SUMIFS, COUNTIF, COUNTIFS, HLOOKUP, GOAL SEEK, TEXT TO COLUMN, CONCATENATE
AND MANY MORE
GOOGLE SHEETS(ADVANCE FUNCTION) & XLOOKUP
MACRO
VISUAL BASIC CODING
INTRODUCTION OF VARIABLE
INTRO VARIABLE & LOOPS
VBA INDEX AND MATCH
VBA ATTENDANCE TRACKER
VBA VLOOKUP SOLUTION
PROJECT (DATA TRANSFER MASTER SHEET TO MULTIPLE SHEETS) ETC
VLOOKUP
1 INTRODUCTION VLOOKUP
2 RANGE LOOKUP
3 IF ERROR VLOOKUP
4 NESTED VLOOKUP
5 FILTER USING VLOOKUP
6 DOUBLE VLOOKUP
7 MULTI TABLE VLOOKUP
8 MULTI SHEET VLOOKUP
9 VLOOKUP ON WORKBOOK
10 VLOOKUP INTERVIEW QUESTIONS
11 REVERSE LOOKUP WITH CHOOSE
12 VLOOKUP WITH INDEX MATCH
13 VLOOKUP WITH FIND
14 VLOOKUP TWIST
15 USE VLOOKUP TO CREATE MIS
REAL TIME JOB PROBLEM QUESTIONS, BASIC & ADVANCE ACCOUNTING CONCEPTS (JOB QUESTIONS)
SHORTCUT KEYS ETC"