If you are looking for MS Excel Notes PDF, then you are in the right place. At the end of this post, we have added a button to directly download the PDF of Microsoft Excel Lecture Notes for free.
MS Excel Notes PDF
Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides many facilities to perform various operations such as calculations, pivot tables, graph tools, macro programming, etc. It is compatible with multiple OS such as Windows, macOS, Android, and iOS.
- An Excel spreadsheet can be thought of as a collection of columns and rows that make up a table
- Letters of the alphabet are usually assigned to columns, and numbers are usually assigned to rows.
- 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.
- The point where a column and a row meet is called a cell.
- The address of a cell is given by a letter representing the column and a number representing the row.
- Columns are usually labeled with letters while rows are usually numbers.
- By default, the sheets are named Sheet1, Sheet2, and so on. You can rename the sheet names to more meaningful names, such as Daily Expenses, Monthly Budget, etc.
- A workbook is a collection of worksheets. By default, a workbook in Excel consists of three cells. You can remove or add more sheets to suit your needs.
Excel Shortcuts
Here we have shared some frequently used MS Excel Shortcut Keys.
| Shortcut Keys | Description |
|---|---|
| Ctrl + P | used to open the print dialogue window |
| Ctrl + N | creates a new workbook |
| Ctrl + V | paste data from the clipboard |
| Ctrl + C | copy contents of current select |
| F2 | Check formula and cell range covered |
| Ctrl + S | saves the current workbook |
| SHIFT + F3 | displays the function insert dialog window |
| SHIFT + F11 | Creates a new worksheet |
If you want to download MS Excel Guidebook PDF, then click on the download button provided at the end of this post.
Checkout:
- Physics Project for Class 12 PDF
- Social Science Project for Class 10 PDF
- West Bengal Old Electoral Roll PDF
Download MS Excel Notes PDF
To download MS Excel Basic to Advance Guide PDF, then just click on the below download button. Within a few seconds, MS Excel Latest Version Notes will be on your device.