ADVANCE EXCEL FOR MIS EXECUTIVE

Excel Functions for Finding and Replacing Text, with Examples: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE https://drive.google.com/open?id=1-wsDpon8KRjDnZtLoiX34BrA04CTK3-M

Create Excel Spreed Sheet file which no need press Ctrl+S or F12 for Save after edit . follow the Step  1. Creating Your First Spreadsheet 2. Save your file with macro-enabled .XLSM extension. 3. Press Alt+F11 4. Then Right click on ThisWorkbook and open view code  5.Then copy the code and paste or type same code on white Screen then save and exit  Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub 6.Now you can use your  favorite Excel file which auto Save withour Ctrl+S.  

                                              AND_OR_NOT_%_IF https://drive.google.com/open?id=1b49wt9L1wwfXgcTlF776i3JEMdyDk2EA

AVERAGE_PRODUCT_COUNT_COUNTA https://drive.google.com/open?id=14Uu0WGYfRUjQ9K7lGhEWN3LolhDFYKnK

FORMULA OF SUM MIN MAX https://drive.google.com/open?id=11ZUSqVyJtO79YzDMeuQxfgOmwZxQ8G9d

Microsoft Excel  is a spreadsheet and analysis program developed by Microsoft. Excel can be run on both Windows and Mac platforms.