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 …
Tag: Tips and Tricks
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 …
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 …
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 …
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 …
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 …
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 …
Feb 12
Windows 7 Tips and Tricks #3
Windows 7 Tips and Tricks #3: Reset your windows account password when you forgot it completely Scenario: Sometimes you may forget your account password without any hint. Using your bio metrics device login like Face Detection or Fingerprint scanner you can reset your password. Solution: Log in in to Command Prompt as administrator Type …
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: …
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 …
- 1
- 2