Training Topics - Anatomy of Excel
Duration: 01:00:02 mins
Language: English
Class Files
[ Ссылка ]
Excel's anatomy can be broken down into several key components:
Workbooks and Worksheets: A workbook is the entire Excel file, containing one or more worksheets. Worksheets are the individual sheets within a workbook, organized as a grid of rows and columns.
Cells: The intersection of a row and column forms a cell, the fundamental unit for data entry and storage. Each cell has a unique address (e.g., A1, B2).
Rows and Columns: Rows run horizontally and are numbered; columns run vertically and are lettered (A, B, C...).
Data Entry: You input data directly into cells, which can be numbers, text, dates, formulas, or functions.
Formulas and Functions: Formulas perform calculations using cell references, while functions are pre-built formulas for specific tasks (e.g., SUM, AVERAGE, IF).
Charts and Graphs: Visual representations of data, created from worksheet data to facilitate understanding and analysis.
Ribbon: The toolbar at the top, providing access to various commands and options.
Navigation: Features like scroll bars, sheet tabs, and the name box allow for easy movement and selection within the workbook.
Data Analysis Tools: Excel offers tools for sorting, filtering, data validation, and more complex analysis techniques (e.g., pivot tables).
Time Stamp
00:01 - Introduction of XL Super User Program
01:00 - Anatomy of Excel
04:00 - Rows and Columns in Excel
04:30 - Navigation in Excel
06:20 - introduction of Excel Options
08:03 - Name Box and Cell References
09:44 - Freeze Pane
12:05 - Row and Column Selection using Keyboard
14:00 - Save Excel in Xlsx, Autosave
16:22 - Excel Save as format xls,xlsx,xlsm,xlsb,csv,txt,pdf & xps
43:30 - Excel Data Type and Alignment
47:15 - Number Formatting
51:30 - Cursor in Excel
53:30 - Keyboard Usage in Excel
