All language subtitles for 2. Excel 2016 user Interface

In this video you will learn about the book and will cheat and the user interface of Microsoft Excel

Excel files are also called workbooks each file on log workbook contains one or more worksheets the

word cheap tab shows all worksheets contained in the current log book and the little cheat names notice

that a new Excel workbook contains one log sheet by default.

You can add more cheats or delete the ones you do not want.

Each worksheet has a name as you can see the default worksheet is named Sheet 1.

You can rename the vault sheet to give a meaningful name to rename of our sheet.

Right click on the name of the vault sheet and enter the new name let us rename the sheet to my sheet

and then press enter in the worksheet the data is organized in cells a cell is the intersection of a

row and up column Excel uses alphabets as column labels and the numbers as Row Labels.

So the first column is labeled a and the first row is labeled one the first cell is labeled a one that

is labeled of the column followed by the label of the row.

You can use both the mouse and the arrow keys on the keyboard to navigate or move around the world sheet

Microsoft Excel has an easy to use user interface.

Let me now show you the six major elements of the user interface the top rule in the interface is the

quick access toolbar you use this to quickly access commonly used functions like undo redo save new

file patch or most mode etc..

You can customize it to show functions you use most to customize it click on the arrow next to the toolbar

you will see a list of commands in the window click on the come on you wish to include in the toolbar

let us click open to remove an item from the toolbar click on the checkmark next to the common to add

commands not shown in the list click the More commands.

Option notice that file open option is now available in the quick access tool but the rabbit interface

was introduced in Excel 2007.

All office programs organize commands on the horizontal bar called Philippine it appears across the

top of each program window commands are organized on task specific tabs of the ribbon and in the feature

specific groups of each step each step in the ribbon contains dos and commands for walking with your

voce let us click on each tab to see what we can do with it home tab contains commonly used commands

for formatting and inserting rows and columns.

Insert Tab has options to insert various objects like tables illustrations advanced charts tools spotlights

lines filters links text and symbols into your cheat.

Basically all that is used to change page team's orientation size modules backgrounds separate areas

and move objects forward and backward formulas that are the most powerful feature of Excel use formula

tab to find and use and take various Excel formulas in Young will cheat Data tab has functions for importing

and organizing external data into worksheets option to connections sort and filtered options and sophisticated

data tools review tab has functions for reviewing and protecting global cheat like spellcheck language

comments and project view tab has commands to change how you see the world cheat create and use macros

we will discuss all these stats in detail as we go along this course tell me what you want to do tab

is a new tab introduced in Excel 2016 it is not available in Excel 2013 and previous versions you can

do things quickly with this option for example let us interface insert exit in short the options matching

phrase insert for example you can quickly insert a table in your load sheet in Excel 2016 for Windows

you can share of all books with others when you share your log book using one drive one drive for business

all SharePoint you can do all your sharing from right within Excel 2016 in the ribbon command generally

take the form of buttons and endless some appear in galleries some groups have related dialog boxes

or task bins that contain these still commands the ribbon is dynamic as the width of the ribbon changes

the appearance of the commands on the ribbon also changes as the weight of the ribbon decreases the

size shape and presence of buttons on the ribbon adapt to the available space.

For example if you decrease the width of the ribbon small button labels like wrap text disappear and

if we increase the width of the ribbon the label will appear again to gain back some screen space you

can collapse the ribbon by right clicking a tab and clicking collapse the ribbon too quickly go back

and forth between I'm collapsed and collapsed double click a tab on the ribbon you can move the quick

access toolbar below the ribbon right click the tab jus show quick access tool box below the ribbon

formula bar is where you enter or edit contents of a cell it is called formula bot but you can enter

anything here not just formulas for example let us type monthly in a cell you can see that it appears

in the formula but we can edit the cell content from formula but also

Walgett area is the area where you add that and store data below the will cheat that is the state spot

the state this bar displays information about your vote sheet based on the sales you select in the vote

sheet at the right of the state despite all commands for viewing the vote cheats in normal view basically

out view or page Blake view to the right of these commands is a zone level slider control and a zoom

button when you select a group of cells for example

the status bar displays the average count and the sum of the numbers in the selected sets.