Tally Prime With GST

• Basic of Accounting
• Fundamentals of Tally Prime
• Accounting Master in Tally Prime
• Inventory Master in Tally Prime
• Vouchers Entries in Tally Prime
• Advance Accounting in Tally Prime
• Advance Invertory in Tally Prime
• Taxes in Tally Prime
• Technological Advantages in Tally Prime
• Payroll Accounting In Tally Prime
• Generating Reports In Tally Prime

Advanced Formulas and Functions:

• Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH combinations.
• Logical Functions: Nested IF, AND, OR, IFERROR.
• Text & Date Functions: TEXTJOIN, LEFT, RIGHT, MID, DATEDIF.
• Array Formulas: Basic examples, using IF, LEN, and MID within arrays.

Data Analysis and Visualization:

• PivotTables and PivotCharts: Creating, customizing, and formatting.
• Dashboard Creation: Developing interactive reports and visualizations.
• Data Validation: Creating dropdown lists, restricting data input based on formulas.
• Conditional Formatting: Advanced rules, using formulas to highlight data.

Data Analysis Tools:

• What-If Analysis: Goal Seek, Data Tables, Scenario Manager.
• Solver Add-in: For complex optimization problems.

Automation and Macros (VBA):

• Macro Recorder: Recording and running macros to automate repetitive tasks.
• VBA Programming: Introduction to visual basic editor, writing simple scripts, and user-defined functions.

Data Management and Protection:

• Data Cleaning: Removing duplicates, text-to-columns, grouping/outlining.
• Protection: Protecting workbooks, worksheets, and specific cells.

MS Word (Word Processing)

• Basics: Creating, opening, saving, closing, and printing documents.
• Editing: Cut, copy, paste, find, and replace text.
• Formatting: Font styling, paragraph alignment, line spacing, bullets, and numbering.
• Page Layout: Margins, orientation, page size, columns, and page breaks.
• Tables: Inserting, formatting, and adjusting table properties.
• Advanced Features: Mail merge, headers/footers, inserting images, SmartArt, and spell check.

MS PowerPoint (Presentations)

• Basics: Creating presentations, inserting new slides, and understanding layouts.
• Formatting: Applying themes, backgrounds, and text styling.
• Multimedia: Inserting images, shapes, tables, charts, audio, and video files.
• Animations: Slide transitions and custom animations for objects.
• Presentation: Running slideshows, setting up, and using presenter view