Tags » Excel

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

Problem

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

Excel

Índice De Precios De La Construcción

https://www.plantillasdeexcel.com/tienda/control-de-horas-en-hasta-200-obras/

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

Running

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

London

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

Programming