Go Back   Team-BHP > Around the Corner > Shifting gears


Reply
 
Thread Tools Search this Thread
Old 17th June 2010, 12:18   #1
BHPian
 
Join Date: May 2010
Location: Pune
Posts: 113
Thanked: 18 Times
Default Microsoft Office; Tips & Shortcuts

Learning and working on Microsoft Excel and PowerPoint has been one of the greatest things to happen to me, like most of us here.

I am not listing MS Word, as these days most of the reports are prepared in PPT format after the analysis in XLS. (In my two years of experience with a consultancy, only government organizations asked for reports in Word format along with a PPT).

Tips on MS Word are also welcome.

One of the main aspects is to increase the operational speed and reduce the output time, with sleek looking logically presented facts. With proper data analysis and logical presentations, rest assured to turn the tide in your direction.

I am sure there are several champs out here who would love to share their expertise with other members, objective being to share and to improve.
'Pyar aur Knowledge baatne se badhta hai'

No matter how simple the tip is, if someone gets to learn from it, nothing like it.

Like this;

XLSX (I use MS Office 2007);
ctrl+1 gives you pop-up box to format the cell
ctrl+shift+1 converts the number from 1000 to 1,000.00 (this is different from the comma style, it lets you align the content to left or middle)
ctrl+shift+5 converts the number to percentage format
I will share the commands I know as the thread progresses.

Mods; I was unable to find similar thread. Please close the thread if it exists.
prateek99 is offline   Reply With Quote
Old 17th June 2010, 14:48   #2
BHPian
 
Join Date: Jul 2007
Location: Bangalore
Posts: 448
Thanked: 33 Times
Default

If you want to insert a newline in the excel cell, press Alt+Enter. Just pressing enter takes you to the new cell.
amohit is offline   Reply With Quote
Old 17th June 2010, 20:04   #3
BHPian
 
Superleggera's Avatar
 
Join Date: Mar 2007
Location: Kannur/Boston
Posts: 293
Thanked: 74 Times
Default

Cntrl + ; Gives you the system date
Cntrl + 5 Scratch the contents of the cell
Superleggera is offline   Reply With Quote
Old 17th June 2010, 20:12   #4
BHPian
 
ElantraGT's Avatar
 
Join Date: Sep 2009
Location: Chennai
Posts: 442
Thanked: 6 Times
Default

Press F4 and it will redo the previious activity that you did. For example, if you had inserted a line, then pressing F4 will insert another line. You can click on another row altogether and continue to press F4 again for adding another line there.
ElantraGT is offline   Reply With Quote
Old 17th June 2010, 20:21   #5
BHPian
 
Join Date: May 2010
Location: Pune
Posts: 113
Thanked: 18 Times
Default

alt+; selects visible cells only. Lets say if you want to copy visible cells only or delete visible rows only, this is the command.

While deleting the rows make sure you sort the data to reduce the processing load on your processor.
prateek99 is offline   Reply With Quote
Old 25th July 2011, 13:05   #6
BANNED
 
Join Date: Jun 2009
Location: Swindon, UK
Posts: 696
Thanked: 84 Times
Default Re: Microsoft Office; Tips & Shortcuts

I want to upgrade to Office 2010. However I do not want to loose my e-mails, contacts and settings for e-mail. How do I go about doing it.
Live To Jive is offline   Reply With Quote
Old 25th July 2011, 13:38   #7
BHPian
 
jaguar.runs's Avatar
 
Join Date: Jan 2010
Location: Dubai
Posts: 265
Thanked: 80 Times
Default Re: Microsoft Office; Tips & Shortcuts

Great initiative Prateek! Would love to learn new ones and share the ones I know.

Most common ones I use in Excel:

Shift + Space to select a row, Ctrl + Space to select a column. You can add a row/column or insert a copied row/column with Ctrl + + and delete a row/column with Ctrl + -

Alt + = for sum, either for single row/column or multiple row/column. Just select the cells where you need the value before using the short cut.

Ctrl + P to change the font size, Ctrl + F to change the Font.

Last edited by jaguar.runs : 25th July 2011 at 13:51.
jaguar.runs is offline   Reply With Quote
Old 25th July 2011, 15:09   #8
BHPian
 
Guite's Avatar
 
Join Date: Jul 2008
Location: Noida, NCR
Posts: 463
Thanked: 171 Times
Default Re: Microsoft Office; Tips & Shortcuts

I am a bit confused here. Is Ctrl + P a three key operation? The reason I ask is because I thought Ctrl P (two key operation) is for Print in all MS Windows applications, just like Ctrl S is always Save.

Very useful hints here. I like the F4 shortcut.
Guite is offline   Reply With Quote
Old 25th July 2011, 16:14   #9
BHPian
 
jaguar.runs's Avatar
 
Join Date: Jan 2010
Location: Dubai
Posts: 265
Thanked: 80 Times
Default Re: Microsoft Office; Tips & Shortcuts

Quote:
Originally Posted by Guite View Post
I am a bit confused here. Is Ctrl + P a three key operation? The reason I ask is because I thought Ctrl P (two key operation) is for Print in all MS Windows applications, just like Ctrl S is always Save.

Very useful hints here. I like the F4 shortcut.
@Guite: My bad! I think I was too eager to post

Please read it as Ctrl+Shift+P to change the font size, Ctrl+Shift+F to change the Font.
jaguar.runs is offline   Reply With Quote
Old 7th August 2011, 16:16   #10
BANNED
 
sfilinto's Avatar
 
Join Date: May 2006
Location: mostlly bangalore
Posts: 102
Thanked: Once
Default Re: Microsoft Office; Tips & Shortcuts

This would help all the folks interested in shortcuts.

Keyboard shortcuts in Excel 2010 - Excel - Office.com

Excel Blog - Can
sfilinto is offline   Reply With Quote
Old 9th August 2011, 15:24   #11
BHPian
 
Raja's Avatar
 
Join Date: Apr 2007
Location: Pune
Posts: 414
Thanked: 61 Times
Default Re: Microsoft Office; Tips & Shortcuts

Here is a huge article done by PCMag (US):
100 Essential Tips for Microsoft Office 2010 | PCMag.com
Raja is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel : Tips, Issues, Etc. GTO Gadgets, Computers & Software 51 20th April 2016 00:08
Microsoft to acquire Nokia’s devices & services business, patents and maps myavu Shifting gears 92 22nd July 2015 13:37
Move over Microsoft & Google. Apple is now the most valuable tech company!! GTO Shifting gears 12 28th May 2010 11:05
Tips to drive better: But are the tips correct? Spinnerr Technical Stuff 11 22nd June 2009 13:00


All times are GMT +5.5. The time now is 20:54.

Copyright ©2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks