-
3 Key reasons why you should know which version of Excel you are using
1. You can do Unique Count in Pivot Table if you have Excel 2013 and above 2. You can combined data from multiple worksheets in one from Excel 2016 3. You can do away VLOOKUP, MID, Text to Columns from Excel 2016 1. Unique Count in Pivot Table The pivot table used to be able to count the number of records in the data source. If the same name appears 10 times in the data source, Pivot Table will count the name 10 times. There are times when you wish to count only the 10 names once and display as one count. If this is the problem you are facing,…
-
You have 3 options
A General Manager of a reputable corporation came for my Hidden Secrets of Data Analysis in Excel Training. I asked him “What do you hope to learn from the course?” It is a standard feature in my training is to ask them what they hope to achieve in the training so that I can customize it as much as I can to help them. His reply was “My staff said the reports he wanted cannot be done in Excel. I am here to verify it. The outcome is “It can be done.” You may think that this general manager didn’t trust his staff. But I think that he had probably…
-
3 reasons why Excel is rejected for big data
-
3 reasons why I created an interactive map chart
-
Finding a Public Health Preparedness Clinic near you with an interactive map
The Public Health Preparedness Clinics (PHPCs), as well as polyclinics, will provide special subsidies for Singapore Citizens and Permanent Residents diagnosed with respiratory illnesses (e.g. common cold).Please bring along your NRIC or birth certificate, along with your PG/MG/PA and CHAS card, where applicable. To find one near your place, use the interactive chart given below. If you are using Mobile, Double tab to zoom in. Press and hold one of the green dot to show clinic name and contact details. If you are using Desktop, Use the mouse scroll wheel to zoom in. Mouse over one of the green dot to see more details. Full screen chart can be accessed thru this link. This map is…
-
What is Business Data?
-
How to identify duplicates instantly
How to identify duplicates instantly I was at this shop queuing to buy face masks. You have to show your ID to buy the face mask. Each customer is only allowed to purchase once due to limited stocks. Without checking through hundreds of records, how could you use Excel to check instantly? This is how I will do it.
-
Thank you Boss
For giving me a chance to show you that I can prepare a special chart for you in seconds You have sent me for upgrades and I have acquired new skills so that I can help you meet the new demands of your job. When your peers say bad things about me, you always stand up for me and tried to prove them wrong and you did it! I don’t have to work long hours because you know what I am capable of and made use of my capability If things get a little more complicated, you bite the bullet and pressed on. You discovered my new skills and I…
-
unfair treatment
Have you treated me fairly over the years? Whenever I give you the right report, you said that is expected of me. Whenever something goes wrong, you blame me. I am not to be blamed for the mistake. I am just following your instructions. Do you know that I am capable of many things? I bet you don’t know because you always asked me to do the same old thing. Do you know that I am capable of many things? Just because your peers told you otherwise and you believed them. Why do you make me work more than 8 hours a day, when you can take short cuts and…
-
3 tell-tale signs that your date is stored wrongly
1. You have one worksheet for one year of data. Your data for all the different years should be stored in one worksheet. If you break them into multiple worksheets, you are storing your data wrongly. What is the implication when you store them in multiple worksheets? You cannot analyze your data across different years and you will find them you are spending hours trying to comparing the seasonal patterns in a year. 2. Your header contains descriptions Jan, Feb, Mar … Dec Data should be stored vertically. The moment you store your data in this format, you will notice that your Pivot Table looks ugly and cumbersome. In fact,…