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 1758
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 1758
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 1758
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 1758
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 1758
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 1758
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 1758
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 1758
{"id":303,"date":"2017-06-27T12:48:23","date_gmt":"2017-06-27T19:48:23","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=303"},"modified":"2017-06-27T12:48:23","modified_gmt":"2017-06-27T19:48:23","slug":"the-magic-of-excel-formulas-pivottables-charts-flash-fill-sort-filtering-functions-more","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2017\/06\/the-magic-of-excel-formulas-pivottables-charts-flash-fill-sort-filtering-functions-more\/","title":{"rendered":"The Magic of Excel: Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & more!!"},"content":{"rendered":"This video in an introduction to Excel and the Magic it can do to make your life and job easier, more efficient and more fun! It is an introduction to many of the amazing features in Excel that can help us in our job, life and in school. This video is part of Highlines effort to show students that going to college can be fun and amazing for empowering student to do what they want in life!<\/p>\n
Download File Here:
\nStart File: http:\/\/ift.tt\/2sexb9S
\nFinished File: http:\/\/ift.tt\/2sYhnW6 File.xlsx
\nEntire page with all Excel Files for All Videos: http:\/\/ift.tt\/1kSFWvs<\/p>\n
Topics in this video:
\n1. (00:36) What is Excel?
\n2. (03:11) What does Excel do? 1) Calculations, 2) Storing & Formatting Data, 3) Data Analysis
\n3. (10:28) Formatting to make our Data Look Good. Build a Template that you can use over and over.
\n4. (12:35) See how to create a List of Days of the Week Quickly using the “Angry Rabbit”.
\n5. (16:14) Formulas & Cell References to make our Job Easier! Learn about the Excel Functions: SUM, AVERAGE, MAX and MIN.
\n6. (21:10) Keyboard Shortcuts are Amazing. Learn how to highlight 5000 rows of data quickly.
\n7. (26:52) Payroll Tax Calculations Hard? Not With Excel : )
\n8. (29:59) Relative Cell References in Formulas
\n9. (31:01) Absolute Cell References in Formulas
\n10. (36:10) Excel Table Feature makes everything Dynamic!!! Learn about how to Sort, Filter and create Dynamic Ranges (Update Automatically) using the Excel Table Features.
\n11. (44:31) Chart Your Results Dynamically!! Learn how to create a Column Chart for visualizing the difference across Categories.
\n12. (48:53) Boss Ask you to add All Sales for Each Employee!?!? Easy with a PivotTable! See how to create a Sales Report with a PivotTable, including how to Format and Pivot the PivotTable.
\n13. (56:20) Flash Fill to transform your Data in Seconds!
\n14. (60:05) Summary of all topics.<\/p>\n