Kumar Ajit

http://wp.me/p7SqRn-84

http://99excel.com/books/ Buy Excel Books Online     Buy Now 495   Basic Excel Introduction Basic Excel – Learn the Excel Basics – Excel Functions and Formulas, An Overview of the Excel Basics that will assist you when using excel. Brief Introduction to Excel. Excel is the spreadsheet program created by Microsoft. Buy Now 512   … Read more

Sub Auto_Open() Msgbox “Welcome to My Excel Sheet” End Sub Instructions: Open an excel workbook Press Alt+F11 to open VBA Editor Double click on ThisWorkbook from Project Explorer Copy the above code and Paste in the code window Save the file as macro enabled workbook Open the workbook to test it, it will Run a … Read more

Anyone who is really good at MS Excel and VBA macros is blessed with a booster attached to his/her career. Excel is used extensively in all organizations for basic analysis, reporting, scenario building as well as conduct statistical analysis.   Join Advanced Excel Training program – Know more

http://99excel.com/      

Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. Excel Formulas You Should Definitely Know: 1. SUM Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) … Read more

F4 Key: “F4” key provides you two different outputs depending on what you are doing currently in your excel. If you are editing, then it will cycle you through the all three types of references, like – absolute reference, relative reference and mixed reference. Refer below example for detail.   As displayed in below image … Read more

Following Excel Vba Code to create the folder in a directory if path is not exists.     Sub Create_Local_folder() Set fs = CreateObject(“Scripting.FileSystemObject”) AttendanceLocalFolder = “C:” & “” & “MYNEWFOLDER” If fs.FolderExists(AttendanceLocalFolder) = False Then fs.CreateFolder AttendanceLocalFolder   End Sub

99Excel training academy is committed to provide high quality, value-based, career oriented training of Microsoft Excel and Vba – visual basic application to their students. We customized a unique excel training module at various levels to fulfill your essentials professional skill, most useful formulas, function and dashboards and applied in Institute training program. 99Excel training … Read more