The MS Excel tutorial provides basic and advanced concepts of Excel. Our Excel tutorial is designed for beginners and professionals.
Microsoft Excel is a computer application program written by Microsoft. It mainly consists of tabs, groups of commands, and worksheets. It is mainly used to store tabular data.
Our MS Excel tutorials cover all topics of MS Excel such as ribbon and tabs, quick access toolbar, mini toolbar, buttons, worksheet, data manipulation, formatting, function, formula, vlookup, isna and more.
What is Microsoft Excel?
Microsoft Excel is one of the most appropriate spreadsheet functions to help us manage data, optionally creating logical charts and thoughtful graphs. Microsoft Excel is supported by both Mac and PC platforms. Microsoft Excel can also be used to balance checkbooks, create expense documents, create formulas, and edit them.
It mainly consists of tabs, groups of commands, and worksheets. The worksheet is made up of the rows and columns that make up each other the cells where the data is entered. It is capable of integrating many functions such as computation, data analysis and data.
Microsoft Office Button, Ribbon and Quick Access Toolbar are the three main features of Excel that you need to focus on while learning Excel.
Microsoft Excel Features
AutoFormat – allows us to choose several predetermined table formatting options.
- AutoSum: It helps us to add the contents of a group of adjacent cells.
- List autofill: It automatically develops cell formatting when a new component is added to the end of a list.
- Autofill: This feature allows us to quickly fill cells with chronological dates or numbers such as repetition or sequential records and repeated documents. Autofill can also be used to copy functions. We can replace text and numbers with this feature.
- AutoShapes: The AutoShapes toolbar will allow us to draw some geometric shapes, arrows, flowchart items, stars, and more. With these shapes, we can draw our graphs.
- Wizard: It guides us to work effectively while showcasing many useful tips and techniques based on the work we are doing. The drag and drop feature will help us to repeat the record and text by simply dragging the data with the help of a mouse.
- Charts: These features will help us present a graphical representation of our data in the form of pies, bars, line charts and more.
PivotTable: It flips and joins data in seconds and allows us to prepare documents such as data analysis and periodic financial statements, statistical documents, etc. We can also graph complex data relationships.
- Shortcut menus: These commands are suitable for the function we are performing by clicking the right mouse button.
After starting Excel, we will see two windows – within each other. The outer window is the application window, and the inner window is a workbook window. When maximized, the Excel workbook window is combined with the application window.
After completing this module, we should be able to:
- Identify the components of the application window.
- Identify the components of the workbook window.
The application window provides space for our worksheets and workbook items, such as charts. The components of the application window are defined below.
Quick access Toolbar
From the Quick Access toolbar, we can access common commands no matter which tab is selected.
By default, this includes the save, undo, and repeat commands. We can add other commands based on our choice.
To add a command to the Quick Access Toolbar
- To click the drop-down arrow on the right side of the Quick Access toolbar.
- Select the command we want to add from the drop-down menu. To choose from more commands, select More commands.
- The command will be included in the Quick Access Toolbar.
Excel 2016 uses a tabbed ribbon system instead of traditional menus. The ribbon includes several tabs, each of which has multiple groups of commands. We will use these tabs to do the most common tasks in Excel.
To minimize and maximize the ribbon
The ribbon is designed to respond to our current function, but we can choose to minimize it if we find that it takes up a lot of screen space.
- To click the ribbon display option arrow in the upper-right corner of the ribbon.
- Select the desired minimum option from the drop-down menu:
- Auto-Hiding Ribbon: Auto-Hiding displays our workbook in full-screen mode and completely hides the ribbon. To show the ribbon, click the Expand ribbon command at the top of the screen.
- Show tabs: This option hides all command groups when not in use, but the tabs will remain clear. To show the ribbon, just click on the tab.
- Show Tabs and Commands: This option maximizes the ribbon. All tabs and commands will be clear. This option is selected by default when we open Excel for the first time.
To customize the ribbon in Excel 2016
We can customize the ribbon by making our tabs with whatever order we want. Commands are always placed in a group, and we can create as many groups as we can to keep our tabs organized. If we wish, we can add commands to any of the default tabs, as long as we create a custom group in the tab.
- Right-click the ribbon and then choose Customize Ribbon from the drop-down menu.
- There will be an Excel Options dialog box. Locate and select the new tab.
- To ensure that the new group is selected, choose a command, and then click Add. We can also drag the command directly to a group.
- When we add the command, click OK. Orders will be added to the ribbon.
In the formula bar, we can edit or edit data, a formula, or a function that will be in a specific cell.
In the image below, cell C1 is selected, and 2000 is entered into the formula bar. Note how the data includes both the formula bar and cell C1.
The name box represents the location or “name” of the selected cell.
In the image below, cell B4 is selected. It is noted that cell B4 is the location where column B and row 4 intersect.
Backstage View (File Menu)
Click the File tab on the ribbon. View of backstage will be revealed.
Excel 2016 has a variety of display options that change how our workbook is displayed. We can choose to view any workbook in Normal view, Page layout view or Page break view. These ideas can be useful for many tasks, especially if we plan to print a spreadsheet.
To change the views of the worksheet, locate and select the desired worksheet view command in the lower-right corner of the Excel window.
To use the zoom control, click and drag the slider. The numbers on the right side of the slider reverse the zoom percentage.