Accredited & Recognized Excellence

Program Key Benefits

Master Skills: Industry-relevant skills with hands-on training from top corporate professionals.

Eligibility: Open to Any.

Expert Trainers: Led by Mr. Mani (10+ Yrs experience), successfully completing 100+ batches.

Program Duration: Comprehensive 1.5 - 2.5 Months training schedule.

Lifetime Access: Class Recorded Videos provided for lifetime review.

Doubt Clarification: Support via Live Classes, WhatsApp, and LMS.

Career Support: Resume Preparation.

Certificates: Free Training Completion Certificate (Soft Copy) provided.

Industry Terms & Tips: Coverage of Agile, Scrum, DevOps, Monitoring, and corporate career success strategies.

One-on-One Demo: Get Personalized Training & Clarifications before getting started.

Tools & Technologies Covered

FUNDAMENTALS INTERNET CONCEPTS MS WORD MS POWERPOINT MS Excel MS ACCESS MS OUTLOOK or GMAIL Advanced Excel VBA (VISUAL BASIC FOR APPLICATIONS) EMAIL ID CREATION FREE ENGLISH TYPING (Rapid) COURSE FREE COURSE COMPLETION CERTIFICATE FREE RESUME PREPARATION SUBMITTING RESUME IN NAUKRI, MONSTER, INDEED... LinkedIn Profile Creation Live Classroom & Online Classes Lifetime: Video Access Artificial Intelligence (AI) (ChatGPT, CoPilot 🗣️💡) Unlimited Lab

Complete Course Syllabus

Primary Parts of a Computer
Generations of Computers
Input and Output Devices
Memory Hierarchy Table
Software vs Hardware
Working with Paint
On-Screen Keyboard and Magnifier
Desktop Properties
Creating and Deleting Folders
Recycle Bin
Working with Notepad
Editing Text: Cut, Copy, Paste, Select All, Clear, Find and Replace
Typing Text and Text Alignment
Storage Devices
Windows Shortcut Keys

What is the Internet?
Browsing and Websites
Search Engines
Text Chatting
Creating Email Accounts and Sending Emails
Email Attachments
Online Job Searching and Interviews
Online Ticket Booking and Shopping
Downloading Files and Websites
Downloading Movies, Audio and Images
Uploading Movies, Audio and Images
Audio and Video Chatting
Creating and Using Social Media Accounts
Facebook, Instagram, X, YouTube and Other Platforms

Module 1: Text Basics
- Typing Text and Text Alignment
- Cut, Copy, Paste, Select All and Clear
- Find and Replace
Module 2: Text Formatting and Saving Files
- New, Open, Close, Save and Save As
- Font Size, Font Style and Font Color
- Bold, Italic, Underline and Change Case
- Line Spacing and Paragraph Spacing
- Text and Paragraph Shading
- Working with Tabs and Indents
Module 3: Working with Objects
- Shapes, Clip Art, Pictures, WordArt and SmartArt
- Adding Columns and Changing Object Order
- Page Numbers, Date and Time
- Inserting Text Boxes and Symbols
- Inserting Charts
Module 4: Headers, Footers and Section Breaks
- Inserting Custom Headers and Footers
- Inserting Objects in Headers and Footers
- Adding Section Breaks
Module 5: Bullets, Numbering and Page Design
- Multilevel Numbering and Bullets
- Creating Lists and Customizing List Styles
- Page Borders and Page Backgrounds
Module 6: Tables
- Working with Tables and Table Formatting
- Table Styles and Alignment Options
- Merging and Splitting Cells
Module 7: Styles and Content
- Using Built-in Styles and Modifying Styles
- Creating Styles and List Styles
- Table of Contents and References
- Adding Internal References, Footnotes and Endnotes
Module 8: Mail Merge and Document Merging
- Creating a New Address List
- Importing Address Lists from Excel
- Writing and Inserting Merge Fields
- Merging with Outlook Contacts
- Previewing Results
- Merging to Envelopes and Labels
- Setting Merge Rules and Finish & Merge Options
Module 9: Sharing and Maintaining Documents
- Changing Word Options and Proofing Tools
- Managing and Working with Templates
- Restricting Document Access
- Using Protected View
- Understanding Building Blocks
Module 10: Proofing Documents
- Checking Spelling as You Type
- Marking Grammar Errors as You Type
- Setting AutoCorrect Options
Module 11: Printing
- Page Setup and Setting Margins
- Print Preview and Printing

Module 1: Setting Up the PowerPoint Environment
- New, Open, Close, Save and Save As
- Typing Text and Text Alignment
- Font Size, Style, Color, Bold, Italic and Underline
- Cut, Copy, Paste, Select All and Clear Text
- Find and Replace
- Working with Tabs and Indents
Module 2: Creating Slides and Applying Themes
- Inserting, Duplicating, Copying and Pasting Slides
- Changing Slide Layouts
- Applying Themes and Changing Theme Colors
- Slide Background and Background Formatting
- Using Slide Views
Module 3: Bullets, Numbering and Text Formatting
- Multilevel Numbering and Bullets
- Creating Lists
- Page Borders and Backgrounds
- Text Alignment and Text Directions
- Working with Columns
Module 4: Working with Objects
- Shapes, Clip Art, Pictures, WordArt and SmartArt
- Changing the Order of Objects
- Inserting Slide Headers and Footers
- Text Boxes, Quick Styles and Symbols
- Inserting Charts
Module 5: Hyperlinks and Action Buttons
- Inserting and Editing Hyperlinks
- Inserting and Editing Action Buttons
- Working with WordArt and Shapes
Module 6: Working with Movies and Sounds
- Inserting Movies from Computer Files
- Inserting Audio Files
- Audio and Video Playback and Format Options
- Video Adjustments, Reshaping and Borders
Module 7: SmartArt and Tables
- Working with Tables and Table Formatting
- Table Styles and Alignment
- Merging and Splitting Cells
- Converting Text to SmartArt
Module 8: Animations and Slide Transitions
- Default and Custom Animations
- Modifying Animations
- Reordering Animations
- Applying and Modifying Slide Transitions
- Advancing to the Next Slide
Module 9: Using Slide Master
- Working with Slide Master
- Inserting Layouts and Creating Custom Layouts
- Inserting and Formatting Placeholders
Module 10: Slide Show Options
- Starting a Slide Show
- Starting a Show from the Current Slide
- Rehearsing Timings
- Creating Custom Slide Shows
Module 11: Proofing and Printing
- Checking Spelling and Setting AutoCorrect Options
- Saving as Video, JPEG Images and PowerPoint Show Files
- Print Preview and Printing

Module 1: Introduction to Excel
- Introduction to the Excel Interface
- Understanding Rows, Columns and Naming Cells
- Working with Workbooks and Worksheets
Module 2: Formatting Excel Workbooks
- New, Open, Close, Save and Save As
- Font Size, Style, Color, Bold, Italic and Underline
- Wrap Text, Merge and Center
- Currency, Accounting and Other Number Formats
- Modifying Columns, Rows and Cells
Module 3: Calculations and Functions
- Creating Simple Formulas and Custom Formulas
- Date and Time Functions
- Financial Functions
- Logical Functions
- Lookup and Reference Functions
- Mathematical, Statistical and Text Functions
Module 4: Sorting and Filtering Data
- Sorting and Filtering Data
- Number Filters and Text Filters
- Custom Filters and Removing Filters
- Conditional Formatting
Module 5: Charts and Data Visualization
- Inserting Column, Pie and Other Charts
- Using Chart Tools
- Design, Format and Layout Options
- Adding Chart Titles and Changing Layouts
- Chart Styles and Editing Data Ranges
- Editing Data Series and Changing Chart Types
Module 6: PivotTables and PivotCharts
- Understanding and Creating PivotTables
- Analyzing Data with PivotTables and PivotCharts
- Creating PivotCharts from PivotTables
- Inserting Slicers
- Creating Calculated Fields

Purpose and Importance of Email
Email Tips and Tricks
Creating Email Accounts
Inbox and Reading Emails
Composing and Sending Emails
Trash, Spam and Junk Emails
Labels and Email Organization
Managing Email Attachments

Introduction to Microsoft Access
Creating Databases
Creating Tables in Design View
Creating Tables Using the Table Wizard
Working with Database Tables
Creating and Using Forms
Creating and Using Reports
Creating and Running Queries

VLOOKUP and HLOOKUP
SUMIF and COUNTIF Functions
Attendance Sheet Calculations
Conditional Formatting
Fill Series and Growth
Go To Special
Cell Data Types
PivotTables
Inserting Excel Worksheets into Word
Defining Names
Date and Mathematical Functions
Advanced Filter
Text to Columns
Removing Duplicates
Data Consolidation
Goal Seek and PMT Function
Recording Macros
Payroll Preparation
Print Settings
Protecting Worksheets

Introduction to Macros
Creating and Running Macros
Saving Macros
Difference Between Macros and VBA
Enabling the Developer Tab
Introduction to VBA
Variables and Explicit Variables
Assigning Values to Variables
Formatting Cells Using VBA
Inserting and Deleting Worksheets
User Input for Calculations
Arithmetic Operations
MsgBox Function
If...Then...Else Statements
If, ElseIf and Nested Conditions
For Loops and Do Loops
Select Case Statements
Inserting Values into Cells
ListBox and ComboBox Controls
Creating Buttons and Checkboxes
Creating and Using UserForms
Creating and Deleting Files
Adding and Subtracting Dates
BMI Calculator
EMI Calculator
Prime Number Tester
Creating Custom Functions

On Reviews — What Our Students Say

★★★★★

"I am very happy to join the MS Office and Advanced Excel course at SivaSoft. Mani sir explains every topic clearly with practical examples. His teaching method makes even complex Excel concepts easy to understand. Thank you, Mani sir, for your excellent training and support!"