Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB01-Gradebook-Finished.xlsx
Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class13-ExcelBasics01-IntroductionToExcel01.pdf
Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm
Topics in this video:
1. (00:01) Introduction
2. (01:30) Excel file = “Workbook”, not “Document”
3. (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers)
4. (02:29) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5. (03:46) Worksheet = Sheet = All the Cells
6. (03:55) Sheet Tab = Name of worksheet and Insert New Sheets
7. (04:18) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
8. (04:18) You can add new sheets with Plus button to the right of the sheets:
9. (05:00) Workbook = All the sheets = File = File Name
10. (05:20) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
11. (05:20) Move Cursor
12. (05:20) Fill Handle = after you select a cell the little black square in the lower right corner.
13. (05:20) Cross Hair or “Angry Rabbit” Cursor
14. (06:45) Entering data or formulas
15. (07:42) Cross Hair or “Angry Rabbit” Cursor Magic
16. (13:22) Default Alignment In Excel:
17. (14:20) Stylistic Formatting examples:
18. (17:22) Select whole table:
19. (18:35) Entering data into a large range of cells
20. (22:05) Formulas
21. (22:05) First Formula using SUM
22. (24:37) Cell References
23. (26:15) AVERAGE Function
24. (34:40) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
25. (42:30) Number Formatting
26. (47:52) Page Setup
27. (58:32) Move Sheet and Copying Sheet:
28. (01:01:47) Summary
Видео Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup канала ExcelIsFun
Download Excel Finished File: Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB01-Gradebook-Finished.xlsx
Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class13-ExcelBasics01-IntroductionToExcel01.pdf
Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm
Topics in this video:
1. (00:01) Introduction
2. (01:30) Excel file = “Workbook”, not “Document”
3. (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers)
4. (02:29) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5. (03:46) Worksheet = Sheet = All the Cells
6. (03:55) Sheet Tab = Name of worksheet and Insert New Sheets
7. (04:18) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
8. (04:18) You can add new sheets with Plus button to the right of the sheets:
9. (05:00) Workbook = All the sheets = File = File Name
10. (05:20) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
11. (05:20) Move Cursor
12. (05:20) Fill Handle = after you select a cell the little black square in the lower right corner.
13. (05:20) Cross Hair or “Angry Rabbit” Cursor
14. (06:45) Entering data or formulas
15. (07:42) Cross Hair or “Angry Rabbit” Cursor Magic
16. (13:22) Default Alignment In Excel:
17. (14:20) Stylistic Formatting examples:
18. (17:22) Select whole table:
19. (18:35) Entering data into a large range of cells
20. (22:05) Formulas
21. (22:05) First Formula using SUM
22. (24:37) Cell References
23. (26:15) AVERAGE Function
24. (34:40) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
25. (42:30) Number Formatting
26. (47:52) Page Setup
27. (58:32) Move Sheet and Copying Sheet:
28. (01:01:47) Summary
Видео Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & ChartsCreating Easy Data Entry Forms in Excel50 Ultimate Excel Tips and Tricks for 2020How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work filesSpreadsheets #1: IntroductionThe Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours!Excel Formulas and Functions TutorialExcel Data Analysis Class 01: PivotTables, Power Query, Formulas and ChartsTop 10 Most Important Excel Formulas - Made Easy!Intermediate Excel Skills, Tips, and Tricks TutorialExcel How-To: Starting a Basic SpreadsheetExcel 2019 Beginner TutorialExcel စာရင်းဇယားရေးဆွဲနည်း သင်ခန်းစာ - အစအဆုံးExcel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)Basic Excel Formulas and Functions You NEED to KNOW!Excel Tutorial for Beginners | Excel Made EasyExcel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)Microsoft excel from beginner to advanced (full course) - in AmharicBasic Excel Formulas - Add, Subtract, Divide, Multiply