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 via YouTube
Overview
Syllabus
) Introduction.
) Excel file = “Workbook”, not “Document”.
) Columns (Represented by Letters) and Rows (Represented by Numbers).
) Cells = Intersection of Column and Row = Name or Address like B5 or A1.
) Worksheet = Sheet = All the Cells.
) Sheet Tab = Name of worksheet and Insert New Sheets.
) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter.
) You can add new sheets with Plus button to the right of the sheets: .
) Workbook = All the sheets = File = File Name.
) Selection Cursor is the “thick white cross with a slight black shadow” cursor. .
) Move Cursor.
) Fill Handle = after you select a cell the little black square in the lower right corner. .
) Cross Hair or “Angry Rabbit” Cursor.
) Entering data or formulas.
) Cross Hair or “Angry Rabbit” Cursor Magic.
) Default Alignment In Excel:.
) Stylistic Formatting examples:.
) Select whole table:.
) Entering data into a large range of cells.
) Formulas.
) First Formula using SUM.
) Cell References.
) AVERAGE Function.
) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell .
) Number Formatting.
) Page Setup.
) Move Sheet and Copying Sheet:.
) Summary.
Taught by
ExcelIsFun
