MS Office & Advanced Excel Course in Hazratganj, Lucknow

Main Topic 1: Document Formatting & Styles — Multilevel Lists, Table of Contents, Page Breaks, Header/Footer, Watermarks Main Topic 2: Automated Mail Merge & Collaboration — Recipient Databases, Custom Envelopes/Labels, Track Changes & Comments Practical Capstone: Generating Automated Personalizes Offer Letters via Mail Merge

Main Topic 1: Lookup & Logical Formulas — VLOOKUP, XLOOKUP, Dynamic Nested IF-ELSE, SUMIFS, COUNTIFS Main Topic 2: Data Summarization & Pivot Tables — Pivot Charts, Slicers, Data Validation Dropdowns & Heatmaps Practical Capstone: Building an Executive Interactive Financial Performance Dashboard

Main Topic 1: PowerPoint Presentation Design — Slide Master Customization, Morph Transitions, SmartArt Graphics, Audio/Video Embedding Main Topic 2: MS Outlook Email & Calendar Admin — Email Rules, Automated Out-of-Office, Meeting Scheduling, Signature Config Practical Capstone: Delivering a Pitch Deck Presentation & Managing Corporate Outlook Calendar

Pivot tables and pivot charts Data analysis and reporting techniques Managing large datasets Creating dashboards using Excel

Creating sales and expense reports Employee data management spreadsheets Business performance tracking sheets Professional presentation creation in PowerPoint

Report preparation using Excel charts Office documentation workflows Productivity tips for office tasks Final practical assignments and review