Microsoft

OneDrive is an intrusive piece of app

Leo Notemboom explains how the OneDrive can be so invasive on your computer’s document files if you’re not too careful.

I might have enabled OneDrive backup by accident in the past. I just hope I didn’t lose files by accident as well because of Microsoft’s and OneDrive’s stupidity ineptitude.

How to do Lookup in Excel and Power Query

Lookup in regular Excel function

The XLOOKUP function has been available to Office 365 and Excel 2021. For compatibility purposes with my workbook’s potential users, I shy away from using this function. Instead, I use the combination of INDEX and MATCH.

Why not VLOOKUP?

I’m not sure if there are any hardware efficiency benefit from using INDEX and MATCH over VLOOKUP or HLOOKUP. But I use INDEX and MATCH primarily for two reasons:

  1. Ability to return the value of the column to the left of your lookup array (left-most column of the table array)
  2. Never worry about adding a column between the returned column and the lookup array. Remember, you indicate the column index number being the returned column from your table array? What if you’ve not touched your file for a long time, return to it and inserting a column in a table, forgetting that you’ve used that table as a table array as a lookup somewhere in your worksheet? You’ll certainly break your VLOOKUP formula.

How to use these formulas

Sorry, but you have to look somewhere else for the usage of these formulas.

Lookup in Power Query

Power Query Lookup Sample File

To better demonstrate the functions, it’s better if we refer to a sample file:

Microsoft is the new Apple

Microsoft recently introduced a bunch of computer and phone (yes, a phone) line up. They certainly stole the spotlight from Apple and Samsung at how these announcements are being done. I’m quite sure they are now the brand to beat in the months to come.

Internet Explorer is Bull; Switch Browsers Now

Now I’m joining to bandwagon of the haters of Internet Explorer. I’m starting to share the sentiments of those real web designers in their disgust over Microsoft’s web browser called the “Internet Explorer”.

Browse Happy logo

Various problems with internet explorer (IE) occured before, but it reached it peak as I was designing my tumblog here at Deuts.NET. Not to mention the javascript that won’t show up in IE6.

Blogging in Ubuntu

My Ubuntu Desktop
Screenshot of my desktop in Ubuntu. Click on image to enlarge.

I have always been considering switching to Linux, specifically Ubuntu. See my last post about it. You ask why, it’s the freedom from the various Windows restrictions and the furtherance of a free society. I actually found this link through Fr. Stephen Cuyos’ entry.

The Experience

I was yet trying out with the Live CD, and have not yet installed in my system. As such, I could not yet tell whether what they say that it’s faster to boot as compared to Windows is true. …

New Office Accounting Software

I have had small clients before that utilizes spreadsheets like mirosoft excel (or even worse, manual journals) to record accounting transactions, out of which they prepare financial reports.

Why not yet automated? There can be three possible reasons:

  1. Their transactions can be very simple and volume of transactions very low that it renders more efficient to use spreadsheets rather than use any simple software (like a GL system) available in the market, to process those transactions;
  2. They don’t have enough fund to invest in a fully licensed GL system; or
  3. A conservative accountant who’s not willing to adopt the latest technology.

Sad to note, though, that the last reason is often the case for these companies, or maybe a combination of any or all of the three, but that the third is oftentimes present.

For companies that cannot afford a system, especially for those that are on the start-up phase yet, Microsoft has the latest (announced just this week!) special offer:

Scroll to Top