Excel Tips and Trick 2020 - MS EXCEL - Tech Universe Official
Introduction
Excel is a
spreadsheet data analysis, calculation and processing software. Now a days,
this software is become the backbone of every business, shop, store, Mall for
data processing. Excel 2016-19 is new version Microsoft Excel many new feature
and updates are come and software more emphasize. Many feature and new user interface make
Excel 2016-19 Better to work much beautiful. These new versions are also
providing cloud base storage online trail and premium on Microsoft One Drive.
Now a days Excel use in every field of life. New Backstage view, new Tabs, sub
Tabs, Groups, new improved formula’s and function are available together here.
New setting and tool search bar also available in this slot. Download Working
File below in .xlsx format.
Excel 10 Tips and Trick
These tips
use to improve data entry and working in excel impress your boss. I recommend
you to do not use of mouse always use keyboard. Now follow the time saving tips
and trick.
1 1. Movement
2.
Selection
3.
All Border
4.
Auto Sum
5.
Formula Hide Unhide
6.
Insert Date
7.
Insert Time
8.
Pivot Table
9.
Filter
10.
Clear All
1. Movement
In this
topic you use Navigation keys (Arrow keys) on place of Mouse for movement. Ctrl + ↓→↑← use to move in a table, a data end of corners freely. For better
experience the pic below.
2. Selection
In this
topic you use Ctrl Shift Navigation keys (Arrow keys) on place of Mouse for
selection. Ctrl + Shift + ↓→↑← use to Select in a table, a data and a range that
u required for selection. For better experience the pic below.
3. All Border
In gridlines
shown only rows and columns division but not in print preview. So, you need
Select a range then give a border that you want by ALT + H, B, A. Now you can
take print easily with border. Example picture mention below:
1 4. Auto Sum
Excel have
had one formula that have a shortcut key is called Auto Sum. Auto Sum only for
Sum purpose also work with Sum, Average, Count, Max, Min and also many others
insert function option. You can select a range or end of column/row simply
Press ALT + =. Example picture mention below:
5. Formula Hide / Unhide
Excel have
many data analysis or verification tools in which that formula hides unhide or
common to audit our sheet by click all formulas shown their ranges at once. If
you want audit on urgent basis then just press Ctrl + ~. These Type of formulas
little bit hidden because people not use permanently. I recommend every check
our before you send to your Boss by this trick. Example picture mention below:
6. Insert Date
Insert
current Date in Excel is very Easy by Single shortcut key Ctrl +”;”. This
formula uses to quickly add date in your sheet where you want just select cell
and press this shortcut key. Example picture mention below:
7. Insert Time
Insert current Time in Excel is very Easy by
Single shortcut key Ctrl + Shift +”;”. This formula uses to quickly add Time in
your sheet where you want just select cell and press this shortcut key. Example
picture mention below:
8. Pivot Table
What is
pivot table? Pivot Table is a powerful tool Summarize any data. If you want to
insert pivot Table I recommended you to first of all insert simple Table Tool
by pressing Ctrl + T. then you can Insert Pivot Table by pressing Alt + N, V. This
tool helps you to calculate data by filter, column and rows. Example picture
mention below:
9. Filter
What is Filter
in Excel? Filter is also powerful and commonly used tool to Summarize or sort
any data. If you want to Sort or filter then you can use this tool by pressing Ctrl
+ Shift + L. This tool helps you to search and sort data by filter. Example
picture mention below:
10. Clear All
What is Clear
all options in Excel? Clear All command helps you to clear data or formatting by
user need in which options are Clear All, Clear Formats, Clear contents, Clear
comments, Clear Hyperlink. When u use this option chose shortcut key Alt + H, E,
A. Example picture mention below:
0 Comments