Understanding the Ribbon in
Microsoft Excel
learn-microsoft-excel.blogspot.com - The Ribbon in Microsoft Excel is a collection
of commands that consists of several menu tabs and each tab consists of command
buttons in a certain group. The Ribbon consists of menu tabs, command groups
and command buttons. Each menu consists of a command group where the command
buttons are grouped. Command buttons provide a variety of uses or functions in
Microsoft Excel.
Types of Microsoft Excel Ribbon and Their Functions
The Microsoft Excel Ribbon consists of menu tabs that are equipped with command groups.
The menu tab in Microsoft Excel 2016 consists of the File, Home, Page Layout, Formulas, Data, Review, View, Developer, Load Test, Power Pivot and Team menus.
Developer, Load Test, and Team features are hidden by default in Microsoft Excel.
File menu
The file menu is the main menu in Microsoft
Excel 2016. Since the release of Microsoft Excel 2010, the Office Button has
been replaced by the File Menu on the Microsoft Excel Ribbon. The File menu
serves to create, save, open and manage files and applications in Microsoft
Excel.
Home menu bandarq online
The Microsoft Excel home menu provides the most commonly used commands in Microsoft Excel.
As for the Command Group from the Home Menu,
Clipboard is a group of commands used to cut, copy, paste in Microsoft Excel.
Cut is an command to move data, copy the command to duplicate data and paste is an command to run the cut / paste command in cells, worksheets or workbooks that are different from the original data.
Fonts are a group of commands that are used for font management in Microsoft Excel.
You can open the font dialog by pressing CTRL + SHIFT + F. The following is the font dialog in Microsoft Excel.
Alignment is a group of commands in Microsoft Excel that functions to adjust the average display of data and merge Microsoft Excel cells.
Number is a group of commands that functions to change the display format of numbers in Microsoft Excel.
There are many number formats in Microsoft Excel such as general, accounting, percentage and others. The following displays the dialog number in Microsoft Excel.
Styles are a group of commands that provide customization for the appearance of cells in Microsoft Excel.
This feature makes the table to be printed more attractive.
Cells is a group of commands that functions to modify cells both width (width), height (height) and others.
Editing is a very useful group of commands for data management.
Editing provides command buttons that are often used to create Excel formulas such as SUM, MAX, MIN and others.
Insert Menu
The Insert menu serves to insert data on a Microsoft Excel worksheet.
As for the Command Group from the Insert menu,
Tables are a group of commands for creating tables and pivots.
Illustrations is a group of commands for adding images and shapes.
Add-Ins is a command group to add additional features from the microsoft store.
Charts is a command group that functions to create charts in Microsoft Excel.
Tours is a command group that can create geographic data in Microsoft Excel.
Sparklines are a command group for creating mini charts.
Filters are a group of commands used to filter data.
There are two types of filters, namely Slicer to filter data visually and Timeline to filter data based on time.
Links are a group of commands used to add Hyperlinks to cells.
Text is a group of commands for adding custom text.
Symbols are a group of commands for adding symbols and math formulas / equations.
Page Layout menu
The Page Layout menu is used to set the size of the worksheet in relation to the process of printing an Excel file.
Themes are groups of commands that can provide visual effects to Microsoft Excel worksheets.
Page Setup is a group of commands that are used to perform paper settings on Microsoft Excel worksheets.
Scale to fit is a group of commands to scale rows and columns to the paper size on a Microsoft Excel worksheet.
You can set the number of columns and rows to be displayed on the paper size in a Microsoft Excel worksheet. This dialog box is actually in the Page Setup dialog box but a special group is provided to make it easier for users.
Sheet Options are a group of commands for displaying Gridlines (cell borders) and Headings both when editing via Excel worksheets or printing.
Arrange is a group of commands that functions to arrange objects generally in the form of shapes on a Microsoft Excel worksheet.
There are options to Bring Forward, Send Backward, Selection Pane, Align, Group Objects and Rotate.
Menu Formulas
The Formulas menu contains a group of commands related to Excel formulas.
Function Library is a command group that displays all formulas that can be used in Microsoft Excel.
Defined Names is a group of commands that functions to provide cell names in Microsoft Excel.
Formula Auditing is a group of commands that contains management for a process performed by a formula on cells in Microsoft Excel.
Calculation by default this feature is enabled in Microsoft Excel to calculate a formula directly.
You can change it in this command group
Data Menu
The Data menu is related to the overall data management in Microsoft Excel.
Get External Data is a command that functions to import data outside the scope of Excel, such as Microsoft Access and SQL.
Get & Transform is a complex command group that can combine data from different sources and display it in a specific format.
Connections is a group of commands that functions to link tables in Microsoft Excel worksheets.
Sort & Filter, this command group is also found on the Microsoft Excel Home Menu.
Data Tools are a group of these commands used in advanced use for data analysis, usually used in research.
Forecast is a group of commands that functions to predict or opportunities using Microsoft Excel.
Outline is a group of commands used to group data so that it is easier to see.
Komentar
Posting Komentar