Tired of Excel files running slow or getting stuck, or need better analytics on your data!!
June 17, 2019
Magic of Flash Fill
October 4, 2019
You think you know MS Word? Annoyed with formatting issues? MS Word can be an annoyance but a lot can be accomplished when used to its maximum potential. Learn once and save time for the rest of your life!
1. VIEW AND COMPARE DOCUMENTS SIDE BY SIDE
Open both the files you want to compare. Go to View tab > in the Window group click View Side by Side.
To scroll the two documents simultaneously select Synchronous Scrolling.
2. REMOVE EXTRA SPACES AND PARAGRAPHS
Use the Find / Replace tool to find ^p^p, which are symbols for a
double paragraph break to eliminate double paragraphs and
replace it with ^p, symbol for single paragraph.
Before
After
3. CHANGE TO LOWERCASE OR UPPERCASE
Select the text whose case you want to change and then press
Shift+F3 to toggle between uppercase, lowercase and proper
case.
Before
After
4. FORMATTING
To restore the format of the various things copied from an
external source in your documents, highlight the text that you
want to change and press Ctrl + Space Bar.
Before
After
5. LEGAL BACKLINE
The legal blackline feature compares two documents and shows
only what has changed between them and the comparison is
displayed by default in a new third document.
Step I: Go to Review > Compare Group > Click on Compare
Step II: Click Compare two versions of a document. Under Original document option, browse and select the original document and under Revised document, browse and select the other document that you want to compare
Step III: Click OK
Contributor: Arghya Moulick
I am a third year B.Com (Hons.) student from City College of Commerce and Business Administration. I have been working at Leverage Growth as a Junior Associate, planning to pursue CFA in the future.
