Author Archives: admin
How to search through array in Visual Basic?
In my program I have an array that contains the results of the rolls of a die. The user input how many times they wanted it rolled. I need to search through that array to find how many times a … Continue reading
Posted in Learn Excel Macros
1 Comment
Before using Excel’s advanced filtering capabilities, what must you do first?
A) Define a criteria range B) Setup your relational operators C) Define a range for the filtered data? i think its c i am not sure what b means and theres stuff you can do before you do a
Posted in Learn Advanced Excel
1 Comment
I want to develop strong skills in computer programming, specifically within…?
- Excel VBA and Macros – Web Design Which programming languages do I need to learn, and what is the best way of going about learning these items in your opinion? Take classes? Read books? Online courses? I know it … Continue reading
Posted in How to Learn Excel?
5 Comments
best way to learn excel?
I found the best way to learn Excel or any software program, for that matter, is to purchase a textbook. The best ones I have found for Excel are the Shelley Cashman series. They explain everything and they have a … Continue reading
Posted in How to Learn Excel?
5 Comments
How to write a VBA/Excel stopwatch?
I need a stopwatch for a an excel userform I will be using. I need the stop watch to use the format "mm:ss" and start/reset with the same button. I am new to VBA, and do not know how to … Continue reading
Posted in Learn Excel Macros
1 Comment
How can I use VBA in Excel to look up words in the ‘Word’ dictionary/thesaurus?
I am experimenting with language parsing in Excel. I would like to use the dictionary and/or thesaurus in Word to look up definitions/synonyms for words that I have in my spreadsheet. I know that I can reference Word objects from … Continue reading
Posted in Learn Excel Macros
1 Comment
when do you use Vlookup and Hlookup ?
concise well explained answer please ! NEAR its not concise http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/
Posted in Learn Excel Formulas
1 Comment
How to create VLOOKUP formula in excel?
What is the most simple way to create a VLOOKUP formula in MS Excel? the best way is to type =vlookup in the cell (in excel) then it will guide to fill the informtion needed. or click on fx button … Continue reading
Posted in Learn Excel Formulas
4 Comments
What is the best book to buy for learning advance Excel functions like pivot tables, vlookups, macros, etc?
I need to learn these functions and more to become an inventory analyst. I wouldn’t say that there is one book that covers everything. The closest to that would likely be the Excel (version of Excel) Inside Out book series. … Continue reading
Posted in Learn Excel Formulas
2 Comments
Excel macro emploi du temps
Niveau débutant: Ce tutoriel explique comment créer une macro simple. D’autres vidéos sur agi67.fr. Duration : 0:3:12 Technorati Tags: débutant, emploi du temps, Macro
