February 2014 archive

Feb 26

#2:Compare two lists instantly

Excel Intermediate:  #2:Compare two lists instantly Solution:  1. Select  range in both lists  2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK  Play this trick immediately to do your quick comparison instantly  Benefits: No need to spend time in writing formulas /code Instant way Alternatively you can watch my below video …

Continue reading »

Feb 20

#1:Connect to Internet Explorer(IE) via VBA

VBA Intermediate:  #1:Connect to Internet Explorer(IE) via VBA Solution:  1. Using Late binding methodology create object of IE and make the visible property as true.  2. Then Navigate to your URL  Benefits:  Automate your day to day work Save your time Increase your productivity Alternatively you can watch my below video for better clarity  If …

Continue reading »

Feb 19

#1:Creating Excel menus using your Sub Routine

#1:Creating Excel menus using your Sub Routine- Excel Intermediate Level Solution:  1. First make sure which Sub Routine you want to add it in a menu  2. Click > File > Options> Customize Ribbon 3. Now from the Right side Panel > Click New Tab and Name it Properly  4. From Choose Commands from drop down …

Continue reading »

Feb 18

OneNote Tips and Tricks#8

OneNote Tips and Tricks#8:  Have your Favorite contents on the Go: Solution: Open IE > Choose any of your article > under Command bar > Press the double Shift Icon  Select “Send to OneNote”and choose your notebook  You can find the same functionality in your outlook as well.  Benefits:  Easy to search  Backup your files in OneNote  …

Continue reading »

Feb 14

OneNote Tips and Tricks#7

OneNote Tips and Tricks#7:  Attaching a File with Preview: Solution: Click insert > SpreadSheet > Existing Excel spread Sheet  Select your File > then > Select Table or Chart  Live preview will be displayed on the OneNote  Benefits:  You can have the update of the file any time in OneNote  Easy to edit  Save your …

Continue reading »

Feb 10

OneNote Tips and Tricks#6

OneNote Tips and Tricks#6:  Convert Images into Text: Solution:  Open Internet Explorer and open any of the page  Press Windows + S together for screen clipping  Drag any of the part and paste in to OneNote  Right Click the image any select “Copy Text from Picture”  Paste it as Text somewhere in your OneNote.  Benefits:  …

Continue reading »

Feb 09

OneNote Tips and Tricks#5

OneNote Tips and Tricks#5:  Using Page Template Features: Solution:  To make use of page templates in OneNote Click Insert > Page Templates > And choose your desirable template  Benefits:  Useful for the professionals Time Savings Take better notes Really neat  Alternatively you can watch the below video for better understanding  Please leave your comments below …

Continue reading »

Feb 07

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 »

Feb 07

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 »