Self Adhyan Guruji

MS-Excel (Advance with MIS)·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Information About Excel Sheet and Types of CellReferencing and other important Rules.·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Explanation If Formula, nested if formula with PracticalAssignment.·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Explanation Loan Sheet calculation 5 Types Method (Monthly,Yearly Quarterly, Annually, Daily)·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Student Related Marksheet Calculation formula (FullyExplained in Depth) with practice Exercise. ·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lookup Formula, VLookup, HLookup, Multiple Vlookup forSearching Data in Sheet with Practical Assignment·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Text Formula (Upper, Lower, Proper, Concatenate, Len andmore) with Practical Assignment.·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Salary Calculation formula with Multiple condition Criteriawith Practical Assignment.·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Database Formula (Dsum, Dmax, Dmin, Daverage) with DropDown Listing Assignment ·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Math and Trigonometric Formula (product, power, Sumif, GCD,Roundup, Rounddown, Sumproduct) with Assignment·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Logical Formula (Iferror, and , or , not)·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Working on Date &amp; Time Formula·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Financial Formula ( PV, FV, PPMT, IMPT, NPER, RATE) ·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Statistical Formula (Averageif, averageifs, count ALLformula, Frequency, Rank, Mean, Median, Mode) ·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Information FORMULA ( Type of Error Knowledge)·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Match, Index, Indirect, Transpose Uses with Explanation.·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Engineering formula (ALL Conversion binary, Decimal, Hex,Octal)·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL Important Below Topics with Assignment·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Advance Filter·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data Sorting·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Working with Charts·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Scenario·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data table Working·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data validation·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Pivot Table Working·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Goal Seek·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tracing Data·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fill Data·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Subtotal Calculation and many other, ALL TABS ExplanationVideo + Practical Assignment.·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Theory PDF Provide to you in Simple English ALL Tabs Explanation·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Short KEY PDF – Howto Work Fast for create Sheet and other Settings·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Test Paper for Practical Assignment when you Complete All VideosAttach in the Last of PDF·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL Formula andVideo (Job Oriented) if any query can WhatsApp 9818606913.40+ PDF and Excel Assignment &amp; 91+Videos (Course Duration – 45 Days)CourseDescription <ul><li>Advance Excel Practical Courses PDF with Practical Assignment in Simple English Language. PDF can download after Payment.</li><li>Videos Available in Each category with details in Hindi. Videos can Download after Payment.</li><li>Updating Video will Automatically Add in Course.</li><li>Related Course Software will Provide for Practice.</li><li>Drive link Provide for Software's/PDF Download. </li><li>Website Portal - www.selfadhyan.in</li></ul> 👉🏻Download - Advance - Excel ​<a rel="nofollow" target="_blank" href="http://bit.ly/3WkxppE">bit.ly/3WkxppE</a>​ Apply 40% Discount Coupon Code Below EXCELGURUJI 👉🏻Download - Tally Prime Course ​<a rel="nofollow" target="_blank" href="http://bit.ly/3Wa0qF4">http://bit.ly/3Wa0qF4</a> Apply 40% Discount Coupon Code Below TALLYGURUJI 👉🏻Download ALL COURSES 40+ Courses ​<a rel="nofollow" target="_blank" href="http://bit.ly/3I18eor">http://bit.ly/3I18eor</a> Apply 85% Discount Coupon Code Below MYGURUJI 👉🏻Explore our ALL Courses Or Insititute Package Offer (DOC FIle) ​<a rel="nofollow" target="_blank" href="https://bit.ly/2BOyaUq">https://bit.ly/2BOyaUq</a>&nbsp;​

Advance EXCEL with Assignments and PDF