-
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,…
-
3 skills you need to Excel in Reporting
1. Data source Not all the data comes nicely in an Excel worksheet. Some come in csv format, text or linked to some data sources. If you are lucky and there is IT support, you can get the IT guys to organize the data nicely for you. If not, there is a bit of moving around to get the data in the right layout. Splitting and grouping of the data is usually done within Excel and you probably have toknow some Excel formulas or functions to get this done efficiently. If not, goodluck to your copying and pasting. 2. Analysis Once you have gotten the data in the right format,…