If with Other formulas, Complex formulas writing in If. If with Trim, If with Concatenation, If with Left, Mid, Right. If, If with OR, If with AND, If with AND &OR, If with OR&AND. Date and Time Functions: Date, Datevalue, Day, Da圓60, Minutes, Hours, Now, Today, Month, Year, Yearfrac, Time, Weekday, Workday, Networkdays. Writing of the Complex formulas for improvement in formulas writing skills. Text Functions: Concatenate, Dollar, Left, Mid, Right, Lower, Upper, Proper, Replace, Rept, Find, Search, Substitute, Trim, Trunc, Convert. Start-up With Formulas: Part-I AND Working With Name Ranges: Insert Logo to your worksheet while printing. 
Printer Properties and Page Setup (Page, Margin, Header/Footer and Sheet) for Printing.
VISUAL BASIC FOR EXCEL LEARN PASSWORD
Password protection to the Worksheet, Sheets, Rows, Columns, and Cells. Protection of Cells, Rows, Columns and Sheets. Format Cells, Rows, Columns and Sheets. (Formulas, Values, Formats, Comments, Validation, All using source themes, All except Borders, Column Widths, Formula and Number formats, Values and Number Formats, None, Add, Subtract, Multiply, Divide, Skip Blanks and Transpose) Introduction to the Paste Special all Option. Inserting, Deleting, Moving, and linking the data in between the multiple sheets. Copy, Cut, Paste, Hide, Unhide, Link the Data in Rows, Columns and Sheet. Introduction to the Data and Data Formats. Use of Basic Operators Like: + – / * ^ %. Detailed discussion on Excel design, Back-End working structure and Excel Options. Introduction to Excel Worksheet, Row, Column, Cells etc. Introduction of Excel shortcut keys: Chart will be provided by Advanced Excel. Saving of Old version MS Excel 19 files to new excel version MS excel 20. Difference between Excel 2003and 2007and 2010. Start-up with MS Excel, Quick review on MS Excel Customize Ribbon, Quick Access Toolbar, Mini Toolbar. 
Introduction and Basic Brush-up of MS Excel and Excel Back-End Opetions:
0 kommentar(er)
