How to calculate monthly percentage in Excel
• Calculate the all daily production using Autosum option • We may get a huge value in overall percentage • Divide that overall percentage b...Read More
What is Excel Macro
What is Excel Macro? A macro is like an algorithm or a set of actions that we can use or run multiple times. A macro helps in automating or ...Read More
Realme usb tethering not working
• If the REALME Android device is updated or got reset, few of the functions may disabled • In that case USB tethering also will not work du...Read More
How to add Signature line in word
• Open MS word • Go to Insert tab==> Signature line • Enter the name for suggested signer and enter the designation • We can add email ad...Read More
How to translate word document
• Open MS word • Select the word or paragraph which need to translate • Go to Review tab==> Translate • We can translate entire document ...Read More
View types in Word
• Open MS word • Go to View tab==> Views • We can see three different types of views • Apply the view type which suits in your documen...Read More
How to add page number
• Open MS word • Go to Insert tab==> Header and footer==>page number • Select the page number and select the position where need to ad...Read More
How to add header and footer
• Open MS word • Go to Insert tab==> Header and footer • We can add the name in different positions • Now the header and footer tab will ...Read More
How to count words in word
• Open MS word • Select the paragraph which need to count the words • Go to Review tab==> ABC Spelling & Grammar==>word count • No...Read More
How to Spell check in MS word
• Open MS word • Select the paragraph which need to spell check • Go to Review tab==> ABC Spelling & Grammar • Now the spell check st...Read More
Wordart in MS Word
• Open MS word • Go to Insert tab==> Word art • Select the heading or text where need to add effect • We can see lots of effects availabl...Read More
How to use Wikipedia in word
• Open MS word • Go to Insert tab==> Wikipedia • Now wiki screen will appear in right corner tab • Search and enjoy the Wikipedia reading...Read More
How to Change theme in MS Word
• Open MS word • Select the paragraph where need to apply theme • Go to Design tab==> Themes • Now selected theme has been applied for se...Read More
How to add watermark in MS word
• Open MS word • Go to Design tab==> Select watermark option • Click the custom watermark. We can create watermark in text or image • We ...Read More
Top 10 interesting facts about Microsoft word
• We can add bullet point quickly by adding *with space • Translate option will helps to convert the paragraph/sentence to different languag...Read More
Top 10 interesting facts about Microsoft
• Bill gates had a boring name for windows • Windows xp is installed on more than 40% percent on desktop pc in Armenia • Windows 1.0 is the...Read More
Top 10 interesting facts about Microsoft Excel
1. Every Excel sheet has 17,179,869,184 cells. If we spend 1 second to fill out 1 cell in manual it take us 545 years to complete whole sh...Read More
How to create a QR code a web page
How to prepare QR code: • Open a web page where you need to create a QR code • Right click on the web page • Click the "create a QR cod...Read More
How to change google meet background in mobile
In computer: • Open Google meet. join/start a meeting https://meet.google.com/ • Click the three dot in bottom bar • Select the change...Read More
How to customize the Google meet link
• Open Google meet https://meet.google.com/ • Click new meeting • Select the meeting type. Here I am choosing "start an instant meet...Read More
How to open browsers using batch files
• Open a notepad file. Paste the below mentioned code @echo off %SystemRoot%\explorer.exe "" • Open browser in search bar. Open fi...Read More
How to open Outlook using Batch file
• Open a notepad file. Paste the below mentioned code @echo off %SystemRoot%\explorer.exe "" • Open outlook in search bar ==> O...Read More
How to copy words from image file
• Open one note • Copy the image file and paste it in One note • Right click on the image • Select copy text from image • Now text paste the...Read More
How to convert italic fonts images to text
• Open online converter I2OCR https://www.i2ocr.com/ • STEP 01: Choose the language • STEP 02: Upload the image file or url which co...Read More
How to count days in MS Excel
• To check the number of days between two date period, use the below given formula • (=DAYS) Select the date • Now the number of dates has b...Read More
How to set password for Excel file
• Go to file==>info ==>Protect workbook • Click with protect workbook==> Encrypt with password • Now enter password and confirm it ...Read More
How to change all currency symbol
• Select the numerical which need to add currency symbol • Go to file==>HOME ==>NUMBER tab • Select the dollar sym...Read More
How to change Grind line color
• This will add more visual effect for MS Excel • To change the Grid line color follow the below mentioned steps • Go to file==>options =...Read More
How to remove the page breaks
• The page break may affect the Visual for MS Excel while using • To remove that page breaks follow the steps mentioned below • Go to file==...Read More
How to filter EVEN number separately
• For filtering EVEN number from a list use the below mentioned Formula • (=EVEN) • Select the number list • Now the EVEN numbers has been f...Read More
How to filter ODD number separately
• For filtering ODD number from a list use the below mentioned Formula • (=ODD) • Select the number list (Column) • Now the ODD numbers has ...Read More
How to add and remove hyperlink in Excel
ADDING HYPERLINK • Right click on the cell which need to add hyperlink • Click for hyperlink • ADD your required the URL link in address bar...Read More
How to spell check in Excel
• Select the words which need to spell check • Go to ==>review tab • We can see ABC Spelling • Once we clicked the ABC Spelling our spel...Read More
How to use color scale in Excel
• Prepare the data which need to project under color scale • Select the data's • Go to conditional formatting==> Color scales • Now w...Read More
How to add Welcome message in Excel VBA
• Go to developer tab • Click with visual Basic ==> insert and click with module • Paste the below given code in THIS WORKBOOK and modi...Read More
How to create excel macro
What is Macro? Excel Macro is a record and playback tool that simply records your Excel steps and the macro will play it back as many times ...Read More
How to Convert the numbers in millions in Excel
• Open MS Excel • Select the numbers • Give right click, go with Format cells • Enter the below given code and click OK. ...Read More
How to add bullet points in Excel
• Open MS word. Enter a bullet and add @ and copy it • Now Open MS Excel • Select the Column which need to add bullets • Go to format c...Read More
Subscribe to:
Posts
(
Atom
)
