Microsoft Excel Training: Workbooks, Worksheets and Excel Basics (Part 1)
Explore “Workbooks, Worksheets and Excel Basics” in this Microsoft Excel Training lesson. Part 1 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Microsoft Excel Training
- Lecture one
- MICROSOFT EXCEL OVERVIEW
- Default Name of MS- EXCEL Workbook: BOOK1
- Worksheet is a grid made up of horizontal row and vertical columns .The
Contents
- Read the original document
- Microsoft Excel Training
- Lecture one
- MICROSOFT EXCEL OVERVIEW
- Default Name of MS- EXCEL Workbook: BOOK1
- Worksheet is a grid made up of horizontal row and vertical columns .The
- OFFICE BUTTON
- ENTERING DATA
- CELL REFERENCING
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel Training: original teaching slides for this study series.
Microsoft Excel Training
Microsoft Excel Training Asst. Lec. Zahraa Najim Abdullah July 2021 Asst. Lec. Huda Ragheb Kadhim
Lecture one
Lecture one.
MICROSOFT EXCEL OVERVIEW
MICROSOFT EXCEL OVERVIEW
Default Name of MS- EXCEL Workbook: BOOK1
Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). Default Name of MS- EXCEL Workbook: BOOK1 Extension of MS-EXCEL: .xls
It is a table format which uses rows & columns to make any report & table. It is consists of workbook. MS-EXCEL Overview
Worksheet is a grid made up of horizontal row and vertical columns .The
Worksheet is a grid made up of horizontal row and vertical columns .The Excel 2007 worksheet contains 1048576 rows and 16384 columns . Each intersection of a row and a column forms a cell , in which the user can store data . SPREADSHEET DETAILS Active cell Office button Formula BAR column Letter Row Number sheet tab
OFFICE BUTTON
OFFICE BUTTON
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
ENTERING DATA
ENTERING DATA
CELL REFERENCING
Cell and Range References :- A reference identifies a cell or a range of cells on a worksheet and tells Microsoft Excel where to looks for the values or data the user wants to use in a formula . The user can also refer to cells on other sheets in the same workbook , and to other workbooks. References to cells in other workbooks are called links .
Relative cell References :- This is the most widely used type of cell references in formulas . Relative cell references are basic cell references that adjust and change when copied or when using Autofill.
Absolute cell References :- When a formula or function is copied or moved to another location , any cell references in the formula or function get adjusted as well . However there are some situations where a cell reference inside a formula must ALWAYS refer to the same cell. CELL REFERENCING
Review questions and answers
What are the key points about Microsoft Excel Training?
Microsoft Excel Training Asst. Lec. Zahraa Najim Abdullah July 2021 Asst. Lec. Huda Ragheb Kadhim
What are the key points about Default Name of MS- EXCEL Workbook: BOOK1?
Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). Default Name of MS- EXCEL Workbook: BOOK1 Extension of MS-EXCEL: .xls It is…
What are the key points about Worksheet is a grid made up of horizontal row and vertical columns .The?
Worksheet is a grid made up of horizontal row and vertical columns .The Excel 2007 worksheet contains 1048576 rows and 16384 columns . Each intersection of a row and a column forms a cell , in which the user can store data . SPREADSHEET DETAILS Active cell Office button Formula BAR column Letter Row Number sheet tab
What are the key points about CELL REFERENCING?
Cell and Range References :- A reference identifies a cell or a range of cells on a worksheet and tells Microsoft Excel where to looks for the values or data the user wants to use in a formula . The user can also refer to cells on other sheets in the same workbook , and to other workbooks. References to cells in other workbooks are called links . Relative…
More lessons from this document
- Microsoft Excel Training — Part 1
- Microsoft Excel Training — Part 2
- Microsoft Excel Training — Part 3
- Microsoft Excel Training — Part 4
- Microsoft Excel Training — Part 5
Conclusion
The important points in Microsoft Excel Training should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.