Microsoft Excel is one of the most suitable spreadsheet functions that help us manage data, create optically logical charts, and thought-provoking graphs. Microsoft Excel is supported by both Mac and PC platforms. Microsoft Excel can also be used to balance a checkbook, create an expense document, build formulas, and edit them.
It mainly comprises tabs, groups of commands, and worksheets. The worksheet is made of rows and columns that intersect each other to form cells where data is entered. It is capable of performing multiple tasks like calculations, data analysis, and integrating 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.
How to Open Microsoft Excel?
When you open Excel for the first time, the Excel Start Screen will occur. From here, we’ll be able to create a new workbook, choose a template, and access our recently edited workbooks.
From the Excel Start Screen, locate and select the Blank workbook to create the Excel interface.
To click Open Other Workbooks to work on an existing workbook.
After starting Excel, we will see two windows – one within the other. The outer window is the Application Window, and the inner window is a Workbook Window.
The Application Window provides the space for our worksheets and workbook items, such as charts. The components of the Application Window are:
- Quick Access Toolbar
- The Ribbon
- The Formula Bar
- The Backstage View (The File Menu)
- The Worksheet Views
- Zoom Control
Quick Access Toolbar
Quick Access Toolbar lies next to the Microsoft Office Button. It is a customizable toolbar that comes with a set of independent commands. It gives you quick access to commonly used commands such as Save, Undo, Redo, etc.
When you click the drop-down arrow next to toolbar it offers more commands. With a left click you can add any of these commands to Quick Access Toolbar. You can also remove the commands added to the tool bar. The indent, spacing values, individual styles and other features that appear on the ribbon cannot be added to quick access toolbar.
The Ribbon is a user interface element which was introduced by Microsoft in Microsoft Office 2007. It is located below the Quick Access Toolbar and the Title Bar.
It comprises seven tabs; Home, Insert, Page layout, References, Mailing, Review and View. Each tab has specific groups of related commands. It gives you quick access to the commonly used commands that you need to complete a task.
The Formula Bar
In the formula bar, we can enter or edit data, a formula, or a function that will occur in a specific cell. In the image below, cell B2 is selected, and 5000 is entered into the formula bar. Note how the data contains in both the formula bar and in cell B2.
The Name Box
The Name box present the location or “name” of a selected cell. In the image below, cell C3 is selected. Noted that cell C3 is where column C and row 3 intersect.
The Backstage View (The File Menu)
Click the File tab on the Ribbon. The Backstage view will emerge.
The Worksheet Views
Excel has a variety of displaying options that change how our workbook is showed. We can choose to view any workbook in the Normal view, Page Layout view, or Page Break view. These views can be useful for several tasks, especially if we’re planning to print the spreadsheet. To change the worksheet views, locate and choose the desired worksheet view command in the bottom-right corner of the Excel window.
When you want to quickly change the magnification of a worksheet, use the Zoom slider. You’ll find the Zoom slider in the bottom right corner of the Excel window. To use the Zoom slider, drag the slider to the right or to the left. To zoom in, drag the slider to the right.