AUTOMATED DATA ENTRY FORM


​ Automated Data Entry Form Please see my major update in Automated Data Entry v2.0 (August 27, 2020) https://www.excel-crack.com/2020/08/automated-data-entry-v20.html   You can watch it here! What's new? (update 9/27/2017) Automated Data Entry Form by Excel-Crack v1.2 Major Update: Protect worksheet from manual editing while working. Minor Updates:Renaming or deleting your data sheet will help you … Continue reading AUTOMATED DATA ENTRY FORM

BETTER THAN VLOOKUP AND INDEXMATCH FUNCTION: MATCHME add-in


(Note: It is not advisable to use this for large amount of rows or data. Instead, use Vlookup or IndexMatch for larger data.) Introducing the upgrade version of Vlookup and IndexMatch Function when it comes to flexibility and looking up data using VBA Macros Add-In customized and defined. It is more likely intelligent and flexible … Continue reading BETTER THAN VLOOKUP AND INDEXMATCH FUNCTION: MATCHME add-in

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, … Continue reading Full Guide: The Logic Behind Hlookup Function Excel

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 … Continue reading Full Guide: The Logic Behind Vlookup Function Excel

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 … Continue reading SpeakToMe: A Speaking Excel – How to set up reminders from Anna (A.I.)

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 … Continue reading SpeakToMe: Speaking Excel – A conversation with Anna using Input Box

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 … Continue reading SpeakToMe: A Speaking Excel

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 … Continue reading Handling Large Accounting Data Records in Microsoft Excel pt3