MICROSOFT OFFICE 2016
Microsoft Office is one of the most commonly used software including Microsoft Word, Microsoft Excel and Microsoft PowerPoint. Students pay thousands of rupees to learn Microsoft Office from different institutes. Through this platform, you can learn complete Microsoft Office 2016 without paying any amount. After learning Microsoft Office 2016, you can operate any version of Microsoft Office like 2013, 2010, 2019, etc. There are minor changes in all versions, but almost features remain same.
Now, students ask what about certificate? We get certificates from institutes. Will we get certificate? So the answer is NO. You will not get certificate from this platform. Computer skills do not require certificate in practical field. You just have to know how to perform work efficiently.
After watching vides, you will be able to operate Microsoft Office.
Now, students ask what about certificate? We get certificates from institutes. Will we get certificate? So the answer is NO. You will not get certificate from this platform. Computer skills do not require certificate in practical field. You just have to know how to perform work efficiently.
After watching vides, you will be able to operate Microsoft Office.
MICROSOFT WORD 2016
1-Introduction
2-View Button & Backstage View
3-Entering Text & Move Around
4-Quick Access Toolbar & Saving a Document
5-Using Zoom & Changing Window Views
6-Find, Replace & GoTo
7-AutoCorrect & Replace Text
8-Cut, Copy, Paste, Format Painter & Printing a Document
9-Font, Font Size, Bold, Italic & Underline
10-Superscript, Subscript & Change Case
11-Applying Styles & WordArt
12-Character Spacing, Text from other File & Formatting other Format Documents
13-Alignment, Setting Indents & Line Spacing & Paragraph Spacing
14-Bullets & Numbering & Setting & Modifying Tab
15-Margins, Size, Orientations, Columns & Breaks
16-Creating Text Box & Formatting Text Box
17-Creating a Table & Formatting a Table
18-Applying Styles to Table & Managing Table
19-Merging & Splitting Table Cells, Conversion of Table & Text, Formulas
20-Theme & Background, Watermark, Quick Parts, Date & Time, Equation & Symbols
21-Inserting Pictures & Screenshot & Formatting Pictures
22-Inserting & Formatting Shapes, SmartArt Graphics & Chart
23-Formatting Chart, Table of Contents & Hyperlink
24-Header & Footer & Bookmark
25-Mail Merging, Page Border, Spelling & Grammar & Thesaurus
26-Creating an Admission Form
27-Formatting Text, Bullets & Numbering, WordArt, Proofing & Text Box
MICROSOFT POWERPOINT 2016
1-Introduction, Blank Presentation, Inserting Text & Saving Presentation
2-Templates, Adding, Organizing & Deleting Slides, Reusing Slides & Print
3-Formatting Text, Bullets & Numbering, WordArt, Proofing & Text Box
4-Themes & Layout, Slide Background, Inserting Date, Footer & Slide Number
5-Working with Sections & Hyperlink
6-Slide Master:Themes, Adding Elements, Background & Creating New Layout
7-Tables:Modifying, Adding & Deleting Rows & Columns, Merging & Splitting Cells
8-Formatting Tables: Changing Alignment & Applying Styles
9-Charts: Building, Modifying & Formatting Chart
10-SmartArt Graphics
11-Pictures
12-Shapes
13-Slide Transition
14-Animation
15-Adding Media
16-Delivering Presentation
17-Recording Slide Show
MICROSOFT EXCEL 2016
1-Introduction to Excel
Microsoft Excel 2016 - Entering & Editing Data
3-Auto Fill & Flash Fill
4-Basic Formulas # 1
5-Basic Formulas # 2
6-Formatting Cell Contents # 1
7-Formatting Cell Contents # 2
8-Conditional Formatting # 1
9-Advanced Conditional Formatting
10-Formatting Worksheets
11-Managing Worksheets
12-Freeze Panes, Find & Replace
13-Data Validation
14-Sorting Data
15-Filtering Data & Custom Filter
16-Grouping & Subtotal
17-Macros
18-Charts
19-Pictures & Shapes
20-Pivot Table
21-Basic Functions: Sum, Count, Counta, Countblank, Average, Min, Max
22-Advanced Formulas: Sumif, Sumifs, Countif, Countifs, Averageif, Averageifs
23-Creating Marksheet using IF Formula
24-Vlookup Formula
25-Hlookup Formula
26-IF, AND, OR Functions
27-Useful Excel Short Keys
ADVANCED EXCEL
1- Salary Sheet by using IF Function
2- Sales Report by using IF, AND, OR Function
3- Conditional Formatting with IF & AND Function
4- DATEDIF Function: Calculating Number of Year, Months & Days
5- Income Tax Calculator using Vlookup, IF & AND Function
6- Statistical Functions: Average, Median, Mode, Range, Frequency
7- Financial Functions: PMT, PV, Rate, NPER, FV
8- Depreciation Methods
9- Automatic Attendance Sheet with Salary
10- Fully Automatic General Journal & Trial Balance
11- Fully Automatic General Ledger
12- Fully Automatic Income Statement
13- Fully Automatic Balance Sheet
2- Sales Report by using IF, AND, OR Function
3- Conditional Formatting with IF & AND Function
4- DATEDIF Function: Calculating Number of Year, Months & Days
5- Income Tax Calculator using Vlookup, IF & AND Function
6- Statistical Functions: Average, Median, Mode, Range, Frequency
7- Financial Functions: PMT, PV, Rate, NPER, FV
8- Depreciation Methods
9- Automatic Attendance Sheet with Salary
10- Fully Automatic General Journal & Trial Balance
11- Fully Automatic General Ledger
12- Fully Automatic Income Statement
13- Fully Automatic Balance Sheet