Skip to main content

Posts

Showing posts from November, 2018
DO you know how to make  Excel  Talk on behalf of you and work like a Real Assistant? CAN  Excel  Present Data and Charts to Audience Directly? Watch this Video, How  Excel  is presenting Data to the audience like Human! Click on the Image to Access Video CAN Excel talk to Audience Directly?
Do you want to Know Major Short Cuts in Excel and Wanted to Save Time? Please download PPT containing Short Cut Keys with Function Keys Do you know Do Get a Menu in Excel without using Mouse? Press Shift + F10, and see the Magic. Just look at the below Picture to understand what is above. To get many more Short Cuts Download the PowerPoint Slides All Shortcuts  Function Key Short Cuts ...
Do You Know you can Create your Own Function in Excel? Try this. Open VBE Editor (Alt+F11) Write this Code Function TOMORROW() TOMORROW = Format(Date+1,"mm/dd/yyyy") End Function   Try the Function in Excel in the same workbook HAPPY LEARNING
Do you know we can create a  User - Form  Without VBA?   Let Me Explain! First Goto Quick Acess Toolbar -> Use More Commands->select All commands as shown in the Picture below: Then Find  Form  Command by Scrolling down and Add to the Quick Access Toolbar Then Add the Column Headers and Row Headers as per below Picture and Press  Form  Button in Quick Access Toolbar and Then Add data within the  form  and Data Entry is Simple. Hope you enjoyed. Further questions, feel free to msg me @ 9611344773 or write an email to  vijay.perepa@ameetz.com Best Regards A meet Z Tech Team