MS Excel Tutorial
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 comprises tabs, groups of commands and worksheet. It is mainly used to store tabular data.
Our MS Excel tutorial includes 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 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.
Microsoft Excel Features
There are several features that are available in Excel to make our task more manageable. Some of the main features are:
AutoFormat - lets us choose many preset table formatting options.
How to Open Microsoft Excel?
When you open Excel 2016 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.
To set up Excel, so it automatically accessible a new 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. When maximized, the Excel Workbook Window composite in with the Application Window.
After completing this module, we should be able to:
The Application Window provides the space for our worksheets and workbook items, such as charts. The components of the Application Window are defined below.
Quick Access Toolbar
The Quick Access Toolbar lets us access common commands no matter which tab is selected.
By default, it involves the Save, Undo, and Repeat commands. We can add other commands depending on our preference.
To add the command to the Quick Access toolbar
Excel 2016 utilizes a tabbed Ribbon system instead of traditional menus. The Ribbon includes multiple tabs, each with several groups of commands. We will use these tabs to perform the most common function 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 too much screen space.
To Customize the Ribbon in Excel 2016
We can customize the Ribbon by creating your tabs with whichever commands we want. Commands are always housed within a group, and we can create as many groups as we want to keep our tab organized. If we want, we can even add commands to any of the default tabs, as long as we create a custom group in the tab.
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 C1 is selected, and 2000 is entered into the formula bar. Note how the data contains in both the formula bar and in cell C1.
The Name Box
The Name box present the location or "name" of a selected cell.
In the image below, cell B4 is selected. Noted that cell B4 is where column B and row 4 intersect.
The Backstage View (The File Menu)
Click the File tab on the Ribbon. The Backstage view will emerge.
The Worksheet Views
Excel 2016 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.
To use a Zoom control, click and drag the slider. The number to the right of the slider reverse the zoom percentage.
Before learning MS Excel, you must have the basic knowledge of Computer Fundamental.
Our MS Excel tutorial is designed to help beginners and professionals.
We assure that you will not find any problem in this MS Excel tutorial. But if there is any mistake, please post the problem in contact form.