BASICS OF MICROSOFT EXCEL

We can’t assume any job/work without an Excel, if we go for any job interview which requires basic excel skills.

Basic means we should be familiar with Excel ribbons, Workbook, how to format the data, how to use basic calculations, and keyboard shortcuts etc…

These are some important areas in the excel.

1. Ribbon: It is like an expanded menu and shows all the features of Excel(Home, Insert, Formulas, Formuls, Page Layout, Data..). We need learn how to collapse and customize the ribbon which is At the top of the Excel window.
2. Formula Bar: At the top of the Excel window, just below the ribbon area, if we want to write any calculations then start building formulas. Simply typing a formula in a cell is the straightforward method of inserting basic formulas.(starts by typing an equal sign(=), followed by the name of the function=sum()).
3. Workbook: A workbook is synonym for your Excel file. When you open your Excel, click blank workbook to create a new Excel workbook from scratch.
4. Sheets/Worksheets: A worksheet is a collection of cells organised in rows and columns here we enter data and manipulate the data. Each workbook may contain multiple worksheets(Default: Sheet1, Sheet2, Sheet3).
5. Formatting Cells: When we want to change the appearance of a number without changing the number itself is called formatting.
6. Find, Copy and Paste : When we want to find, copy, paste the text/data in a worksheet we use Find(CTRL+F), Copy(CTRL+C) and Paste(CTRL+V).
7. Templates: There is a smart way to create beautiful workbook instead of creating from scratch. For this we can use available templates, there are many free templates available in Excel.
8. Status bar: This displays what is going on with Excel.
9. Protect: If we want to protect an excel file, encrypt file with a password.

10. Keyboard Shortcuts: Remember some important Keyboard shortcuts with your keyboard to increase your efficiency.

Create a new workbook: Ctrl+N

Open an existing workbook: Ctrl+O

Save a workbook: Ctrl+S

Copy the data: Ctrl+C

Cut the data: Ctrl+X

Paste selected data: Ctrl+V

Undo an action: Ctrl+Z

Redo an action: Ctrl+Y

Go to the next cell: Tab

Go to the previous cell: Shift+Tab

Select entire row: Shift+Space

Select entire column: Ctrl+Space

Hide rows: Ctrl+9

Hide columns: Ctrl+0

To Copy Formula from above cell: Ctrl+‘

Copy Value from the above cell: Ctrl+Shift+”

Happy Learning !!! :)

My_website | Facebook | Twitter | Instagram | Youtube