Course Description

OVERVIEW:

After completing Microsoft Office Basic to Advance via Online Video Training Course in Urdu and Hindi. You will be able to navigate, Personalize, working on different Microsoft Office workplace and manage or control the user interface. Microsoft Office is a suite of productivity software developed by Microsoft. It includes a range of applications that are widely used for various business, educational, and personal tasks.

INTRODUCTION:

Microsoft Office is a suite of productivity software developed by Microsoft, widely used in both professional and personal environments. It consists of several key applications, each serving different purposes. The core programs in Microsoft Office include:

Microsoft Word: A word processing application used for creating, editing, and formatting documents. It's ideal for writing reports, letters, resumes, and essays.

Microsoft Excel: A spreadsheet program used for data analysis, calculations, and visualizing data through charts and graphs. It includes powerful tools for managing and analyzing large sets of data.

Microsoft PowerPoint: A presentation software used to create slideshows, combining text, images, charts, and multimedia elements. It’s commonly used for educational and business presentations.

Microsoft Access: A database management system that allows users to store, organize, and manipulate large amounts of data. It's designed for managing relational databases.

PREREQUISITES:

Before starting this course, you should have a working knowledge of Following:

• Basic computer
• Introduction to computer

This training is compatible with Windows & MAC operating system.

CERTIFICATION:

You are hereby advised to visit www.virtualacademy.pk and get yourself certified in Microsoft Office Training, furthermore you'll have to meet the following criteria for earning this particular Registered Certification.

• You will have to complete all 129 lessons through Virtual Academy Online Learning Management System at www.virtualacademy.pk.
• Every lesson has 3 to 5 quizzes, which you must have to pass with 70% marks.
• You need to submit your project/assignments on time.

After completion of Virtual Academy offered Microsoft Office Training, Lessons via www.virtualacademy.pk Online Learning Management System there will be final exam which comprises of 50 to 100 questions.

After having assessment of your account with www.virtualacademy.pk whether you meet all the above terms and conditions, then we will dispatch your Certificate/Diploma at your given address.

Course Contents

Microsoft Word Outline

Module 1: Introduction to Microsoft Word

• Overview of Microsoft Word Interface
• Ribbon, Tabs, Groups, and Commands
• Creating, Opening, and Saving Documents
• Typing and Editing Text
• Navigating the Document (Scroll, Find, Replace)

Module 2: Basic Document Formatting

• Fonts and Font Styles (Bold, Italics, Underline)
• Paragraph Formatting (Alignment, Line Spacing, Indentation)
• Bullets and Numbering
• Applying Themes and Quick Styles
• Using Templates

Module 3: Page Layout and Design

• Setting Page Margins and Orientation
• Page Breaks and Section Breaks
• Headers, Footers, and Page Numbers
• Creating and Customizing Tables
• Adding Columns

Module 4: Inserting Elements

• Inserting Images and Shapes
• Adding and Formatting Text Boxes
• Working with Charts and SmartArt
• Using Symbols and Equations
• Adding Hyperlinks

Module 5: Document Review and Collaboration

• Track Changes and Comments
• Comparing Documents
• Spell Check, Thesaurus, and Grammar Tools
• Protecting Documents (Password Protection)
• Sharing and Collaborating via OneDrive or SharePoint

Module 6: Advanced Features

• Creating and Formatting Tables of Contents
• Using References and Citations
• Mail Merge (Letters, Labels, and Envelopes)
• Using Macros to Automate Tasks
• Creating Forms and Fillable PDFs

Microsoft Excel Outline

Module 1: Introduction to Microsoft Excel

• Overview of the Excel Interface
• Creating and Saving Workbooks
• Navigating Worksheets and Workbooks
• Data Entry and Basic Formatting

Module 2: Working with Cells, Rows, and Columns

• Selecting, Moving, and Copying Data
• Inserting and Deleting Rows/Columns
• Formatting Cells (Text, Numbers, Dates)
• Using Conditional Formatting

Module 3: Formulas and Functions

• Basic Arithmetic Formulas (Sum, Subtraction, Multiplication, Division)
• Understanding Cell References (Relative, Absolute)
• Common Functions (SUM, AVERAGE, MAX, MIN, COUNT)
• Text and Date Functions

Module 4: Data Visualization with Charts

• Creating Charts (Column, Line, Pie, Bar)
• Formatting and Customizing Charts
• Sparklines for Quick Data Visualization
• Adding Trendlines and Data Labels

Module 5: Data Management

• Sorting and Filtering Data
• Using Data Validation
• Working with Tables
• Creating PivotTables and PivotCharts

Module 6: Advanced Excel Features

• Using VLOOKUP and HLOOKUP Functions
• IF Statements and Nested Functions
• Data Analysis with What-If Analysis (Goal Seek, Data Tables)
• Using Macros for Automation
• Importing and Exporting Data

Microsoft PowerPoint Outline

Module 1: Introduction to Microsoft PowerPoint

• Overview of the PowerPoint Interface
• Creating and Saving Presentations
• Navigating Between Slides
• Understanding Slide Layouts

Module 2: Creating Effective Slides

• Inserting and Formatting Text Boxes
• Working with Slide Masters and Themes
• Inserting and Formatting Images
• Adding Tables, Charts, and SmartArt
• Using Shapes and Icons

Module 3: Multimedia and Animations

• Adding Videos and Audio to Slides
• Applying Animations to Text and Objects
• Using Slide Transitions
• Timings and Triggers for Animations

Module 4: Delivering Presentations

• Setting Up Slide Show (Presenter View, Slide Show Mode)
• Rehearse Timings and Slide Show Recording
• Printing Slides, Handouts, and Notes
• Exporting Presentations as PDFs or Videos
• Sharing Presentations Online

Module 5: Advanced PowerPoint Features

• Using Slide Master for Consistency
• Inserting Hyperlinks and Action Buttons
• Collaborating with Others Using OneDrive or SharePoint
• Custom Slide Shows and Sections
• Using Design Ideas (PowerPoint Designer)

Microsoft Access Outline

Module 1: Introduction to Microsoft Access

• Overview of the Access Interface
• Understanding Databases and Database Concepts
• Creating and Managing Tables
• Navigating Between Records

Module 2: Designing and Creating Tables

• Understanding Data Types (Text, Numbers, Dates, Currency)
• Creating Primary Keys
• Defining Field Properties and Data Validation
• Using Input Masks for Data Entry

Module 3: Working with Queries

• Introduction to Queries (Select, Update, Delete)
• Using Criteria and Sorting in Queries
• Creating Parameter Queries
• Working with Aggregate Functions (SUM, AVG, COUNT)

Module 4: Forms and Reports

• Designing and Creating Forms for Data Entry
• Adding Controls (Text Boxes, Buttons, Combo Boxes)
• Customizing Form Layout and Appearance
• Designing Reports for Data Output
• Grouping and Sorting Data in Reports

Module 5: Data Relationships

• Understanding Relationships and Joins
• Enforcing Referential Integrity
• Using Lookup Fields
• Creating One-to-Many and Many-to-Many Relationships

Module 6: Advanced Access Features

• Creating Action Queries (Append, Make-Table)
• Automating Tasks with Macros
• Building Switchboards and Navigation Forms
• Importing and Exporting Data (Excel, SQL)
• Securing and Encrypting a Database