Full Guide: The Logic Behind Hlookup Function Excel

Now now now! After the vertical finding of values let's try the horizontal one. Hlookup for Horizontal Look up meaning by column. This function is same logic with Vlookup function except for lining up of finding values. Vertical Finding - North to South Horizontal Finding - West to East NEWS The Formula of HLOOKUP =HLOOKUP(looup_value, …

Advertisement

Full Guide: The Logic Behind Vlookup Function Excel

Tired of looking up or finding a value within a set of range using MS Excel? Non-stop of pressing CTRL F (shorcut of searching tools) just to find your value? Why not try some other options? There are several options that can solve your problems. These are: The Vlookup, Hlookup, and the combination of Index …

SpeakToMe: A Speaking Excel – How to set up reminders from Anna (A.I.)

INTRODUCTION Hmmm forgot something? What is it now? Birthdays? I don't know.... How about events? Occasion? Meetings?....... Oh well I don't know, I am too busy person, if I have a secretary or assistant that reminds me when there are up coming events, birthdays, meetings, occasion, etc. etc. Do you have one? Nothing to worry …

SpeakToMe: Speaking Excel – A conversation with Anna using Input Box

INTRODUCTIONA conversation with Anna? Anna as Disney's Frozen? Well no. So who is Anna?Hmmm seems my question didn't correspond by who is Anna. Or maybe I asked What is Anna?Anna is not a human nor an animal, she is a program who was speaking in our last topic ( SpeakToMe: A Talking Excel or Talk to your …

SpeakToMe: A Speaking Excel

INTRODUCTIONComputer: "Good morning Boss!"User: "How's my system?"Computer: "Good sir! Nothing to report!, how about you, how was your sleep last night?"User: "Yeah, I'm good!, Is my breakfast ready?"Computer: "That's nonsense question sir, I don't even know how to cook. Cook for yourself!"User: "Yeah yeah, I'll cook you later"Talking to your computer? It sounds like crazy …

Talk to your Foolish Computer using Microsoft Excel

"Computer, speak to me. What's the weather condition?. Can I wander around?""Sir, are you blind? it's raining outside you should not go and wander around.""I am not blind, i just don't want look outside and don't say bad thing to me. It's getting on my nerves.""I see sir. you should have programmed me well so …

Handling Large Accounting Data Records in Microsoft Excel pt3

For this tutorial, I'm going to design a new format for our accounting records.We have the Purchase and Sales, reportDownload this fileLet's StartAs you can see there are two Data entry accounts. (Purchases and Sales).We're going to consolidate these two using the Data Entry Form, this will be a more complicated tutorial compared to my previous posts.But …

Handling Large Accounting Data Records in Microsoft Excel pt2

Now we have the Purchase Transaction in my previous postLet's move on to other transaction,  Sales TransactionWe buy, We sell our products for certain markupExample: For 1 kilo of Orange, 90 pesos is the cost per kilo, we have to gain about 20% of its cost. That is, 90 x .20 = 18 pesos is …

Handling Large Accounting Data Records in Microsoft Excel pt1

"If you're looking for a storage for your data, you can use Microsoft Access instead, but its seems to be more difficult to deal with compare to Microsoft Excel. (Small businesses). If you don't want to use Microsoft Access, here deal with user-friendly Microsoft Excel. "Accounting is part of our daily lives, even in your …

How to Make your Own Icon Image in Microsoft Windows

IconWhat is an Icon? Ask google :)Icon uses ".ico" file extension. See here for more infohttps://en.wikipedia.org/wiki/ICO_(file_format)If you want to create your icon, it's very easy. Firstly, Set your picture/s you want to create.Mine is the Tic Toe that i postedHereIf you don't have pictures, yet. You can use "screen shot" method using PrtSc (Print Screen) on …