Your work, daily life, or any other activities will require you to use the MS Excel, regardless of your qualifications and position.
Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc.
An Excel spreadsheet can be understood as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows. The point where a column and a row meet are called a cell.
Understanding Ribbons
Ribbon components explained
Ribbon start button — it is used to access commands i.e., creating new documents, saving existing work, printing, accessing the options for customizing Excel, etc.
Ribbon tabs — the tabs are used to group similar commands together. The home tab is used for basic commands such as formatting the data to make it more presentable, sorting and finding specific data within the spreadsheet.
Ribbon bar — the bars are used to group similar commands together. As an example, the Alignment ribbon bar is used to group all the commands that are used to align data together.
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers.
A workbook is a collection of worksheets. By default, a workbook has three cells in Excel. You can delete or add more sheets to suit your requirements. By default, the sheets are named Sheet1, Sheet2 and so on and so forth. You can rename the sheet names to more meaningful names i.e. Daily Expenses, Monthly Budget, etc.
Shortcut Keys
Description
Excel Shortcuts
1. To create a new workbook — Ctrl + N
2. To open an existing workbook — Ctrl + O
3. To save a workbook — Ctrl + S
4. To close the current workbook — Ctrl + W
5. To close Excel — Ctrl + F4
6. To move to the next sheet — Ctrl + PageDown
7. To move to the previous sheet — Ctrl + PageUp
8. To go to the Data tab — Alt + A
9. To go to the View tab — Alt + W
10. To go the Formula tab — Alt + M
11. To edit a cell — F2
12. To copy and paste cells — Ctrl + C, Ctrl + V
13. To italicize and make the font bold — Ctrl + I, Ctrl + B
14. To center align cell contents — Alt + H + A + C
15. To fill color — Alt + H + H
16. To add a border — Alt + H + B
17. To remove outline border — Ctrl + Shift + _
18. To add an outline to the select cells — Ctrl + Shift + &
19. To move to the next cell — Tab
20. To move to the previous cell — Shift + Tab
21. To select all the cells on the right — Ctrl + Shift + Right arrow
22. To select all the cells on the left — Ctrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the table — Ctrl + Shift + Down Arrow
24. To select all the cells above the selected cell — Ctrl + Shift + Up Arrow
25. To select all the cells below the selected cell — Ctrl + Shift + Down Arrow
Basic Excel videos for Understanding the Process
3. Pivot Table
4. VLOOKUP
Feel free to suggest any changes and inclusion in this article
connect over linkedIN
