Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
{"id":395,"date":"2017-10-14T15:26:21","date_gmt":"2017-10-14T22:26:21","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=395"},"modified":"2017-10-14T15:26:21","modified_gmt":"2017-10-14T22:26:21","slug":"excel-basics-1-introduction-to-excel-formatting-formulas-cell-references-page-setup","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2017\/10\/excel-basics-1-introduction-to-excel-formatting-formulas-cell-references-page-setup\/","title":{"rendered":"Excel Basics 1: Introduction To Excel: Formatting, Formulas, Cell References, Page Setup"},"content":{"rendered":"Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Finished File: Download File: http:\/\/ift.tt\/2kPLWg5
\nDownload Full Written Notes: http:\/\/ift.tt\/2xFJdfr
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (01:30) Excel file = \u201cWorkbook\u201d, not \u201cDocument\u201d
\n3. (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers)
\n4. (02:29) Cells = Intersection of Column and Row = Name or Address like B5 or A1
\n5. (03:46) Worksheet = Sheet = All the Cells
\n6. (03:55) Sheet Tab = Name of worksheet and Insert New Sheets
\n7. (04:18) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
\n8. (04:18) You can add new sheets with Plus button to the right of the sheets:
\n9. (05:00) Workbook = All the sheets = File = File Name
\n10. (05:20) Selection Cursor is the \u201cthick white cross with a slight black shadow\u201d cursor.
\n11. (05:20) Move Cursor
\n12. (05:20) Fill Handle = after you select a cell the little black square in the lower right corner.
\n13. (05:20) Cross Hair or \u201cAngry Rabbit\u201d Cursor
\n14. (06:45) Entering data or formulas
\n15. (07:42) Cross Hair or \u201cAngry Rabbit\u201d Cursor Magic
\n16. (13:22) Default Alignment In Excel:
\n17. (14:20) Stylistic Formatting examples:
\n18. (17:22) Select whole table:
\n19. (18:35) Entering data into a large range of cells
\n20. (22:05) Formulas
\n21. (22:05) First Formula using SUM
\n22. (24:37) Cell References
\n23. (26:15) AVERAGE Function
\n24. (34:40) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
\n25. (42:30) Number Formatting
\n26. (47:52) Page Setup
\n27. (58:32) Move Sheet and Copying Sheet:
\n28. (01:01:47) Summary<\/p>\n