Ms-Word &amp; Ms -Excel బేసిక్ నుంచి అడ్వాన్స్ గా పూర్తిగా చెప్పబడును &amp;&nbsp;Job Oriented Practical&#39;s చెప్పబడును&nbsp;
Ms-Word Topics
&nbsp;
<ul>
	<li>Ms-Word User Interface , Ribbon , Tabs, Groups, &nbsp;Commands.</li>
	<li>Document Area, Cursor, Status bar, Zoom Control</li>
	<li>Enter Text, Rules &amp; Regulations, Spellings &amp; Grammar</li>
	<li>Format &amp; Paragraph Options, Alignments</li>
	<li>Insert Pictures, Shapes, Symbols</li>
	<li>Tables Design &amp; Layout Options</li>
	<li>Header &amp; Footer, Links</li>
	<li>Table of Contents , Captions, Index</li>
	<li>Mail Merge&nbsp;</li>
	<li>Printing &amp; View Options</li>
</ul>
---------------------------------------------------------------------
<ul>
	<li>Letters, Resumes</li>
	<li>Curriculum Vitae&nbsp;</li>
	<li>Table Formats</li>
	<li>Challan Forms</li>
	<li>Pamphlets Designs</li>
	<li>Certificate Design</li>
	<li>Time Tables</li>
</ul>
--------------------------------------------------
Ms-Excel Topics:-
Basics
---------------------------
<ul>
	<li>Ms-Excel User Interface, Work Sheet Area, Groups, Commands</li>
	<li>Data Entry,&nbsp;How to Apply Formulas</li>
	<li>Formulas &amp; Functions&nbsp;</li>
	<li>Conditional Formatting Options</li>
	<li>Format as table &amp; Cell Styles</li>
	<li>Sort &amp; Filter</li>
	<li>Flash fill &amp; Remove Duplicates</li>
	<li>Data Validation, Consolidate, Scenario Manager</li>
	<li>Goal Seek, Data Table</li>
	<li>Define Names, Formula auditing</li>
	<li>Freeze panes &amp; Split</li>
</ul>
------------------------------------------
Ms Excel ( Advanced )
--------------------------------------------
<ul>
	<li>Create Daily Expences &amp; Income Report</li>
	<li>Compare Two sheets</li>
	<li>Automatic Transfer Data</li>
	<li>EXCEL AI TOOLS</li>
	<li>Excel to Email</li>
	<li>Adv Data Validation</li>
	<li>Excel New Conditions</li>
	<li>Pictures in cells</li>
	<li>Salary Sheet Prepare</li>
	<li>Transpose in Ms-Excel</li>
	<li>Dynamic Serial no&#39;s</li>
	<li>Saparate No&#39;s from Text</li>
	<li>Dynmically Drop Down List</li>
</ul>
------------------------------------------------------
Ms Excel ( Formulas )
------------------------------------------------------
<ul>
	<li>STUDENT BASED FORMULAS</li>
	<li>Date All Formulas</li>
	<li>VLookup</li>
	<li>VLOOKUP MATCH</li>
	<li>Multiple Data Vlookup</li>
	<li>Hlookup</li>
	<li>Xlookup formula</li>
	<li>INDEX &amp; MATCH FORMULAS</li>
	<li>String Functions</li>
	<li>NESTED IF FORMULA</li>
	<li>Advanced Formulas</li>
</ul>
-------------------------------------------------
Ms-Excel ( Real time Practical )
-------------------------------------------------
<ul>
	<li>Data Entry All Options</li>
	<li>FILTER All Options</li>
	<li>Conditional Data Entry</li>
	<li>Create Tax Invoice in Excel</li>
	<li>Slicer All Options</li>
	<li>VLOOKUP Basic to Adv</li>
	<li>IF Formula (10 Examples )</li>
	<li>Pivot Table Basic to Adv</li>
	<li>Priting &amp; Page Setup Options</li>
	<li>Drop Down List All Options</li>
	<li>Expences Incoms Main Proj</li>
	<li>Attendence Register for Employes</li>
	<li>Master Sheet to Multiple Sheets</li>
	<li>Monthly EMI Calculation PMT Formula</li>
	<li>SALARY CALCULATION</li>
	<li>Oxford school Format</li>
	<li>Sumif &amp; Sumifs Formula</li>
	<li>Sumproduct Formula</li>
	<li>SUMSQ &amp; SUMX2MY2 Formula</li>
	<li>SUMX2PY2 &amp; SUMXMY2 Formula</li>
	<li>Total Monthly EMI Format Table (PMT, PPMT, IPMT)</li>
	<li>TYPES OF COMPUTER Practical</li>
</ul>

TALLY ERP9&nbsp;బేసిక్ నుంచి అడ్వాన్స్ గా పూర్తిగా చెప్పబడును.&nbsp;
--------------------------------------------------------------------------------
<ul>
	<li>Basics Topics</li>
	<li>Inventory Topics</li>
	<li>Taxation Topics</li>
	<li>GST Topics</li>
	<li>Tally Notes &amp; Shortcuts</li>
</ul>
&nbsp;

Photoshop CC&nbsp; బేసిక్ నుంచి ఫోటో స్టూడియో లో వర్క్ చేసుకొనే విధముగా నేర్చుకోండి&nbsp;
-----------------------------------------------------------------------------------------------------------------
1. Introduction
2. Page Setup &amp; Layput Options
3. Tools with Options
4. Layers with Options
5. Menus with Shortcuts
6. Sample Projects
7. Real time Projects
8. Stduent ID Cards &amp; Progress Reports Design
9. Album Designs &amp; Oil Painting&nbsp;
10. Free Album PDS Files&nbsp;
11. Background Designs PSD Files
12.Practice Image Files
13. Shortcuts Notes

4 DTP Courses
----------------------
Adobe Photoshop CC
Adobe PageMaker
Adobe InDesign
CorelDRAW

Featured

🏅 Ms-Word & Ms-Excel 👉 Basic to Real time knowledge with Excise Files

💵 Tally with GST 👉 Basic Accounting to Inventory & GST with Notes

✨ Adobe Photoshop CC 👉 Basic to Real time Practical Knowledge

📢 DTP - Desktop Publishing 🖥️ 4 Designing Courses in Telugu

About Us