PGDCA Course Training in Nalgonda
1. Advanced MS Word
Track changes
Reviewing tools
Indexing
Table of contents
Macro basics
2. Advanced MS Excel
Advanced formulas (VLOOKUP, IF, SUMIF, COUNTIF)
PivotTables
PivotCharts
Conditional formatting
Data import & export
Dashboard basics
Excel Macros (VBA Intro)
3. Advanced PowerPoint
Master slides
Advanced animations
Interactive presentations
Hyperlinks & action buttons
4. MS Access (Database Basics)
Tables
Queries
Forms
Reports
Relationships
