Tag: Tips and Tricks

Mar 11

Formulas Not working when dragging down

Excel Issues/ Problem #1: Issue: Formulas Not working when I drag it down: when I drag a formula from the cell on downwards, the numbers remain the same in all the pasted cells. When I double click on the individual formulas, it updates. Solution: Go to Formulas Menu -> calculation- change it to Automatic   …

Continue reading

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