MS Office 2019

Course Content

3 sections • 97 lectures • 15h 19m total length

	00 Intro - Interface-1		4min
	01 Home Tab - Font n Formatting-2		13min
	02 Home Tab - Text Effects n Typography-3		10min
	03 Home Tab - Advanced Font Options-4		11min
	04 Home Tab - Paragraph Menu-5		11min
	05 Home Tab - Alignment n Spacing-6		5min
	06 Home Tab - Paragraph More Options-7		4min
	07 Home Tab - Paste Special-8		12min
	08 Home Tab - Styles-9		6min
	09 Home Tab - Find-10		6min
	10 Home Tab - Wildcard Find-11		14min
	11 Home Tab - Find n Replace Goto-12		17min
	12 Insert Tab - Table-13		7min
	13 Insert Tab - Illustrations-14		13min
	14 Insert Tab - Addins n Links-15		15min
	15 Insert Tab - Header n Footer-16		12min
	16 Insert Tab - Textbox Wordart Quickparts Objects-17		19min
	17 Insert Tab - Symbols n Equations-18		7min
	18 Design Tab - Complete-19		16min
	19 Layout Tab - Page Setup n Page Break-20		7min
	20 Layout Tab - Section Break-21		20min
	21 Layout Tab - Line Number Hyphenation-22		14min
	22 References Tab - Table of Contents-23		10min
	23 References Tab - Citations n Captions-24		12min
	24 References Tab - Index Table of Authorities-25		10min
	25 Mailing Tab - Envelopes n Labels-26		3min
	26 Mailing Tab - Mail Merge-27		21min
	27 Mailing Tab - Mail Merge Wizard-28		3min
	28 Review Tab - Proofing n Comments-29		11min
	29 Review Tab - Track changes n Compare-30		12min
	30 Review Tab - Restrict Editing-31		4min
	31 Draw Tab - Brief-32		2min
	32 View Tab - Complete-33		16min
	33 View Tab - Macros-34		7min
	34 File Tab - Properties n Word Options-35		6min
	35 Hindi Typing-36		3min

	01 Home Tab		9min
	02 Insert Tab		8min
	03 Zoom		8min
	04 Design Tab		5min
	05 Transition		4min
	06 Animation Tab		12min
	07 Slide Show Tab		10min
	08 Record Slide Show		8min
	09 Review-View Tab		7min
	10 Saving Presentation		5min
	11 Recording Video		3min

	01 An Overview		4min
	02 Basics of Excel		6min
	03 Font n Alignment		13min
	04 Number Format - Text, Number, Currency, Accounting, Date, Time		9min
	05 Number Format - Percentage, Fraction, Scientific		12min
	06 Number Format - Digit Grouping, Custom Formats		8min
	07 Conditional Formatting - Writing Data		12min
	08 Conditional Formatting - Rules		10min
	09 Conditional Formatting - Color Scales, Manage Rules, Styles		10min
	10 Cells - Insert, Delete, Format		8min
	11 Editing - Fill, Flash Fill, Clear, Sort n Filter		12min
	12 Insert - Pivot Table Creation		12min
	13 Pivot Table - Analysis		11min
	14 Recommended Pivot Table		9min
	15 Charts, Maps, Sparklines		13min
	16 Insert - Slicer, Timeline, Header Footer, Symbols		7min
	17 Page Layout		18min
	18 Formulas Tab - Function, Name Manager		16min
	19 Formula Auditing, Watch Window, Calculation		9min
	20 Formulas - Sum, Average, Count, Max, Min		7min
	21 Formulas - EMI Calculation (PV, Rate, NPER, PMT)		14min
	22 Formulas - Financial (Future Value, PER, IPMT, PPMT)		11min
	23 Formulas - Depriciation (DB)		8min
	24 Formulas - Logical Functions (If, And, Or)		6min
	25 Formulas - Logical Functions Combination (If, And, Or, Not)		11min
	26 Formulas - Text Functions (Trim, Left, Right, Mid)		6min
	27 Formulas - Text Function (Find)		7min
	28 Formulas - Text Function (Replace)		3min
	29 Formulas - Text Functions (Concatenate, Upper, Lower, Proper)		4min
	30 Formulas - Date n Time (Now, Date, Days360)		11min
	31 Formulas - Today, Day, Month, Year, Hour, Minute, Networdays, Networkdays.Intl		7min
	32 Formulas - Lookup (V Lookup)		9min
	33 Formulas - VLookup (Absolute Reference, Exact Match)		15min
	34 Formulas - Vlookup (Approximate Match)		5min
	35 Formulas - Lookup (HLookup)		5min
	36 Formulas - Lookup (Match, Index)		9min
	37 Formulas - ABS, Log, Power, Fact, Rand, Randbetween, Decimal, Dec2Hex, Base, Hex2Dec		13min
	38 Formulas - SumIf		8min
	39 Data - Get Data, Connections, Filter		10min
	40 Data - Advance Filter		13min
	41 Data - Text to Columns, Remove Duplicates		20min
	42 Data - Validation		6min
	43 Data - Consolidate		11min
	44 Data - Whatif Analysis (Scenario Manager, Goal Seek)		11min
	45 Data - Whatif Analysis (Data Table)		11min
	46 Data - Forecast Sheet		4min
	47 Data - Group, Ungroup, Subtotal		9min
	48 Workbook Views, Zoom, Arrange, Freezepanes, Split, Switch Windows		9min
	49 Macros		8min
	50 Review - Proofing, Comments, Protect, Ink(Draw)		7min