# 9 handy Excel demos

• HERE YOUâLL FIND A COLLECTION OF NINE HANDY DEMONSTRATIONS ON HOW TO USE EXCEL BETTER. CLICK THROUGH ON EACH SLIDE TO LEARN MORE.
• Marcus Small CPA Australiaâs webinar presenter TheSmallMan.com â â Leveraging Excelâs time-saving, quality-enhancing, multipurpose functions will help generate real time business critical data. As such, mastery and knowledge of Excelâs inner workings will help distinguish you in your finance career.
• HOW TO MASTER MOVING AVERAGES IN EXCEL A formula to allow the user to specify how many months to average in a moving average calculation. FIND OUT MORE http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel http://intheblack.com/articles/2015/03/02/how-to-master-moving-averages-in-excel
• COMBINE ANNUAL AND MONTHLY DATA IN EXCEL WITH THESE SIMPLE STEPS Create a single chart that has both full year and monthly measures. READ MORE http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps http://intheblack.com/articles/2015/09/01/combine-annual-and-monthly-data-in-excel-with-these-simple-steps
• HOW TO USE TRIAL BALANCES TO STREAMLINE DATA IN EXCEL Suggestions for consolidating ledgers when an organisation has multiple entities with separate general ledgers. FIND OUT MORE http://intheblack.com/articles/2015/05/01/how-to-use-trial-balances-to-streamline-data-in-excel http://intheblack.com/articles/2015/05/01/how-to-use-trial-balances-to-streamline-data-in-excel http://intheblack.com/articles/2015/05/01/how-to-use-trial-balances-to-streamline-data-in-excel
• IDENTIFY AND REMOVE DUPLICATES IN EXCEL How to remove duplicates when your data is across several fields and is incomplete. FIND OUT MORE http://intheblack.com/articles/2015/04/01/identify-and-remove-duplicates-in-excel http://intheblack.com/articles/2015/04/01/identify-and-remove-duplicates-in-excel http://intheblack.com/articles/2015/04/01/identify-and-remove-duplicates-in-excel
• EASY STEPS TO MAKE DATA RELATIONSHIPS WORK IN EXCEL FIND OUT MORE Beyond VLOOKUP: Find out how you can easily report on multiple tables in Excel 2013. http://intheblack.com/articles/2015/10/01/easy-steps-to-make-data-relationships-work-in-excel http://intheblack.com/articles/2015/10/01/easy-steps-to-make-data-relationships-work-in-excel http://intheblack.com/articles/2015/10/01/easy-steps-to-make-data-relationships-work-in-excel
• SIMPLE TIPS TO USE FLEXIBLE BUDGET MODELS IN EXCEL READ MORE Ways to convert a single budget model into a multi- scenario budget model. http://intheblack.com/articles/2015/07/01/simple-tips-to-use-flexible-budget-models-in-excel http://intheblack.com/articles/2015/07/01/simple-tips-to-use-flexible-budget-models-in-excel http://intheblack.com/articles/2015/07/01/simple-tips-to-use-flexible-budget-models-in-excel
• HOW TO CREATE MACROS THAT TOGGLE IN EXCEL Discover the secret to using one macro to turn an option off and on. FIND OUT HOW http://intheblack.com/articles/2015/06/01/how-to-create-macros-that-toggle-in-excel http://intheblack.com/articles/2015/06/01/how-to-create-macros-that-toggle-in-excel http://intheblack.com/articles/2015/06/01/how-to-create-macros-that-toggle-in-excel http://intheblack.com/articles/2015/06/01/how-to-create-macros-that-toggle-in-excel http://intheblack.com/articles/2015/06/01/how-to-create-macros-that-toggle-in-excel http://intheblack.com/articles/2015/06/01/how-to-create-macros-that-toggle-in-excel
• HOW TO USE CONSISTENT STYLES IN EXCEL Easy ways to achieve consistent formats throughout a file. READ MORE http://intheblack.com/articles/2015/08/01/how-to-use-consistent-styles-in-excel http://intheblack.com/articles/2015/08/01/how-to-use-consistent-styles-in-excel http://intheblack.com/articles/2015/08/01/how-to-use-consistent-styles-in-excel
• USEFUL âHOW-TOâ VIDEOS â¢ Add substance with styles â¢ How to spot the doubles in excel â¢ How to custom format in excel WATCH NOW http://intheblack.com/topics/excel http://intheblack.com/topics/excel
• MORE RESOURCES FROM CPA AUSTRALIA: â¢ Microsoft Excel for finance professions â¢ Workshops â¢ Online â¢ Webinars FIND OUT MORE http://www.cpaaustralia.com.au/training-and-events/australia/microsoft-excel-and-business-intelligence http://www.cpaaustralia.com.au/training-and-events/australia/microsoft-excel-and-business-intelligence http://www.cpaaustralia.com.au/training-and-events/australia/microsoft-excel-and-business-intelligence
15
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Description
Text
• HERE YOUâLL FIND A COLLECTION OF NINE HANDY DEMONSTRATIONS ON HOW TO USE EXCEL BETTER. CLICK THROUGH ON EACH SLIDE TO LEARN MORE.
• Marcus Small CPA Australiaâs webinar presenter TheSmallMan.com â â Leveraging Excelâs time-saving, quality-enhancing, multipurpose functions will help generate real time business critical data. As such, mastery and knowledge of Excelâs inner workings will help distinguish you in your finance career.