9 handy Excel demos

Data & Analytics

cpa-australia
  • Work faster, look professional, impress your boss and grow your career Work faster, look professional, impress your boss and grow your career with these Excel tips. EXCEL YOURSELF Looks who’s talking: When employees review employers A new breed of job websites lets employees tell it like it is. And that’s forcing talent-hungry employers to treattheir own staff more like customers. Read more. L e a d e r s h i p The one thing you can do to stretch your retirement savings We now expect our super to last 20 years or more. Doing this one thing can help stretch out the amount you have to live on in retirement. We now expect our super to last 20 years or more. Doing this one thing can help stretch out the amount you have to live on in retirement. Read more. s u p e r a n n u a T i o n What the 2015 federal budget means for your small business The Australian Government is promising a package of tax cuts, investment incentives, productivity enhancing measures and less red tape. But will this be enough to kick-start the economy? Read more. s m a L L b u s i n e s s “ “ it’s very easy to say the words “customer’s interests”. it is really hard to do it. really hard. david Thodey, Telstra Ceo Read More. Q u o T e o f T h e W e e k Advertisement Advertisement What will happen to australia when the mining boom ends? As Australia’s mining boom faces its decline, questions about price and output become increasingly difficult to ignore. Read more. e C o n o m i C s how great mentors get you outside your comfort zone “The perfect mentor relationship is adding some confusion, creating some disruption, and building an opportunity for someone to believe in themselves by challenging them,” says CPA Australia CEO Alex Malley. Read more. C a r e e r Working overseas? keep an eye on your taxes. Working overseas can lead to tricky tax pitfalls but seeking expert advice can keep you from paying up twice. Read more. T a x a T i o n unsubscribe You have received this email due to your membership, participation or interest in CPA Australia Ltd (CPA Australia) or its flagship publication, INTHEBLACK. Unsubscribe or modify your communication preferences. Copyright CPA Australia 2015. The contents of this newsletter is information only and is not offered as advice. Readers are encouraged to consult a suitably qualified professional adviser to obtain advice tailored to their particular circumstances. © CPA Australia Ltd. All rights reserved. ISSN 1832-0961. 4 may 2015 intheblack.com intheblack leadership . strategy . business Your essenTiaL business updaTe stricter rules ahead for collectibles in smsfs. If you hold artwork or other collectibles in your self-managed superfund, be aware of these new rules that will come into full force in 2016. Read more. s p o n s o r e d C o n T e n T is mYob essentials the right choice for your business? MYOB Essentials is designed specifically for sole traders and micro-businesses, so how does it stack up against Xero and others? Read more. T e C h n o L o g Y
  • 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.
  • CUSTOM FORMATTING MADE EASY How to display a numeric code with dashes between three sections and also be able to do calculations using code. READ MORE http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips
  • 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
  • INTHEBLACK.COM facebook.com/ ITBmagazine twitter.com/ ITBmagazine linkedin.com/ company/inthe black-magazine Newsletter intheblack.com/ newsletter https://www.facebook.com/ITBmagazine https://twitter.com/ITBmagazine https://www.linkedin.com/company/intheblack-magazine http://intheblack.com/newsletter
Please download to view
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
  • Work faster, look professional, impress your boss and grow your career Work faster, look professional, impress your boss and grow your career with these Excel tips. EXCEL YOURSELF Looks who’s talking: When employees review employers A new breed of job websites lets employees tell it like it is. And that’s forcing talent-hungry employers to treattheir own staff more like customers. Read more. L e a d e r s h i p The one thing you can do to stretch your retirement savings We now expect our super to last 20 years or more. Doing this one thing can help stretch out the amount you have to live on in retirement. We now expect our super to last 20 years or more. Doing this one thing can help stretch out the amount you have to live on in retirement. Read more. s u p e r a n n u a T i o n What the 2015 federal budget means for your small business The Australian Government is promising a package of tax cuts, investment incentives, productivity enhancing measures and less red tape. But will this be enough to kick-start the economy? Read more. s m a L L b u s i n e s s “ “ it’s very easy to say the words “customer’s interests”. it is really hard to do it. really hard. david Thodey, Telstra Ceo Read More. Q u o T e o f T h e W e e k Advertisement Advertisement What will happen to australia when the mining boom ends? As Australia’s mining boom faces its decline, questions about price and output become increasingly difficult to ignore. Read more. e C o n o m i C s how great mentors get you outside your comfort zone “The perfect mentor relationship is adding some confusion, creating some disruption, and building an opportunity for someone to believe in themselves by challenging them,” says CPA Australia CEO Alex Malley. Read more. C a r e e r Working overseas? keep an eye on your taxes. Working overseas can lead to tricky tax pitfalls but seeking expert advice can keep you from paying up twice. Read more. T a x a T i o n unsubscribe You have received this email due to your membership, participation or interest in CPA Australia Ltd (CPA Australia) or its flagship publication, INTHEBLACK. Unsubscribe or modify your communication preferences. Copyright CPA Australia 2015. The contents of this newsletter is information only and is not offered as advice. Readers are encouraged to consult a suitably qualified professional adviser to obtain advice tailored to their particular circumstances. © CPA Australia Ltd. All rights reserved. ISSN 1832-0961. 4 may 2015 intheblack.com intheblack leadership . strategy . business Your essenTiaL business updaTe stricter rules ahead for collectibles in smsfs. If you hold artwork or other collectibles in your self-managed superfund, be aware of these new rules that will come into full force in 2016. Read more. s p o n s o r e d C o n T e n T is mYob essentials the right choice for your business? MYOB Essentials is designed specifically for sole traders and micro-businesses, so how does it stack up against Xero and others? Read more. T e C h n o L o g Y
  • 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.
  • CUSTOM FORMATTING MADE EASY How to display a numeric code with dashes between three sections and also be able to do calculations using code. READ MORE http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips http://intheblack.com/articles/2015/02/02/custom-formatting-made-easy-with-these-simple-tips
  • 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
  • INTHEBLACK.COM facebook.com/ ITBmagazine twitter.com/ ITBmagazine linkedin.com/ company/inthe black-magazine Newsletter intheblack.com/ newsletter https://www.facebook.com/ITBmagazine https://twitter.com/ITBmagazine https://www.linkedin.com/company/intheblack-magazine http://intheblack.com/newsletter
Comments
Top