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":322,"date":"2017-07-10T14:23:39","date_gmt":"2017-07-10T21:23:39","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=322"},"modified":"2020-02-12T10:50:51","modified_gmt":"2020-02-12T17:50:51","slug":"excel-for-accountants-formulas-functions-formatting-to-build-account-templates-37-examples","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2017\/07\/excel-for-accountants-formulas-functions-formatting-to-build-account-templates-37-examples\/","title":{"rendered":"Excel for Accountants: Formulas, Functions & Formatting to Build Account Templates (37 Examples)"},"content":{"rendered":"Download File:
\nStart File: http:\/\/ift.tt\/2tB6Zp7
\nFinished File:\u00a0 http:\/\/ift.tt\/2t6W9Uh
\nEntire page with all Excel Files for All Videos: http:\/\/ift.tt\/1kSFWvs<\/p>\n
This is the first video in a series of two videos.
\nThis video will teach you everything you need to know about Excel for your Accounting Job : )<\/p>\n
Topics in Video:
\n(00:08) Introduction to video topics and Excel files and how to navigate large workbook and video
\n1. (02:13) Keyboards Rule Because They Are Fast
\n2. (04:33) Number Formatting is a Fa\u00e7ade
\n3. (07:01) How to Add Quickly
\n4. (10:15) Date Calculation Templates
\n5. (10:50) TODAY and (19:50) EDATE functions
\n6. (12:24) Angry Rabbit Mouse Copy Trick
\n7. (14:46) Date Number Formatting
\n8. (17:05) Formulas for Date Calculations
\n9. (20:21) Absolute & Relative Cell References
\n10. (22:15) Excel’s Golden Rule
\n11. (24:46) Payroll Quickly
\n12. (24:46) ROUND Function Importance
\n13. (24:46) Formulas Can NOT See Number Formatting
\n14. (31:40) Create Cosumer Loan Amortization Table
\n15. (33:13) PMT Function to calculate PMT on Annuity with Regular PMT and Constant Rate
\n16. (36:44) Fill Series to generate list of numbners from 0 to 360
\n17. (38:51) Smart Tags to Fill End of Month Only (And it knows Leap Year!!!)
\n18. (40:01) Borders to enhance Report
\n19. (42:48) Calculations for Amortization Table with Relative and Absolute Cell References
\n20. (47:10) Invoice Template
\n21. (47:24) VLOOKUP Function
\n22. (52:40) Data Validation, List to add Drop-Down List to Cell
\n23. (54:32) IF Function
\n24. (54:32) ISBLANK Function
\n25. (24:46) ROUND Function (link back to earlier part of video)
\n26. (01:02:35) FV of Investment Template
\n27. (01:02:35) Mixed Cell References
\n28. (01:05:50) F4 Key to cycle through 4 different types of Cell References (Merry Go Round)
\n29. (01:08:05) FV Function
\n30. (01:11:00) SUMIFS and COUNTIFS to create Summary Reports. Also: Advantage of Formulas Over PivotTable.
\n31. (01:18:38) Check Book Register Example
\n32. (01:19:02) Border Formatting
\n33. (01:20) Formula with Relative Cell References to calculate Balance
\n34. (01:21:29) IF Function
\n35. (01:21:29) ISNUMBER Function
\n36. (01:23:44) 1) Data Validation For Reconciling Column. 2) Conditional Formatting for whole row using Mixed Cell References
\n37. (01:29:50) Flash Fill to extract and clean Data Quickly<\/p>\n
Learn Excel Basics, Learn how to build Accounting Templates, Learn Excel Tricks for your Accounting Job.<\/p>\n