MS Excel TutorialMS 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 thoughtprovoking 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 FeaturesThere 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
Excel InterfaceAfter 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:
Application WindowThe 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
The Ribbon 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 bottomright corner of the Excel window. Zoom Control To use a Zoom control, click and drag the slider. The number to the right of the slider reverse the zoom percentage. PrerequisiteBefore learning MS Excel, you must have the basic knowledge of Computer Fundamental. AudienceOur MS Excel tutorial is designed to help beginners and professionals. ProblemWe 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.

 Maths Calculators
 All Calculators
 Calculators List
 Algebra Calculator
 Equation Solver
 Graphing Calculator
 Elimination Calculator – Solve System of Equations with
 Derivative Calculator
 Absolute Value Equation Calculator
 Adding Fractions Calculator
 Factoring Calculator
 Fraction Calculator
 Inequality Calculator
 Mixed Number Calculator
 Percentage Calculator
 Quadratic Equation Solver
 Quadratic Formula Calculator
 Scientific Notation Calculator
 Simplify Calculator
 System of Equations Calculator
 Class 12
 Class 11
 Class 10
 Class 9
 Class 8
 Class 7
 Class 6
 NCERT SOLUTIONS (15)
 NCERT MCQs
 Tally
 Accounting in Hindi
 Ms Office
 Python Tutorial
 Maths Calculators
 All Calculators
 Calculators List
 Algebra Calculator
 Equation Solver
 Graphing Calculator
 Elimination Calculator – Solve System of Equations with
 Derivative Calculator
 Absolute Value Equation Calculator
 Adding Fractions Calculator
 Factoring Calculator
 Fraction Calculator
 Inequality Calculator
 Mixed Number Calculator
 Percentage Calculator
 Quadratic Equation Solver
 Quadratic Formula Calculator
 Scientific Notation Calculator
 Simplify Calculator
 System of Equations Calculator
 Class 12
 Class 11
 Class 10
 Class 9
 Class 8
 Class 7
 Class 6
 NCERT SOLUTIONS (15)
 NCERT MCQs
 Tally
 Accounting in Hindi
 Ms Office
 Python Tutorial