Microsoft Office Excel
Tccicomputercoaching.com
Microsoft
Excel is a spreadsheet developed
by Microsoft for Windows, Mac OS
X, Android and iOS. It structures calculation, graphing
tools, pivot tables, and a macro programming language called Visual
Basic for Applications, which makes work easy for employees in companies.
Microsoft Excel
is in form of grid, using a grid of cells arranged in
numbered rows and letter-named columns to organize data
manipulations like arithmetic operations.
In
addition, it can display data as line graphs, histograms and charts, and with a
very limited three-dimensional graphical display. It also contains different
formula function like maths, logical, text, date-Time, Financial etc…….
Short
cut keys for Excel:
Ribbon:
Alt key
press:
To
display a tab on the Ribbon, press the key for the tab—for example, press the
letter N for the Insert tab or M for the Formulas tab. This
makes all the Key Tip badges for that tab's buttons appear. Then, press the key
for the button you want.
To get
to the Ribbon, press Alt, and then, to move between tabs, use the Right Arrow
and Left Arrow keys.
To hide
the Ribbon so you have more room to work, press Ctrl+F1. Repeat to display the
Ribbon again.
Go to
the access keys for the Ribbon
To go
directly to a tab on the Ribbon, press one of the following access keys:
To
do this
|
Press
|
Open
the Tell me box on the Ribbon and type a search term for assistance or Help
content.
|
Alt+Q,
and then enter the search term.
|
Open
the File page and use Backstage view.
|
Alt+F
|
Open
the Home tab and format text and numbers and use the Find tool.
|
Alt+H
|
Open
the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures,
shapes, headers, or text boxes.
|
Alt+N
|
Open
the Page Layout tab and work with themes, page setup, scale, and alignment.
|
Alt+P
|
Open
the Formulas tab and insert, trace, and customize functions and calculations.
|
Alt+M
|
Open
the Data tab and connect to, sort, filter, analyze, and work with data.
|
Alt+A
|
Open
the Review tab and check spelling, add comments, and protect sheets and
workbooks.
|
Alt+R
|
Open
the View tab and preview page breaks and layouts, show and hide gridlines and
headings, set zoom magnification, manage windows and panes, and view macros.
|
Alt+W
|
If you
like this post then please share and like this post.
Visit
us @ tccicomputercoaching.com
Call us
@ 98256 18292.
To
Learn More About Computer Course, Computer
Course In Ahmedabad, Computer
Class
No comments:
Post a Comment