Error #VALUE! in Excel

One of the common error Microsoft Excel error is VALUE!. This error occurs when your formula has the wrong type of argument (i.e., a mix of text and numeric fields). 20 more words


My Budgeting Habits

I’m quite new to budgeting. I know, crazy that I managed to avoid it for such a long time. For the longest time, I only kept in check my grocery budget which has been 50€ per week and that doesn’t include eating out which I do pretty rarely. 585 more words

Healthy Corner

Vlookup -- True or False?

Vlookup is one of the functions I use the most. It can locate data within a table and return a value. One of the most confusing things about the function is whether or not to include the True or False at the end. 146 more words


Eusprig 2019

If you are interested in Excel, and therefore spreadsheets you could do a lot worse then spend a day immersed in the risks and challenges associated with them. 175 more words


What you really need...

There is a (half-)joke that most companies could actually manage quite well using just two systems – PowerPoint and Excel. That might well be true and practical evidence of this is fairly abundant if you look around, however there is still a good and a bad way to do it: 25 more words

Systems & Solutions

Write multiple Excel files for each value of certain column Python Pandas

Consider the following dataframe:

data = {'Col_A': , 'Col_B': ['a', 'b', 'a', 'b']}
df = pd.DataFrame.from_dict(data)

I can create a dataframa a and write it to Excel as follows: 116 more words


Phone Call Cuts Hospital Readmissions

The title of this post is the same as that of an article on page 18 of today’s copy of The Times.

This is the first paragraph. 122 more words