Microsoft Excel Tricks and Shortcuts for Data Analysis

Desklib provides solved assignments and past papers to help students learn.

DISCUSSION

Microsoft Excel is not just a part of Microsoft office but also of an organization. Microsoft
Excel helps an organization prepare reports, charts and statistics of data. Here are some of the
simple tricks in Microsoft Excel:-
1. Continuing a series down a column or across a row
This feature can be used if you want to enter same number or name multiple times.
Select the bar and drag from the black point downwards.
After the drag, the numbers will change.

2. Filtering Data
Filtering data means to specify the data. It helps in mentioning the data without actually
deleting it.
Choose Data. Under Data, choose Filters. Select the name which you want to replace
Select the entire row
After selecting, click on the downwards arrow and replace the name Krishna and Ajay. New
table will be edited.

3. Format Painter
Format painter is the key used to pain the entire cell. Select the entire cell and click on the
option Formal Painter. Choose a color and the entire cell will be painted.
Now let’s discuss some of the shortcut keys which make your work way easier. Following are
some of the shortcut keys:-
1. Ctrl+[
This shortcut key is used to select the cells which are referenced by formulas.
2. Ctrl+]
This key is used to highlight the formula in the active cell.
3. Ctrl+Shift+{
This key is used to select all the cells which are referenced by formulas in the
highlighted section.
Following are some tips that you should keep in mind while using MS-Excel.
1. Import Directly- accessing this option imports the data directly. This will reduce the
time to make the entire sheet again.
2. Freeze Excel Rows and Columns- Select View and choose Freeze panes. This options
freezes the rows and columns that you want to freeze.
3. Hide the sheet- this feature enables you to hide the sheet.