Thanks to everyone who attended the session last week. Here are the responses to the questions. Q: Are Pie Charts Bad? A: No, they are not bad - but they have limited use cases. They don’t work with negatives. They are not recommended for more than 5 segments. They are not good for...
Here is the recording link. Recording link: https://cpaaustralia.webex.com/cpaaustralia/ldr.php?RCID=c966b8bfe97ecc0528138e2636457c65 Recording Password: ExcelWebinarSeries2025 I couldn't cover all the questions in the session - they are listed below. Q: How can you...
During the session there where quite a few general questions. This is Part 1. Question: can we add data range into the pivot? Yes. If you use a formatted table as your data source when you add data to the formatted table the data will appear in the Pivot when you refresh. I...
During the session there where a few layout-related questions. Question: Is there a way to always show the classic pivot presentation by default instead of having to change it via pivot table options/display/ each time a pivot table is created? Yes, in the File>Options>Data...
During the session there were a few similar questions. I have answered them below. Session recording The webinar recording link is: https://cpaaustralia.webex.com/cpaaustralia/ldr.php?RCID=156b302e0585fc4d8129c91d7c6e2d4f and password is: ExcelWebinarSeries2025 . Questions: ...
As I was reading the CPA Australia 2024 Annual Report I was interested in the presentation of charts (graphs). A lot of money had been spent on the presentation of the report. There were lots of high-quality photos and other images. I was disappointed with much of the data visualisation. As a...
1 Comment - no search term matches found in comments.
𝗖𝗼𝘀𝘁 𝗮𝗻𝗱 𝗕𝗲𝗻𝗲𝗳𝗶𝘁 𝗳𝗼𝗿 𝗜𝗻𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗢𝗿𝗴𝗮𝗻𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝗠𝗲𝗺𝗯𝗲𝗿𝘀𝗵𝗶𝗽 President Trump decided to withdraw from the WHO, and my first thought was to question why he made that decision. According to this article, wealthy countries contribute...
My latest article covers how to create a Timeline chart in Excel - link below. Time Line Chart in Excel If you aren't sure what a timeline charts looks like there is an example in the image below. The link above has a companion video, podcast plus the example file.
It's interesting to study as to whether GDP is an indicator for the Country's innovation and the richest people or not. GDP 2023 and 2022 is as follows ( https://lnkd.in/gFcQt9 k )): 1. USA (US$26.9 T in 2023 and US$25.4 T in 2022) 2. China (US$17.7 T in 2023 and US$17.9 T in 2022...
Contact the Community Manager | Terms of Use | Privacy Policy | Help / FAQs