exceltoxl.com

Hi there,

 Share on Facebook

There was a time where I used to work for night shifts, which starts @ 9 PM and ends @ 6 AM and that was the time I just started my hard core reporting career. Every day, I was coming to office @ 9 PM and used to work complete night and going back home @ 6AM. I was really finding very difficult doing my reporting work for the whole night by searching the required Excel features (I was not knowing much shortcut keys) to complete the assigned tasks. That was a tough time for me and I believe for anyone who starts reporting or Excel application for the first time that to not knowing shortcut keys. :| 

After completing my shift, on the way home, I was sleeping the whole journey.

The cab driver used to wake me up every day saying "Sir, your house has come".

...

Then, I started waking up from the cab as if I am sleeping in the 7 star hotel (eg: LEELA PALACE in Bangalore in INDIA) by rubbing my blurred eyes. And then, I was recognizing Oh! this is not LEELA PALACE - this is LOO LOO PALACE, which is near to my house. ;) Cab drivers will ask me to sign their route sheet copy because they will get paid only on those route sheet copies by the transport admin's. And, I get down my cab and slowly walking towards my home. I think most of the corporate employees will follow the same, I believe.

Anyhow, the reason why I am telling this bright sleepy story ;) because when we work smart we don't get stressed but if we work hard we will definitely get stressed and even overloaded. 

From now-onwards, the stressed employees can consult me for pills to get proper sleep full nights and I bet you will have complete sleep. "Cost Less - Sleep Full". Use it on daily basis after food but without water. :) OK

Pill Brand Name:

HIDDEN KEYBOARD SHORTCUT

To take camera tool image use ALT + 5 (KEY above the alphabets). and drag rectangle shape any where on the sheet to find the image of the camera tool. Check to know more about Camera Tool (flavor 4). This tip is more usefull while working on charts.

BONUS:

Pill Names and its Usages are as follows:

• To FILTER the data  ----------> CTRL + SHIFT+ L 
   
• To CLEAR FILTER -------------> CTRL + SHIFT + L
   
• To SHOW ALL filtered data ----> ALT + DOWN ARROW (apply this on filtered cell)
   
• To GROUP the data -----------> ALT + SHIFT + RIGHT ARROW
   
• To UNGROUP the data --------> ALT + SHIFT + LEFT ARROW
  
  

DO YOU USE SHORTCUT KEYS?

Please do share with us about your favorite shortcut keys or which shortcut key reduced more time than actual and reason using this space in the comment section below. 

If you like this post, then share or like this post on your social networking sites available in the corners of the blog.

SOME IMPORTANT LINKS:

BEST DOUBLE CLICK TRICKS using MOUSE

TOP 10 ⁺² SHORTCUT KEYS

CREATE SYMBOLS USING SHORTCUT KEYS

FORMULAS CHEAT SHEET

Thank You.