Home
Videos uploaded by user “Sachin Vartak”
Video 03 Income Tax Calculation with Integrated VLOOKUP
 
15:31
Income tax calculation with integrated VLOOKUP function 1. Understanding basic principle of tax calculations, two approaches First Fit Basis and Incremental Basis 2. Manual calculation of income tax 3. Calculating income tax with IF function 4. Setting-up table array for integrated VLOOKUP and using NAME for defining table array 5. Calculating income tax with IF function 6. Advantages of integrated VLOOKUP function over integrated IF function
Views: 189 Sachin Vartak
Video 08 AUTOMATING INVOICE NUMBER
 
10:07
AUTOMATING INVOICE / DEBIT NOTE / CREDIT NOTE / DELIVERY ORDER / LORRY RECEIPT NUMBER USING EXCEL FUNCTIONS: 1. CELL 2. SEARCH 3. REPLACE 4. LEFT WITHOUT ANY MANUAL INTERVENTION ONE CAN AUTOMATE THE NUMBERING OF INVOICES OR ANY DOCUMENTS WITH UNIQUE NO. THE NUMBER CAN BE OF ANY LENGTH
Views: 52 Sachin Vartak
Video 09 CALCULATING PROF TAX OF 22 STATES IN SINGLE INTEGRATED FUNCTION
 
18:09
VLOOKUP WITH INDEX VLOOKUP AND INDEX GIVING NAMES TO TABLE ARRAY VLOOKUP USING APPROXIMATE MATCH FEATURE CALCULATE PROFESSION TAX OF 20 + STATES WITH DIFFERENT PROFESSION TAX SLABS WITH GREAT EASE USING VLOOKUP AND INDIRECT
Views: 23 Sachin Vartak
Video 01 Choose Function
 
37:25
Choose Function with practical examples: 1. Concepts of Choose Function 2. Using Choose Function to represent whole number, text, special characters, functions and integrated functions, range of cells and table array 3. Comparison of choose with vlookup 4. Integration of choose with other functions in excel (iferror, vlookup,value,left etc.)
Views: 65 Sachin Vartak
Video 02 Index&Match
 
47:19
Index & Match Basics Integration of Index & Match Integration of Index & Match with Vlookup Integration of Index & Match with Sum Integration of Index & Match with Hlookup Integration of Index & Match with Array feature Advantage of India & Match over other lookup functions Index & Match with Vlookup for billing format based on billing master data
Views: 27 Sachin Vartak
Video 05 ARRAY FORMULA
 
36:39
1. Array formula basics 2. Notes and things to be taken care while dealing with Array formula 3. Array for distribution of data across columns 4. Array for distribution of data across rows 5. Array for distribution of data across columns and rows 6. Array for distribution of data in text format 7. Array integration with VLOOKUP 8. Array integration with SUMIF 9. Array integration with SUM and SMALL / LARGE 10. Array integration with VLOOKUP, CHOOSE 11. Array for mathematical operatives
Views: 18 Sachin Vartak
Video 04 MOD Function with Integration
 
36:12
MOD function concept MOD function integrated with YEAR function for leap year MOD function integrated with IF function for time calculation MOD function integrated with TRUE/FALSE for time calculation MOD function to strip-out date to fetch only time MOD function integrated with RIGHT function MOD function integrated with IF, MONTH and HLOOKUP for getting head count at the quarter end MOD function integrated with ROW and SUMIF MOD function integrated with SUMPRODUCT
Views: 22 Sachin Vartak
Video 10 TIME SAVING 4 TRICKS IN EXCEL
 
23:36
1. SORTING FROM LEFT TO RIGHT CONCEPT 1(A). SORTING FROM LEFT TO RIGHT USING HLOOKUP 1(B)SORTING FROM LEFT TO RIGHT USING MATCH 2 AUTO FILL DATA USING RELATIVE CELL REFERENCE FEATURE 3. ADDING BLANK ROWS BETWEEN RECORDS 4.TRANSPOSING DATA 4(A). TRANSPOSING USING CONVENTIONAL PASTE SPECIAL 4(B). TRANSPOSING USING TRANSPOSE ARRAY FUNCTION 4(C). TRANSPOSING USING FIND, REPLACE AND RELATIVE CELL REFERENCE 4(D). TRANSPOSING USING OFFSET, COLUMNS AND ROWS 4(E). TRANSPOSING INDEX, COLUMNS AND ROWS 4(F). TRANSPOSING USING PURE ARRAY
Views: 14 Sachin Vartak
Video 06 INTEGRATED FUNCTIONS
 
34:39
=Basic concept of Integration: =Notes on how to go about on integration of functions 1. Integration VLOOKUP with IF (using name for table array) 2. Integration LOOKUP with IF 3. Integration VLOOKUP with CHOOSE,VALUE and LEFT (using name for table array) 4. Integration VLOOKUP with MID and INDIRECT (using name for table array) 5. Integration IF with INDEX & MATCH (using name for table array)
Views: 38 Sachin Vartak
Video 07 OFFSET AND ITS INTEGRATION
 
35:12
1. OFFSET BASICS 2. SYN-TEXT OF OFFSET CONDITIONS EXPLAINED 3. OFFSET FUNCTION BY ITSELF 4. OFFSET FUNCTION - MOVING ROWS DONE AND UP 5. OFFSET FUNCTION - MOVING COLUMNS LEFT AND RIGHT 6. OFFSET FUNCTION - SUM AND AVERAGE OF FIXED RANGES 7. OFFSET FUNCTION - AVERAGE WITH VOLATILE RANGES ACROSS ROWS 8. OFFSET FUNCTION - AVERAGE WITH VOLATILE RANGES ACROSS CLOLUMNS 9. OFFSET FOR TRANSPOSING DATA IN ROWS ACROSS COLUMNS
Views: 21 Sachin Vartak

P57 hoodia cactus slimming capsule informacion de mexico
Seroquel 1200 mg day
Valtrex 500mg twice a day in medical terms
Atom phenslim 50mg clomid
Vhdl component declaration with generic plavix