Office-Excel-thumbnail

MS Excel 2013

Office-word-thumbnail

MS Word 2013

Office-PowerPoint-thumbnail

MS Power-Point 2013

DVD Detail

Instructor By. Ali Haider
lesson. 270
Video Format. .MP4
DVDs. One
Home Delivery. All Over Pakistan
Availability. Yes



Course Outline…!!!

Microsoft Office Excel 2013

01  Introduction to MS Excel 02  Working Area (WorkSheet & WorkBook)
03  Interface (Quick Access Tool Bar) 04  Interface(Ribbon Concepts)
05  Interface (Formula Bar Concepts) 06  Working with Navigation
08  Back-Stage View 09  Status Bar Concept
10  Data Entry 11  Using AutoFil Function
12  Insert Date & Time 13  Using Comments
14  Use Undo & Redo 15  About Keyboard Keys
16  Basic Concept of Calculation 17  Simple Multiplication Calculation
18  Simple Addition Calculation 19  Simple Minus Calculation
20  Simple Divide Rule 21  Percentage Increase
22  Absolute & Relative Reference Cells 23  Use Some Auto Function
24  Use Some More Functions 25  Formatting Data
26  Text Alignment 27  Applying Borders
28  Formatting Date & Time 29  Formatting Numbers
30  Applying Table 31  Formatting Table
32  Rules of Less & Greater Than 33  Rules Equal & Between
34  Rules Text That Contain to Duplicate Values 35  Rules Top Ten & Bottom Ten
36  Using Data Bar 37  Using Color Scale
38  Using Icon Sets 39  Using Picture in WorkSheet
40  Using Shapes in WorkSheet 41  Using SmartArt in WorkSheet
42  Adding & Deleting Rows & Columns 43  Hide, Unhide Rows & Columns
44  Move & Copy Data 45  Find and Replace Data
46  Print Preview 47  Page Setup
48  Set Print Area 49  Set Print Title
50  Using Sheets Options 51  Creating Recommended Charts
52  Chart Types 53  Formatting Charts
54  Charts Elements 55  Using Spark-lines
56  Freezing and Unfreezing 57  Splitting Data
58  Using Outline 59  Adding & Deleting Remaining Sheets
60  Linking Formulas 61  Using Hyperlink in Multiple Worksheet &   Workbook
62  Function(Future Value) 63  Function (PMT Function)
64  Function (E-Date Function) 65  Function (Days360)
66  Function(IF Statement) 67  SumIF, AverageIF, countIF)
68  IF else IF Statement 69  V-Lookup Approximate
70  Prepare Student Mark-sheet 71  Using VlookUp in Mark-sheet
72  Using Vlookup IF 73  Protect Worksheet
74  Protect WorkBook Structure 75  Password Protected Workbook
76  Sharing Workbook 77  Using Track Changes
78  Sorting Excel Data 79  Using Filter
80  Remove Duplicates Values 81  Text to Column
82  Using Flash Fill 83  Using Consolidation
84  Convert into Group Data 85  Using Subtotal
86  Creating Pivot Table 87  Manipulating Pivot Table
88  Creating Groups 89  Grouping Other
90  Using Slicer 91  Using Goal Seek
92  Using Scenario Manager 93  Using Data Table
94  What are Macros 95  Record Macro
96  Running Macro    

 

 

Microsoft Office Word 2013

01  Introduction & Installation of  Word 2013 02  Create Word Shortcuts
03  User-Interface Part I 04  User-Interface Part II
05  Create Ms Office Account 06  How to Sign-In in Office Account
07  How to use One Drive for File Saving 08  How to use One Drive for File Open
09  How to Insert Online Image 10  Verbalize Back-stage Area
11  Info & New document 12  Using Templates
13  Save & Save As document 14  Convert PDF to Word document 
15  Print Setup 16  Auto Book-Mark
17  Text Insert & Replace 18  Selection of Text
19  Cut,Copy & Paste 20  Find,Replace & Goto
21  Undo & Redo 22  Fonts
23  Font Scripts 24  Font Cases
25  Fonts Colours 26  What About Paragraph
27  Paragraph Alignment 28  Paragraph & Line spacing
29  Keep Text Together 30  Paragraph Border & Formatting
31  Bullet & Numeric List 32  Creating Level
33  Create Multilevel List 34  Format Multilevel List
35  Apply quick Style 36  Using Theme & Style
37  Insert Image & Shapes 38  Organize Images with Table
39  Format Image 40  Crop Images
41  Edit one Shapes to another 42  Shapes Format
43  Editing & Formatting Text in Shapes 44  Arrangement Shapes & Image
45  Insert Smart Art 46  Format Smart Art
47  Insert Diagram 48  Format Diagram
49  Insert Screen Shot 50  How to Create Table
51  How to Convert Text to Table 52  Formatting Table
53  Table Layout-1 54  Table Layout-2
55  How to Create Quick Table 56  How to convert Tale to Text
57  How to Sort Data On a Table 58  Create Hyperlink
59  Using Bookmark 60  Using Text-box & Word Art
61  Insert Time & Date 62  Using Equation
63  Using Symbols 64  Page Cover
65  Page Setting 66  Apply Image For Page Background
67  Insert Header & Footer 68  Insert Page Number
69  Insert Page Border 70  Hyphenation
71  Insert Page Breaks 72  Insert Columns Breaks
73  Paragraph Spacing 74  Tab & Indent
75  Insert Table of Content 76  Insert Footnotes & EndNote
77  Create Bibliography 78  Insert Bibliography
79  Create Envelope 80  Format Envelope
81  Create Labels 82  Create Database For Mail-merge
83  Start Mail Merge 84  Insert Merge Field
85  Individual Mail Merge 86  Create mail marge envelope
87  Create Mail Merge Labels 88  Check Spelling & Grammar Mistake
89  Proofing your Documents 90  Restrict Editing
91  Restrict your Document 92  Insert Comments in a Document
93  Apply Track Changes 94  Comparison with Revised Documents
95  Different Views of Documents 96  Views Documents with Zooming Option
97  Working with Multiple Windows 98  Create Macro
99  Apply Macros 100  Edit in Macro
101  Download External Fonts 102  Install & Apply External Fonts
103 Word Prefrences

 

 

Microsoft Office Power-Point 2013

01  Touring PowerPoint 02  How to Run PowerPoint
03  How to Open PowerPoint File 04  How to Save PowerPoint File
05  Interface(PowerPoint Working Area) 06  Interface (Ribbon Concept)
07  Interface(Quick Access Tool bar Concepts) 08  Interface(Status Bar Concept)
09  PowerPoint Backstage Concept 10  Start Presentation Root Level
11  Uses of Theme & Templates 12  Changes Theme
13  Customize Slides Background 14  Work Space Views
15  Important Concepts of Master-views 16  Apply Header & Footer
17  Adding, Duplicating & Delete Slides 18  Create your Self Customize Layout
19  Create Sections in Presentation 20  How to Sort Slides
21  Bulleted List and Numeric List 22  Using outline View
21  Insert WordArt 23  Uses of Text-box
24  Insert Table & Formatting Tables 25  Insert Picture
26  Alignment Picture & Object 27  Formatting Pictures with Effects
28  Object Layering 29  Crop Picture
30  Removing Picture Background 31  Use Eyedropper Tool New Feature
32  Uses of Screen Clipping 33  Insert Shapes
34  Format Shapes 35  Crop Picture to Shape Element
36  Merging Multiple Shapes New Feature 37  Using SmartArt
38  Insert Diagram 39  Embed Microsoft Excell File
40  Creating Equation 41  Adding Video
42  Working with Video 43  Adding Audio File
44  Adding Slides Transition 45  Controlling Slides Transition
46  Adding Animation 47  Adding More Animation
48  Controlling Animation 49  Use Different Types of Animation
50  Adding Animation in Object  51  Adding Trigger Effect
52  Checking Spelling Errors 53  Speaker Notes
54  Adding Comments in Slides 55  Presentation Rehearse Timing
56  Reviewing The Presentation 57  Print The Presentation File
58  Handouts Layout 59  Running The Slide Show
60  Broadcast Your Presentation 61  Use Custom Slides Show
62  Setup Slides Show 63  Use Presenter View
64  Use Intonation & Highlights 65  Save Customize Theme
66  Save Customize Templates 67  Record Narration
68  Publish For PDF & JPEG 69  Save As Video File
70  Send As E-mail 71  Create Complete Pakage For Users
72  Good Bye- END