The arrow keys in your keyboard can be used to migrate from cell to cell. The most important ribbons that you will need while working with Excel are Home, Excel Formulas, Insert, Data and Page Layout.īasics of how to use Microsoft Excel SkillsĪfter familiarizing myself with the feature panel, it is time to get some hands-on experience to use Microsoft Excel Skills. That is why the Ribbon concept is introduced, where the features are grouped in ribbons and displayed.

Microsoft Excel Skills has a lot and lots of functions that can be enlisted in a small window.

In addition, you can add any feature available in Microsoft Excel for your convenience.

The quick access toolbar is where you can enlist the important tools you frequently use other than Save, Redo, and Undo.

The tabs can be renamed as per convenience. You c switch from one sheet to another just by clicking the tabs below at the bottom of the window.

When you open a Microsoft Excel spreadsheet, it looks like a workbook with three blank sheets to work on.This bar displays the content of the cells that have been selected. Above column D, there is a tab that starts with ‘fx’ in italics.The cursor position will change the respective column and row color to highlight the reference. Above column A, a Name Box displays the name of the selected cell or the reference or where the cursor is stagnant.To add the numbers in cells B2 and B3, enter the command =B2+B3, and you will get the answer. The cell references are used to create formulas and functions to input, manage and execute data.This numbering helps you to assign the names of the cells for further references and executions. For example, the columns are alphabetically numbered starting from A, and the rows are chronologically numbered starting from 1. Microsoft Excel worksheet comprises of a lot of salient features, which makes its use infinite. It is a 2-dimensional grid of rows and columns, which we popularly call it as a spreadsheet.Excel functions, formula, charts, formatting creating excel dashboard & others About the Microsoft Excel software

Steps on how to use microsoft excel