MS-Excel

(Advance with MIS)

·        

Information About Excel Sheet and Types of Cell

Referencing and other important Rules.

·        

Explanation If Formula, nested if formula with Practical

Assignment.

·        

Explanation Loan Sheet calculation 5 Types Method (Monthly,

Yearly Quarterly, Annually, Daily)

·        

Student Related Marksheet Calculation formula (Fully

Explained in Depth) with practice Exercise.

·        

Lookup Formula, VLookup, HLookup, Multiple Vlookup for

Searching Data in Sheet with Practical Assignment

·        

Text Formula (Upper, Lower, Proper, Concatenate, Len and

more) with Practical Assignment.

·        

Salary Calculation formula with Multiple condition Criteria

with Practical Assignment.

·        

Database Formula (Dsum, Dmax, Dmin, Daverage) with Drop

Down Listing Assignment

·        

Math and Trigonometric Formula (product, power, Sumif, GCD,

Roundup, Rounddown, Sumproduct) with Assignment

·        

Logical Formula (Iferror, and , or , not)

·        

Working on Date & Time Formula

·        

Financial Formula ( PV, FV, PPMT, IMPT, NPER, RATE)

·        

Statistical Formula (Averageif, averageifs, count ALL

formula, Frequency, Rank, Mean, Median, Mode)

·        

Information FORMULA ( Type of Error Knowledge)

·        

Match, Index, Indirect, Transpose Uses with Explanation.

·        

Engineering formula (ALL Conversion binary, Decimal, Hex,

Octal)

·        

ALL Important Below Topics with Assignment

·        

Advance Filter

·        

Data Sorting

·        

Working with Charts

·        

Scenario

·        

Data table Working

·        

Data validation

·        

Pivot Table Working

·        

Goal Seek

·        

Tracing Data

·        

Fill Data

·        

Subtotal Calculation and many other, ALL TABS Explanation

Video + Practical Assignment.

·        

Theory PDF Provide to you in Simple English ALL Tabs Explanation

·        

Short KEY PDF – How

to Work Fast for create Sheet and other Settings

·        

Test Paper for Practical Assignment when you Complete All Videos

Attach in the Last of PDF

·        

ALL Formula and

Video (Job Oriented) if any query can WhatsApp 9818606913.

40+ PDF and Excel Assignment & 91+

Videos (Course Duration – 45 Days)

Course

Description

• Advance Excel Practical Courses PDF with Practical Assignment in Simple English Language. PDF can download after Payment.
• Videos Available in Each category with details in Hindi. Videos can Download after Payment.
• Updating Video will Automatically Add in Course.
• Related Course Software will Provide for Practice.
• Drive link Provide for Software's/PDF Download.
• Website Portal - www.selfadhyan.in

👉🏻Download - Advance - Excel
​bit.ly/3WkxppE​
Apply 40% Discount Coupon Code Below
EXCELGURUJI

👉🏻Download - Tally Prime Course
​http://bit.ly/3Wa0qF4
Apply 40% Discount Coupon Code Below
TALLYGURUJI

👉🏻Download ALL COURSES 40+ Courses
​http://bit.ly/3I18eor
Apply 85% Discount Coupon Code Below
MYGURUJI

👉🏻Explore our ALL Courses Or Insititute Package Offer (DOC FIle)

​https://bit.ly/2BOyaUq ​