Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,533 members, 7,958,637 topics. Date: Wednesday, 25 September 2024 at 07:17 PM |
Nairaland Forum / Science/Technology / Programming / In Need Of Someone Who Is Good With Excel (3539 Views)
I'm Not Good With Numbers But I Want To Learn Programming. Please Advise Me / Someone Good With Bootstrap And Html And Css Needed For Urgent Project / Need Help With Excel Function (2) (3) (4)
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 2:21pm On Jun 05, 2022 |
airsaylongcome: oh wow, I just learned this. let me quickly do that. wow thanks so much, sir. |
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 2:25pm On Jun 05, 2022 |
Emeskhalifa: Lol! Even the guys I linked up with the Data giveaway you did, neither of them know me! You go shock. Na here and one other platform na hin we dey "meet". I kind of like it that way. No real reason. I'm a bit active on the Programming section here so you go dey see my moniker well well |
Re: In Need Of Someone Who Is Good With Excel by BRATISLAVA: 2:26pm On Jun 05, 2022 |
airsaylongcome: |
Re: In Need Of Someone Who Is Good With Excel by Nostradamus1: 2:31pm On Jun 05, 2022 |
airsaylongcome: So na BUSRT ur head dey do . Kpele |
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 2:35pm On Jun 05, 2022 |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 3:22pm On Jun 05, 2022 |
airsaylongcome: Wow. Alright sir. I noticed that you frequent this section. Thank you so much for the help. Once I start my Program God's willing with HiiT, I'd still contact you for advice and solutions to any excel that is beyond me sir. Thank you so much for what you did for me so far. |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 4:46pm On Jun 05, 2022 |
Sir Airsaylongcome boss good evening sorry I don come again, pls don't get tired of me. Pls, how do I make the entire row in which a failed transaction appears to have its text color as red? I have attached an image below. these were done manually (I changed their color one at a time, it could be a whole lot of work if one is dealing with a huge record.
|
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 5:20pm On Jun 05, 2022 |
Emeskhalifa: About this, I'm almost certain that Agency Banking is here to stay. During the height of Corona Lock down, I was talking with a Ugandan friend living in Sierra Leone. He mentioned this Agency Banking stuff and how a lot of people are going into it there. At the time I was evaluating a Core Banking software and he had adapted the software to be able to do agency banking. He spent money to buy these POS machines and ATM card writer to test his changes. And when he did a demo for me it worked well. But me I was just a techie and did not see the value of what he was talking about. In fact to be frank, I did not think Nigerians would accept Agency Banking or that people would want to start up small businesses as Agency Banks. I was damned wrong. I don't think a future government will ban it. MTN is diving into this big time. In Nigeria, Finance is a big driver of Tech innovations so I expect it to be available for long. Whether it will be sustainable long term is a different matter because small businesses like yours will start competing by reducing their charges 3 Likes 1 Share |
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 5:23pm On Jun 05, 2022 |
Emeskhalifa: Let's link up on this around 8pm tonight. Right now I dey "lick" some bottles of stout so my brain don shift small But it's straightforward stuff. Something called conditional formatting. But we go link up. Make I finish my "licking" first 1 Like |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 5:43pm On Jun 05, 2022 |
airsaylongcome: It's safe to make a long term plan using the agency banking as source of livelihood/Means of survival then |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 5:43pm On Jun 05, 2022 |
airsaylongcome: Hahahahaha Alright boss thanks. |
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 8:59am On Jun 06, 2022 |
Emeskhalifa: So the method I've found just highlights the cells with Failed, not the entire row. Maybe someone reading this thread has an idea how to do that? |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 11:43am On Jun 06, 2022 |
airsaylongcome: Good morning boss. How do the highlighting pls? |
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 3:10pm On Jun 06, 2022 |
Emeskhalifa: https://www.ablebits.com/office-addins-blog/2014/06/10/excel-conditional-formatting-formulas/#formula-text-values If you still have issues let me know 1 Like 2 Shares |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 3:34pm On Jun 06, 2022 |
airsaylongcome: Good afternoon boss. Thanks so much for this. This will go a long way to broaden my knowledge of excel. Thank you sir. |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 12:04pm On Jun 07, 2022 |
Boss Airsaylongcome good morning sir. I just want to say thank you for all the help, the accuracy of this solution is 99%. Do you know that just yesterday when I applied it, I discovered three of my sales rep were stealing from the profit? one took 50% of the profit the other took 1k and another staff took 1k. I was speechless. it left me heartbroken, coz the one that took 50% happens to be someone I could swear with my life that she is 100% honest. she could not say anything this morning rather than cry and ask for forgiveness. 1 Like |
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 2:36pm On Jun 07, 2022 |
Emeskhalifa: 50% profit stolen! And that's gross profit o. You haven't removed selling expenses like staff salary and "rent" for the space you are operating from. Me I've always believed in computerising any business no matter the size. I had a a friend in University years back. He was a hot head like me. Hotter headed sef. Way back before data science became a trend he said to me: "Santos (that was my nickname back in the day) , the witchcraft is in the data. You go see other businesses dey accuse successful business say na witchcraft dem dey use. Whereas that successful business na sales data dem dey look to make forecasts and set targets" This was back in 2009. Man ran into trouble again at that Uni (he had previously had trouble at his first Uni for questioning a lecturers solution to a question). Managed to get his transcript just before school Disciplinary Committee suspended him for questioning Dean of Student Affairs. Got admitted into a UK uni and is now doing very well in the UK. The witchcraft is in the data. That stuck with me ever since. I'm happy you have been able to identify that your business is being attacked by your employees. Again if I was a consultant, I would advise you to set daily targets for each of your outlets. Anything over the targets, have an agreement to share the profit in some ratio with the staff. Note that your staff may have their own POS terminals at your outlets running it as their "side hustle". That's something you have to consider and have an antidote for. I have previously consulted for a bar/nightclub and business owner was shocked to find out that his staff were selling their own inventory of drinks inside his club! He was only able to find that out when I suggested that he should reconcile sales based on category of payments. All cash sales should be reconciled separately from all POS sales. 4 Likes |
Re: In Need Of Someone Who Is Good With Excel by JoyousFurnitire(m): 10:54pm On Jun 07, 2022 |
Emeskhalifa: Definitely, you fit even forget skill sef Meanwhile this thread >>> |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 1:31pm On Jun 08, 2022 |
airsaylongcome:Apologies for replying late boss. Have been busy offline. But wow, you just opened my eyes to something I never thought of. What if they have their separate termina for side hustle since now they can't easily take money from the business anymore I will consider placing them on target and come with a sharing formula once they go past the target |
Re: In Need Of Someone Who Is Good With Excel by Emeskhalifa(m): 7:33am On Jun 18, 2022 |
Boss Airsaylongcome good morning sir. It's been a while, how is everything sir I have been enjoying that your formula, there is no room to take even one Naira again except if the transaction wasn't carried on the POS I gave them which I do send people they don't know to make withdrawal randomly and bring back the pos receipt so I'd know which pos they are using. You won't believe it sir, one of my staff stopped working for some flimsy excuses. Later on, I discovered he stopped coz it became almost impossible to take money from the business since we implemented that formula. Honestly I'd remain indebted to you sir. I really appreciate it boss Meanwhile, I am humbly seeking your opinion on how to carryout this excel computation in the best way because the method I used seems like it will not allow me to carry out some calculations easily. Picture is below sir
|
Re: In Need Of Someone Who Is Good With Excel by airsaylongcome: 8:45pm On Jun 19, 2022 |
Emeskhalifa: What calculation are you trying to do? It's not very obvious from the spreadsheet |
Re: In Need Of Someone Who Is Good With Excel by Taeewo(m): 10:55pm On Jan 20, 2023 |
Emeskhalifa:This thread is so helpful... I have sent you a WhatsApp message boss... |
Beginning Microsoft C#.net / Creative Skills To Improve Your Essay Writing / Learn To Create Apps, Websites And Games With C#, Java And More
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 66 |