Tags » Excel

How to filter different types of files from a folder in Power BI


Recently I came across an interesting question about “How to filter different types of files from the same folder and combine them into a single table in Power BI?” 405 more words

Business Intelligence

#Excel: Generate a List of Antonyms Using an User-Defined Function (UDF)

It really is amazing what you can do with an Excel user-defined function (UDF). Here is a list (not comprehensive) of articles from my website that demonstrate clever and unusual uses of UDFs. 221 more words


Índice De Precios De La Construcción


Por naturaleza, los proyectos de construcción pueden ser difíciles de manejar.

Calendario 2017 Un simple calendario del año actual que puedes editar para agregar los feriados de tu país y que se marquen en colorado de forma automática en todos y cada mes. 512 more words

much ado about nothing

I’m no thespian … but even can’t resist a good Shakespeare pun!

Today’s post is all about how to find empty cells in your spreadsheet.  601 more words

A better Race Time Predictor!

I only run on average one marathon a year, but as I alluded to in a previous post (“my first time“), running the marathon distance was what helped me develop a running habit in the first place; and the way in which I continue to validate myself as a marathon runner. 1,489 more words


My 9 tips for ComicCon

It’s ComicCon time!

I am not the geekiest of geeks. I’ve never gone past page 30 of The Lord of The Rings, I haven’t explored the Star Wars universe outside of the movies, I haven’t finished watching Star Trek and I can’t name every Marvel or DC superhero. 1,099 more words


How to create a PDF file from an Excel Sheet (using C#)

The task is to create a PDF file from each sheet in each Excel file in a folder using C#. Here is one way to do it. 226 more words