Home > Computers & Technology > Databases & Big Data > Data Processing

MS Excel Analytics And Management Reporting: Step by Step Guide to Learn Excel by

Author: , Date: March 1, 2020 ,Views: 148

MS Excel Analytics And Management Reporting: Step by Step Guide to Learn Excel by

Language: eng
Format: azw3
Publisher: SUMIT SAXENA
Published: 2015-12-10T16:00:00+00:00


Using HOT keys in combination with ALT key for Text Alignment

ALT + H + ….

AL - Align Left

AC - Align Centre

AR - Align Right

AT - Align Top

AM - Align Middle

AB - Align Bottom

5 EXCEL KEYBOARD SHORTCUT COMBOS

1. Apply autofilters and freeze panes on top row – CTRL+Shift+L, Alt+WFF

2. Unmerge all cells in workbook – CTRL+A then Alt+HMC

3. Add a new worksheet and name it – Shift+F11, Alt+HOR

4. Close the current workbook and re-open it – Alt+FC, Alt+F,1 (or in 2010 its Alt+FR1)

5. Select column and remove/highlight duplicates – CTRL+Space,Remove:Alt+AM or Highlight: Alt+HLHD



Download

MS Excel Analytics And Management Reporting: Step by Step Guide to Learn Excel by.azw3


Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.