Mar 05

OneNote Tips and Tricks#9:

OneNote Tips and Tricks#9:  Take notes easily- using linked notes: OneNote allows you to take notes instantly while you are in live meeting or reading specific contents in the internet or using any of your office products. Solution:  1. Open OneNote > Review > Linked notes  > Start taking notes 2. The software icon will …

Continue reading

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