Главная
Study mode:
on
1
) Introduction
2
) Excel file = “Workbook”, not “Document”
3
) Columns (Represented by Letters) and Rows (Represented by Numbers)
4
) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5
) Worksheet = Sheet = All the Cells
6
) Sheet Tab = Name of worksheet and Insert New Sheets
7
) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
8
) You can add new sheets with Plus button to the right of the sheets:
9
) Workbook = All the sheets = File = File Name
10
) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
11
) Move Cursor
12
) Fill Handle = after you select a cell the little black square in the lower right corner.
13
) Cross Hair or “Angry Rabbit” Cursor
14
) Entering data or formulas
15
) Cross Hair or “Angry Rabbit” Cursor Magic
16
) Default Alignment In Excel:
17
) Stylistic Formatting examples:
18
) Select whole table:
19
) Entering data into a large range of cells
20
) Formulas
21
) First Formula using SUM
22
) Cell References
23
) AVERAGE Function
24
) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
25
) Number Formatting
26
) Page Setup
27
) Move Sheet and Copying Sheet:
28
) Summary
Description:
Learn essential Excel skills in this comprehensive tutorial video. Master workbook structure, cell referencing, and sheet management. Explore data entry techniques, formatting options, and cursor functionalities. Dive into formula creation using SUM and AVERAGE functions, and understand relative and absolute cell references. Practice applying number formats, setting up pages for printing, and manipulating sheets within a workbook. Ideal for beginners, this video provides a solid foundation for Excel proficiency, complete with downloadable resources and step-by-step guidance.

Excel Basics - Introduction to Excel - Formatting, Formulas, Cell References, Page Setup

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Computer Science #Information Technology #Data Management #Data Entry
1 of 28

) Introduction