01 Introduction
02 Solve Online Quiz on MS word, Excel & PowerPoint & Download Exercise & Exercise File
03 New,Open, Save & Save As
04 Cut,Copy & Paste
05 Find,Replace,Find Next & Replace All
06 Fonts,Font Size & Font Block Options
07 Using Undo & Redo Option
08 Using Border,Font Color & Fill Color options
09 Using Text Alignment & Indent Options
10 Using Orientation In Hindi
11 Using Format Painter
12 Using Wrap Text & Merge & Center Options
13 Formatting, Numbers Dates & time
14 Using Conditional Formatting In a Workbook
15 Using Format As Table & Cell Styles Options
16 Insert & Delete Rows, Columns, Cells & Sheet
17 change Row height and Column width
18 Hide and Unhide option
19 Rename & Copy
20 Fill Months,Days,Date & Number | 21 Using Sort & Filter Options
22 Mini Toolbar & Shortcut Menu
23 Using Quick Access Toolbar
24 Use of Status Bar to find sum, average etc
25 Remove Formatting, Comments & Hyperlinks using Clear Function
26 Sum, Subtraction, Division, Multiplication etc
27 Clipboard
28 Paste Special
29 Copy Conditional Format, Column Width Number Format By Paste Special
30 Paste Special to Transpose From Vertical to Horizontal
31 Data Validation Option For Whole Number & Error Alerts
32 Create Validation For Decimal Number & Other Data Option
33 Create Drop Down Menu & Set Character Limit
34 Limit For Date & Time Using Data Validation Option
35 Preventing Duplicate Entries & Allow Text / Numbers Only |
|
|