Okebiz Video Search



Title:Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup
Duration:01:02:55
Viewed:642,345
Published:14-10-2017
Source:Youtube

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: https://people.highline.edu/mgirvin/Y...
Download Full Written Notes: https://people.highline.edu/mgirvin/Y...
Class web page link: https://people.highline.edu/mgirvin/A...

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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts Excel Basics 2: Introduction to Excel 2: Excel'...
37:50 | 200,234
Microsoft Excel Tutorial -  Beginners Level 1 Microsoft Excel Tutorial - Beginners Level 1
32:49 | 845,866
Creating Easy Data Entry Forms in Excel Creating Easy Data Entry Forms in Excel
09:52 | 551,234
How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files How to Pass Excel Assessment Test For Job Appli...
19:48 | 662,469
Top 10 Most Important Excel Formulas - Made Easy! Top 10 Most Important Excel Formulas - Made Easy!
27:19 | 382,813
50 Ultimate Excel Tips and Tricks for 2020 50 Ultimate Excel Tips and Tricks for 2020
50:17 | 642,514
Excel Crash Course - Learn PivotTables in 1 Hour - Microsoft Excel Tutorial Excel Crash Course - Learn PivotTables in 1 Hou...
02:01 | 109,702
Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3) Excel Basics 3: Count & Add with COUNT, COUNTA,...
21:07 | 127,824


coinpayu