10 Tips to best prepare for your next Exam
In these tough times preparing for exams requires you be a soldier fighting at different battle stations simultaneously. With ever demanding exams and social pressure you need to do more than just cramming few hundred pages. This article is all about preparing exams at your best. Here are the 10 tips in few words. But […]
10 Signs that You Lack Confidence and How to Overcome them
Confidence in few words is a reasonable belief with unreasonable faith with predictable hope that can withstand unpredictable situations. Well I tried my best to define it my way. Being a teacher, employer, mentor, son, brother and a friend I have been asked confidence question confidentially a million times. Many define confidence as having high […]
Excel Camera tool - What, How and Why? - Snap up your spreadsheet skills
Very recently my passion for art is realized in the form of photography. I wanted it but I never knew that it will soon be an addiction and will have a name as well. And now I completely agree that when you are passionate about doing something you will always make time for it. And […]
Comparing two columns to highlight Duplicates in the same row - Excel Conditional Formatting
Back to Excel after a long time. But now starting to relax a little as course is concluded for many subjects I teach. I really missed my Excel community and I really want to thank each and everyone of them that they have not given up on me. Love you all! During my break from […]
Adding specific Prefix to All cells or Specific cells in Excel - 3 Methods Explained
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in vain. The reason was an excel file with over 25,000 contact numbers with or without area codes before actual contact number. […]
Formatting Numbers in Excel - Conditional Formatting Vs Custom Number Formatting
Accountants are always dealing with numbers. And its not always about highlighting positives. In some cases we have to make negative numbers standout and having a negative sign is just not enough. Similarly to show zero results as “Nill” or simply leave that field blank or being filled with a dash to replace boring “0” […]
30+ Copy & Paste Tricks You Must Know - Mouse Keyboard Autofill Paste Special and More!
Ctrl+C & Ctrl+V - The Saga continues! For sure Ctrl+C and Ctrl+V is one of the most famous keyboard shortcut in windows environment and one big reason for it become famous beyond limits is that it can be used in almost every Windows application software including Microsoft Excel. You might know how to do copy […]
Making Aging Analysis Reports Using Excel - How To
Aging analysis is helping accountants since ages and beyond doubt this is one the those reports that are prepared almost every period to track both receivables and payables. If you want to learn more about aging or ageing analysis do read my explanation: What is age, aged, ageing or aging analysis? If you are new to […]
Diploma in IFRS - Free Study Material Now Available
Free Resources for Diploma in International Financial Reporting Standards (DipIFR) Diploma in IFRS is offered by many institutes around the world. But the most sought after is the one offered by ACCA body. ACCA named this diploma as Diploma in International Financial Reporting (DipIFR). To aid best students and professionals preparing for DipIFR by ACCA, […]
9+ Ways to Fail Your Interview - Killer Mistakes You Must Avoid
Rejected once again? Then its time to sit down and think why you are not the one. Candidates often concentrate on putting more and more meat in their CV but forget about the bones. We looked at 9 killer interview mistakes that choke your chances to get hired! 1. Forgetting formidable formalities - resume, CV, cover […]
