Advanced MS Office Program

Practical Training

30 Hours Module Training

Experienced Mentor

Modern Pedagogy

Who is it for?

The course is aimed at anyone who wants to learn & work on MS Office (Excel, Word, Powerpoint) on their own, and possibly work as a freelancer or employee in the field. We cover everything, so even if you are not from Background, you'll be able to quickly jump in.

learn-about-microsoft-office

Advanced Excel Program

Excel-Training-Digiayam
  • Quick Access Toolbar
  • Menu In Excel
  • Formula Bar in Excel
  • Status Bar in Excel
  • Navigations in Excel
  • Shortcuts in Excel
  • Ribbon Items
  • Excel Getting Started Quiz 1
  • Data Entry in Excel
  • Autofill in Excel
  • Data Entry for Date Time
  • Undo – Redo in Excel
  • Comments in Excel
  • Saving File in Excel
  • Quiz 2
  • Creating Formulas in Excel
  • Copy & Paste Formulas
  • V Lookup
  • H Lookup
  • If
  • Sum
  • Countif, Countifs
  • Max, Min
  • Average
  • Concatenate
  • Datedif
  • Double conditional Formula
  • Quiz 3
  • Format Painter
  • Conditional Formatting
  • Font Formatting
  • Number Formatting
  • Alignments in Excel
  • Table Formatting
  • Shapes Formatting
  • Border Formatting
  • Quiz 4
  • Adjusting Rows & Column
  • Resizing
  • Hide Unhide
  • Copy, Move, Insert Data
  • Find, Replace & Goto
  • Print
  • Page Breakup
  • Page Setup
  • Frizzing
  • Splitting
  • Outline
  • Quiz 5

 

 

  • Insert table
  • Working with Pivot Table
  • Illustrations(Shapes, Smart Art) in Excel
  • Charts & Diagram in Excel
  • Word Art
  • Header & Footer
  • Signature Line
  • Quiz 6
  • Frizzing & Splitting
  • Outline in Excel
  • Manage Multiple Workbook
  • Working with Sheets
  • Copy & Delete Sheet
  • Edit Links
  • Quiz 7
  • Sorting in Excel
  • Subtotals in Excel
  • Filter in Excel
  • Split Data in Excel
  • Flash Fill in Excel
  • Remove Duplicate
  • Data Validation
  • Quiz 8
  • Securing Workbook in Excel
  • Password to Workbook in Excel
  • Sharing Workbook in Excel
  • Track Changes in Excel
  • Protecting Sheets in Excel
  • Quiz 9
  • Macros in Excel
  • Record Macro
  • Use of Macros
  • Quiz 10

Master Quiz

Advanced Word Program

  • Introduction to MS Word
  • Quick Access Toolbar
  • Menu In Word
  • Ribbon Items
  • MS Word Getting Started Quiz 1
  • Inserting
  • Navigating
  • Selecting Table Parts
  • Adding Borders & Shading
  • Aligning Table Data
  • Inserting Rows & Columns
  • Resizing Rows & Columns
  • Merging & Splitting Cells
  • Sorting Table Data
  • Deleting Rows & Columns
  • Deleting Tables
  • Quiz 2
  • Inserting Images
  • Rotating Images
  • Cropping Images
  • Resizing Images
  • Formatting Images
  • Positioning Images
  • Adding Borders
  • Adding Alternative Text
  • Quiz 3
  • Working with Page Setup
  • Themes & Layouts
  • Page Margins
  • Page Orientation
  • Page Size
  • Page Background
  • Page Borders
  • Page Colors
  • Paragraph
  • Page Breaks & Section Breaks
  • Learn to Create advanced level table of contents
  • Footnotes
  • Citation& Bibliography
  • Caption
  • Index
  • Quiz 5
  • Create & Apply Styles
  • Rename, Modify & Remove Styles
  • Reveal Formatting
  • Selection Tool & Format Pane
  • Quiz 6
  • Envelopes & Labels
  • Mail Merge to letters
  • Mail merge to Email
  • Mail merge from Excel
  • Advanced Mail merging to create a bulk automated system
  • Quiz 7
  • Proofing
  • Language & Translation
  • Comments
  • Track Changes
  • Compare Documents
  • Quiz 8
  • Master Quiz

Advanced Powerpoint Program

MS-Powerpoint-Training-Digiayam
  • Get Started with Powerpoint Interface
  • Create & Manage Presentations
  • Open & Navigate Presentation
  • Display & View
  • Sidebar
  • Create & Manage Slides
  • Rearrange Slide Section
  • Apply Themes
  • Backgrounds
  • Quiz 1
  • Enter & Edit text on Slides
  • Move, Copy & Delete Text
  • Format Characters & Paragraphs
  • Apply Word Art text
  • Date & Time
  • Slide no.
  • Header & Footer
  • Check Spellings & Grammars
  • Insert & Format Tables
  • Modify Table Structure
  • Embed & Link
  • Quiz 2
  • Insert, Move & Resize Pictures
  • Draw & Modify Shapes
  • Create a photo Album
  • Create Diagram
  • Modify Diagram
  • Format Diagram
  • Create, Format & Modify Charts
  • Add Sound & movement to Slides
  • Animate Text & pictures
  • Add media to Slides
  • Add & Manage Slide Transition
  • Quiz 3
  • Custom Animation
  • Transition
  • Auto Play
  • Timing
  • Transition Speed
  • Entrance
  • Exit
  • Emphasis
  • Motion Path
  • Animation Pane
  • Animation Tricks
  • Quiz 4
  • Review Presentation
  • Add notes to slide
  • Inspect & Finalize Presentation
  • Prepare & Deliver Presentation
  • Adapt presentation for different Audiences
  • Rehearse & Present A Presentation
  • Present Slide Show
  • Quiz 5
  • Formatting a Shape
  • Editing
  • Format Styles
  • Fill
  • Outline
  • Effect
  • Arrange
  • Line
  • Shadow
  • Animate
  • Quiz 6
  • Grouping of Multiple Objects
  • Ungrouping
  • Shortcuts to Group & Ungroup
  • Quiz 7
  • Change Default Powerpoint Option
  • Customize the Ribbon
  • Manage Add-ins & Security Options
  • Create Custom Themes
  • Customize Slide Masters & Layouts
  • Save Custom Presentation Template
  • Save Presentation in Other Formats
  • Restrict access by Using Password
  • Add & review Comments
  • Keyboard Shortcuts
  • Quiz 8

 

Master Quiz

Excel-Powerpoint-Word-MS-Office

Practice makes perfect

We know about your hectic schedule. We also know the only way you truly understand a subject is by practicing it in a real environment. This is why we’ve set a playground area that’s full of hours of exercises, questions and challenges.  

Learn from the very best

Join our course and start building the most wanted career available today. We make sure every class is easily understood, and that all students reach the same level of expertise needed for today’s hi-tech industry.

Working hours

Monday- Saturday: 9:00-18:30 Hrs
(Phone until 17:30 Hrs)

We are here

Digiayam, H. No. 130/132 , Danganj Bazar, Thana Cholapur, Varanasi, 221101

WhatsApp chat