I Turn Institute MS Office Training – Basic to Advance(DVD)

Description

Excel Content: Excel structure, Cell properties, autofill value, text and date, Operators based and Math Equation, Text Function – Upper, Lower, Proper, Trim, Right, Left, Find and task, MID, Concatenate, Replace, Substitute, Len, Rept, Excat, Search, text to column,workbook protect, protect sheet, Hide Formulas and unlocked Cell, Protect File with password, If Function and Nested If, AND , OR Function, Pivot Table, goal seek, scenario manager, EMI calculator, Create Loan Table, Print option, share book, Chart Preperation, Conditional Formatting, Data Validation, Using of Wild Card in Math Function, Vlookup Function and nested if, Vlookup with Iferror, Hlookup, Match, Index and match nested, Vlookup array, Macro Recording. Access Content: access intro, Create table in MS Access, How to Import and Export in Access, create form from table, Create Blank Form in Access, Creating Report in Access, Query in access MS Word Content: MS Word Introduction, Ms word Font Formatting, Paragraph options, bullets and numbering, sorting option, Page , Cover page, page break, Creating Table in Word, pictures , Shapes , SmartArt , Chart and Screenshot, Bookmark and Cross Reference, Hyperlink, Header and Footer and Page no, Text box, wordart, Drop Cap and symbols, Quick Parts , Print related option, Watermark , Page color and page border, Table of Content, Biblography and Citation, Caption , Footnate and Endnote, Mark Entry , Mail merge,language and proof, Track Changes Powerpoint Content: Powerpoint Presentation Intro – Layout and section, Formatting and manage Video, Text box, Header and Footer, Slide show options, Design in Powerpoint, Transition effect in Powerpoint, Animation in Powerpoint