Certificate Course in Excel
Our institution is committed to delivering high-quality education that bridges the gap between academic learning and industry demands. With a focus on practical, hands-on training, we offer a diverse range of courses, including Certification Couse in Excel, Tally Professional Certificate Program, Certificate Course in Taxation, DCA, Tally Prime, Taxation, GST, TDS, INCOME TAX, Microsoft Excel, C, C++, JAVA, and more.
Whether you are a beginner looking to kickstart your career or a professional aiming to upskill, Tally Academy provides tailored programs designed to help you achieve your goals. Over the 20 years, we have established ourselves as a trusted name in education, empowering individuals to excel in their chosen fields and become industry-ready professionals.
Fee-6300/-
Duration: 2 Months
Content:
* VLOOKUP , HLOOKUP , INDEX , MATCH .
* PMT , IPMT ,PPMT.XLOOKUP
* Dynamic Excel Formula.
* Attendance Sheet. Salary Sheet.
* Use IF,IFS,IFERROR,SUMIF,COUNTIF.
* logical Fuctions, Search Formula.
* Gol seek, Scenario Manager.
* Link With Macro.
* 3D Formula.
* Link File to File or Sheet to Sheet.
* Pivot Table and Pivot Chart, Slicer,Timeline
* MIS Report.
* 2-Way Lookup in Excel.
* Automative Repetitive tasks in Excel Using Macro.
* 5 Excel Project With Macro ,Without Macro.
* Editing and Formating charts.
* What if analysis.
* Filtering Data , Advance Filter.
* Sorting Data.
* Consolidating Worksheet Charts.
* Tables.Generate Tax invoice in Excel
* Balance Sheet ,P&L A/C in Excel.
* File Link with Google Sheets.