MS.Office 2013 in Urdu – Video training course


php&mySQL in URDU
By:
Awais Kamran
Lessons:
250
Duration:
17 Hours
DVDs:
2
Formate:
.MP4 (HD)
Language:
Urdu
Skills Required:
Besic Computer Knowladge.
Home-Delivery:
in Pakistan Only
Available:
Yes
Watch Demo

Price= 3000/-

Order Now

Course Outlines
MS.Excel 2013 – Duration : 7 Hours
Chapter 1 – Introduction
1.
Welcome
2.
How to Use Exercise files
Chapter 2. Getting Started with Excel 2013
1.
Excel Uses
2.
Menu
3.
Quick Access
4.
Worksheet
5.
Formula bar
6.
Status
7.
Naviagation
8.
Shortcut Menu
9.
Help
10.
Files
Chapter 3. Entering Data
1.
Data Entry
2.
Autofill
3.
Dates and times
4.
Undo and Redo
5.
Comments
6.
File Save
Chapter 4. Creating Formulas and Functions
1.
Simple Formulas
2.
Copy Formulas
3.
YTD
4.
PctInc
5.
Absolute
6.
SUMAverage
7.
Other Functions
Chapter 5. Formatting
1.
Fonts
2.
Column width
3.
Alignment
4.
Borders
5.
Numeric
6.
Date Time
7.
Conditional Formatting
8.
Formatting for tables
9.
Inserting Visuals
Chapter 6. Adjusting Worksheet Layout and Data
1.
Insert Delete
2.
Hide Unhide
3.
Move and Copy
4.
Find and Replace
Chapter 7. Printing
1.
Page Layouts
2.
Page Break
3.
Page Setup
Chapter 8. Introduction to Charting
1.
Creating Charts
2.
Chart Types
3.
Formatting
4.
Chart Elements
5.
Sparkline
Chapter 9. Adjusting Worksheet views
1.
Freezing, unfreezing pans
2.
Split
3.
Outlining
Chapter 10. Multiple worksheets and workbooks
1.
Rename
2.
Move and Copy
3.
Linking Formulas
4.
Managing Links
Chapter 11. IF, VLOOKUP, and Power Functions
1.
If Function
2.
VLookup Approximate
3.
VLookup Exact
4.
Countif
Chapter 12. Security and Sharing
1.
Protect Worksheet
2.
Protect Workbook
3.
Workbook Password
4.
Sharing Workbook
5.
Tracking Changes
Chapter 13. The database feature of Excel
1.
Sorting
2.
Subtotal
3.
Using Filter
4.
Splitting
5.
Removing duplicates
Chapter 14. Pivot Tables
1.
Create Pivot Tables
2.
Manipulating Pivot Table
3.
Grouping
4.
Grouping Other
5.
Slicers
6.
Pivot Chart
Chapter 15. Data Analysis Tools
1.
Goal Seek
2.
Solver
3.
Using Scenario
4.
Data Table
Chapter 16. Macros
1.
Macro Definition
2.
Create Macro
3.
Run Macro
MS.Word 2013 – Duration : 7 Hours
Chapter 1 – Introduction
1.
Welcome
2.
How to Use Exercise files
3.
Chapter 2. Getting Started with Word 2013
1.
User Interface
2.
Back Stage Area
3.
Reading Documents
4.
Book Mark
5.
Using Templates
6.
Save & Save as
7.
Opening and Saving Doc
8.
Printing Documents
Chapter 3. Editing Text
1.
Insert and Replace Text
2.
Selecting Text
3.
Cut, Copy & Past Text
4.
Find, Replace and Goto
5.
Undo and Redo
6.
Chapter 4. Formatting Text
1.
Fonts
2.
Font Case
Chapter 5. Using Paragraph Formatting
1.
Paragraph Alignment
2.
Line & Paragraph Spacing
3.
Keep Text Together
4.
Paragraph Border, Shading
Chapter 6. Formatting Pages
1.
Pages
2.
Using Header and Footer
3.
Watermark & BG Color
Chapter 7. Formatting Styles and Themes
1.
Themes
2.
Using Quick Styles
3.
Editing and Creating Styles
Chapter 8. Creating Bulleted and Numbered Lists
1.
Bulleted & Numbered Lists
2.
Formatting Lists
3.
Levels
4.
Creating Multilevel Lists
Chapter 9. Working With Tables
1.
Creating Tables
2.
Text to table
3.
Formatting Tables
4.
Changing Table Layout
5.
Using Quick Table
6.
Sorting Table Contents
7.
Table to Text
Chapter 10. Illustrating Your Document
1.
Inserting Images
2.
Manipulating Pictures
3.
Pictures in Borders
4.
Picture Effects
5.
Adjusting Pictures
6.
Word Art
7.
Inserting Screen Shots
8.
Inserting Charts
Chapter 11. Using Macros
1.
Recording Macros
2.
Playing Macros
3.
Editing Macros
Chapter 12. Proofing Your Document
1.
Spelling & Grammar Check
2.
Proofing Options
3.
Research Tools
Chapter 13. Reviewing Documents with Others
1.
Comments
2.
Tracking Changes
3.
Comparing documents
Chapter 14. Sharing Documents with Others
1.
Preparing for Sharing
2.
Sharing in Email
3.
Protecting Document
4.
Restricting Editing
Chapter 15. Customizing Word
1.
Basic Customization
2.
Advance Customization
3.
Customizing Ribbon
4.
Quick Access Tool
MS.Access 2013 – Duration: 6 Hours & 40 Minutes
Chapter 01- Introduction
1.
Introduction
2.
Exercise Files
Chapter 02- Getting Started
1.
Basic Concepts
2.
Launching Access
3.
Creating Database
4.
Trust Centers
5.
Ribbon Of Access
6.
Access Navigation
7.
Quick Access Tool Bar
8.
Taking Backup
Chapter 03-Creating Tables
1.
Relations & Tables
2.
Create Customer Table
3.
Entering Records
4.
Credit Card & Foreign Key
5.
Importing Excel File
   
Chapter 04-Setting Field Properties
1.
Relations Between Tables
2.
Different Views
3.
Input Masks
4.
Default Values
5.
Data Validation
6.
Drop Down List
7.
Some More Properties
Chapter 05- Organizing Records
1.
Text Formatting in table
2.
Sorting Data in Table
3.
Filtering Records
4.
Find And Replace
Chapter 06- Queries
1.
What are queries?
2.
Queries with wizard
3.
Query in Design view
4.
Using Criteria in queries
5.
Using Wild Cards in Queries
6.
Operators in Queries
7.
Comparison Operators in Queries
8.
User Input Parameters
9.
Expression builder Part 1
10.
Expression Builder Part 2
11.
Statistic Query
Chapter 07- Working With Special Queries
1.
Updating Records in Query
2.
Saving Query Result…
3.
Deleting Records
4.
Appending Data with Query
5.
Using Cross Tab Query
6.
Using Union Query
Chapter 08- Creating Forms
1.
Forms Overview
2.
Generating Forms
3.
Changing Layout of Forms
4.
Generate Form with Wizard
Chapter 09- Designing Forms
1.
Forms in Design View
2.
Form Properties
3.
Data Source of Forms
4.
Forms Control part 1
5.
Forms Controls Part 2
6.
Text Field into input Box
7.
Combo Box Search Records
8.
Using Buttons in Forms
9.
Controlling Tab Sequence
10.
More Forms Multiple
11.
More Forms Splits
12.
Creating Navigation Form
Chapter 10- Reports
1.
One Click report
2.
GenerateReport with Wizard
3.
Editing Report in Design
4.
Order and Sort the report
5.
Calculated values in Reports
6.
Conditional Formatting
7.
Generating Mailing Lists
8.
Print Preview
Chapter 11- Macros
1.
Creating Macro
2.
Embedding Macros
3.
Data Macros
4.
autoexecuteable Macro
Chapter 12- Integrating Access with Office Suit
1.
Exporting Data to Excel
2.
Sending Database as Email
3.
Mail Merge with Access
Chapter 13- Maintaining the Database
1.
Custom Groups
2.
Database Compact&Repair
3.
Object Dependency
4.
Documentation
5.
Blueprinting Entire Database
6.
Splitting Database
7.
Applying and Removing Password
8.
Creating custom Tab
9.
Final Touch and Goodbye
MS.Powerpoint 2013 – Duration: 3 Hours & 10 Minutes
Chapter 01- Introduction
1.
Introduction
2.
Exercise files
Chapter 02- Navigating Power Point
1.
Touring Power point 2013
2.
How Does Ribbon Work
3.
Status Bar
4.
Using Different views
Chapter 03- Working with presentation
1.
Presentation from scratch
2.
Themes and templates
3.
Changing themes
4.
Using slide master
5.
Header & footer
6.
Backstage
Chapter 04- Working with slides
1.
Adding & Deleting Slides
2.
Creating your own layout
3.
Creating sections in presentation
4.
Sorting slides
Chapter 05- Adding pictures to slides
1.
Adding pictures
2.
Aligning objects
3.
Adding effects to image
4.
Object layering
5.
Removing backgrounds
6.
Using eye dropper tool
7.
Inserting Screen shots
       
Chapter 06- Adding contents to Slides
1.
Bulleted and numbered lists
2.
Using outline view
3.
Using word art
4.
Using text boxes
5.
Inserte and formate tables
Chapter 07- Adding shapes and diagrams
1.
Adding shapes
2.
Formatting shapes
3.
Crop to shape element
4.
Merging shapes
5.
Charts in power point
6.
Embedding excel charts
7.
Using smart art
8.
Creating equation
Chapter 08- Adding video, audio and animation
1.
Adding video to slide
2.
Working with video
3.
Inserting audio file
4.
Slide transition
5.
Content animation
Chapter 09- Preparing the presentation
1.
Checking spelling
2.
Speaker notes
3.
Handouts
4.
Rehearse timing
5.
Comments
6.
Reviewing the presentation
Chapter 10- Delivering your presentation
1.
Running the slide show
2.
Using presenter view
3.
Intonation and highlights
Chapter 11- Reusing and sharing presentation
1.
Saving theme
2.
Saving as template
3.
Recording narration
4.
Save presentation as video
5.
Exporting as PDF and JPEG
6.
Send presentation as email
7.
Creating package

© 2014 UrduDVDs.com. All rights reserved. Premium theme by ThemeSmarts