Very useful for starters in Excel. This updated document lists down important shortcuts in Excel in one page. You can also take a print of this and paste on your desk for ready reference. This is a copyright free document, hence you can use it the way you want – both personally as well as…
Category: Downloads
DOWNLOADS 27 – CTRL+SHIFT – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ SHIFT shortcut keys listed to keep you ahead of the competition. DOWNLOAD for printing – Excel – CTRL_SHIFT_Shortcuts Pinup Reference Shortcut Action Ctrl+Shift Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right Ctrl+Shift+A Insert argument…
Downloads 26 – Excel Formulas Bible V2
In 2017, I posted Excel Formulas Bible which was very much appreciated. Since then much water has flowed down the Excel river. Dynamic Array functions, XLOOKUP/XMATCH had been introduced. They have made life much simpler. Now, all formulas are treated as Array formulas, you need not enter them as Array formulas. So, 5 years down…
Important – Content of this Website is 100% Copyright Free
I just want to convey that the content of this site is completely copyright free. You can use the content the way you want without seeking any permission. Whether you are using it commercially or non-commercially, personally or within your organization, it doesn't matter. There is no need to give any acknowledgement either that you…
DOWNLOADS 25 – CTRL+0 to 9 – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ 0 to 9 shortcut keys listed to keep you ahead of the competitions. DOWNLOAD for printing – Excel – CTRL_0_9_Shortcuts Pinup Reference CTRL Shortcut Action CTRL+0 Hide the selected columns CTRL+1 Open the Format Cells dialog CTRL+2 Apply or remove…
DOWNLOADS 24 – CTRL+F1 to F12 – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ F1 to F12 shortcut keys listed to keep you ahead of the competitions. DOWNLOAD for printing – Excel – CTRL_F1_F12_Shortcuts Pinup Reference CTRL Shortcut Action CTRL+F1 Displays or hides the ribbon CTRL+F2 Displays the print preview area on the Print…
DOWNLOADS 23 – CTRL+A to Z – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ A to Z shortcut keys listed to keep you ahead of the competitions. DOWNLOAD for printing – Excel – CTRL_A_Z_Shortcuts Pinup Reference CTRL Shortcut Action CTRL+A Select the entire worksheet CTRL+B Apply or remove Bold formatting to font CTRL+C Copy…
Downloads 22 – Sample CSV Files / Data Sets for Testing (till 5 Million Records) – IBM HR Analytics for Attrition
On Kaggle there is a data set published named "IBM HR Analytics Employee Attrition & Performance" to predict attrition of your valuable employees. This is a very popular dataset and has usability index of 8.8. https://www.kaggle.com/pavansubhasht/ibm-hr-analytics-attrition-dataset But this data set has only 1470 rows whereas we need, sometimes, a large data set for testing. So,…
Downloads 21 – Sample CSV Files / Data Sets for Testing (till 5 Million Records) – Bank Transactions
Disclaimer – The datasets are generated through random logic in VBA. These are not real banking transaction data and should not be used for any other purpose other than testing. Other data sets – Human Resources Credit Card Sales HR Analytics Note – I have been approached for the permission to…
Downloads 20 – Excel based Consolidated Minutes of Meeting (MOM) Template
Download Link – MOM_Cumulative While earlier MOM template was or individual meetings, this MOM template can be used for all meetings held. Advantage is that you have running records of attendance, discussion and action items.