Case1: How many Days/Hours/Minutes it will take to travel 56,986 miles if a vehicle is traveling at constant speed of 12.5 miles per hour? Additional Information: During the travel time vehicle stops for 5 times with 18 hours as break each time Also consider the Overhead/Maintenance time of 100 hours for the one way trip […]
Articles Tagged: Productivity Tips
How to Get Live Data From A Web Page Direct Into Excel
Being able to perform a web query to retrieve text or data from a web page is a really useful feature in Excel. Web pages often contain really useful information that is perfect for further data analysis in Excel. Depending on what you need, you can retrieve data that is refreshable or alternatively you can […]
Excel VBA Tip: Remove Blank Lines From A Text File with Condition
If you’ve ever worked with text files, you’ll know how frustrating it can be to remove empty lines. Part of the problem is that you don’t want to remove every blank line otherwise it might upset the formatting of the document. This article will show you how to remove a set number of blank lines […]
How to Automate MS Excel Using Visual Studio.NET
Introduction I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word using C#, and here is […]
VBA Tip: Filter An Excel Table On Multiple Columns
Filtering information out of a larger data set is standard Excel functionality but sometimes it’s necessary to fine tune the filtering to get the information you need. For example, you might have a list of customers prioritized as A,B or C. Additionally, you could have them listed by region. Something like this. Customer, Category, Country […]
Corrupted Spreadsheets: How to Recover The Data?
On one hand MS Excel offers some advanced features. On the other hand, it may create some serious problems like file corruption. This problem becomes big if we do not take a corrective measures to handle the file corruption. There are several factors which are likely to be responsible for spreadsheet corruption: Virus infection and […]
Excel Tip : How to Generate Unique Usernames using the IF() and COUNTIF() Functions
Today let’s learn how to generate unique usernames in Excel, even when you have duplicates in your data. Formulas Used 1) IF( condition, [value_if_true], [value_if_false] ) Learn More about IF() Parameters or Arguments condition The value that you want to test. value_if_true Optional. It is the value that is returned if condition evaluates to TRUE. […]
10 Crazy Excel Tips & Tricks You Must Know!
10 Excel Tips and Tricks which are Incredibly Easy, Quick & Handy: Automatically SUM () with Alt + =: Did you know you could add an entire row or column by simply clicking the first empty cell? Click, press ALT + ‘=’ and simply add up the numbers in every above cell. Number Formatting Keyboard […]
9 Tips to Write Lookup Formulas More Effectively – Excel Tip
It is not breaking news, but something that anyone working on an Excel Report using formulas and functions, will know the keys of successfully using lookup formulas. They are vital for making almost any spreadsheet or dashboard. That is why when you learn how to extract information from Excel tables, you will be truly excited, […]
3 Ways To Enter An Excel Formula
Today let’s look at 3 different ways to enter formulas into your Excel workbooks. Do you use the same method over and over again?. you may find a quicker method… read on with me. Let’s look at an example where want to find the Total Costs which we want to display in Column F, which […]