Complete Excel guide for beginners

1. What is MS-Excel?

MS Excel is a spreadsheet program that allows you to store data in the form of tables. This provides the user with a more systematic data display.

2. How to Open Excel on any windows PC.

Press Win Key + R

Type "excel" without quotation marks and Enter.

3. Tab

Home/insert/Page Layout/Formula/ Data/Review/View these all are called Tab.

4. Ribbon

The Excel ribbon is a set of tabs at the top of the Excel interface that assist users in navigating and finding commands when using Excel.

5. Cell

Cells are the boxes that appear in the grid of an Excel worksheet such as this one. On a worksheet, each cell is identified by its reference, the column letter and row number that intersect at the cell's location.

6. Name Box

The Name Box in Microsoft Excel displays the cell that is currently selected in the spreadsheet. It can be found to the left of the formula bar. If a name has been assigned to a selected cell, the Name Box displays that name. You can also use the Name Box to give a name to a specific cell.

7. Formula Bar

A formula bar is a handy tool in Excel and other spreadsheet applications. It allows you to see the contents of the current cell and create or view formulas. This can be extremely helpful when working with complex data sets.

8. Every formula Start with "=" sign.

Text always align from left side and Number always align from Right side by default in Excel.

10. Column And Row

11.

Ctrl + Right Arrow go to the last Column.

Ctrl + Down Arrow go to the last Row.

Excel has 16384 Columns and 10,48576 Rows.

Note: Excel works slow on super large data.

12. Insert new sheet using Shift + F11 shortcut Key.

Sheet/Worksheet: A sheet in a workbook is a single page within the file. This page can contain data, formulas, and other information that you want to use in your Excel workbook.

Name to a Sheet: Right-click on the sheet and click on Rename. Give a name as your requirement.

13. Ctrl + Z = Undo

Ctrl + Y = Redo

We've all been there – we're working on a project in Excel and we make a mistake. Luckily, there's an undo button! This button allows us to revert our worksheet to the state it was in just before we performed the most recent action.

The undo button is a lifesaver, but it's important to know that it only undoes the most recent action. So, if you make a series of mistakes, you'll need to hit the undo button multiple times to get back to where you started.

The redo button has the opposite effect of undo – it redoes what you've just undone. So, if you accidentally delete something, you can hit the redo button to put it back.

Knowing how to use the undo and redo buttons is a essential skill for anyone who uses Excel regularly. So next time you make a mistake, don't panic – just hit the undo button!