OneNote Tips and Tricks#4

OneNote Tips and Tricks#4:  Adding special commands in the quick launch bar: Solution:  Click File > options > Quick Access Toolbar  Select commands not in the ribbon from the drop down Choose your favorite function and add it in to the quick launch bar  Press OK  Benefits: Quickly access the functionality Save your time Alternatively …

Continue reading

Windows 7 Tips and Tricks #2

Windows 7 Tips and Tricks #2 Multiple selection using check boxes Benefits: To delete or copy more files using check boxes: Very easy to select multiple files No need to hold Ctrl or Shift for your selection  Instructions: Open any folders Click organize> Folder and search options Go to view tab> scroll down to the …

Continue reading

OneNote Tips and Tricks#3

OneNote Essential Tip#3:  Create your own custom Tags: OneNote allows you to create your own custom tags to make your life easier and stress free environment. One of the best ways to manage your workload Benefits: Easy to search Make your life easier To get better understanding click the below link to watch the video …

Continue reading

OneNote Tips and Tricks#2

OneNote Essential Tip#2:  Search Text within picture: OneNote allows you to search the text within picture. This is one of the cool way to reduce your day to day workload.  Some times you may want screen shot for your reference but how do I search a specific text from this ? OneNote has provided the …

Continue reading

Finding Upper Bound and Lower Bound Range from DataSet

Excel Advanced Formula Tricks #2:  How to find the Upper Bound Range and Lower Bound Range from the given data set? Solution:            We can achieve this by using Match Function in Excel. There is no direct way to do this in Excel.  Please watch the video below to achieve this …

Continue reading

Benefits of OneNote for Beginners

OneNote for beginners

OneNote Beginner Tips #1: How to use OneNote for very first time and the essential benefits:  One place to save all your works There is no need of notepad / large files Auto save option Easy to search  & Manage Easy to sync with Cloud / SkyDrive Alternatively you can watch the below video to …

Continue reading

Restrict the work area few columns and rows

Excel productivity Tweaks #2:   Restrict the work area few columns and rows: Select the first column you don’t want to see  ( Ex :L Column) Now  press ctrl+shift+right arrow , now right click on the header and then press hide option. Now select the first row you don’t want to see (Ex:18 th row) …

Continue reading

Hide Send to option / Download a copy option for Visitor Groups:

Hide Send to option / Download a copy for Visitor Groups:   Issue: How do I prevent users from accessing SharePoint file.?  How can I disable or hide Send To Download a copy Or How can I keep my file secret in SharePoint ? Or How do I make the file visible only to owners …

Continue reading

Windows 7_ Secret Screen Recorder

Windows 7 Tips and Tricks #1:  Windows 7- Secret Screen Recorder One of the most useful utility by windows 7. It’s a pre-build utility definitely useful for people in software field.  PSR.exe ( Problem Steps Recorder) : To get PSR  1) Start > Search > Type  > PSR.exe  Watch the following video for the detailed …

Continue reading

Excel-Change the order in which you edit cells

Excel productivity Tweaks #1: Change the order in which you edit cells:   We all know that when you hit ENTER on a cell excel usually takes you to the next cell in that column for editing.  If you want to move to next cell while pressing enter.  Go to Tool-> Options->Advanced- > Editing Option..> …

Continue reading