Author Archives: powerpivotseth
A friend of mine was faced with this problem when preparing an offer to a customer, and asked me to save him from doing tedious manual entries for some 50 products. He had to make this from his own … Continue reading
1. Small investment The vast majority of businesses in the world already use Excel so the big investment has already occurred. a. Companies still using Office 2007 or older are nearing the time when an upgrade to a newer version … Continue reading
Creating reports can be a lot of fun, but there are some very important points to take into account.
There are lots of fancy data sources that Power Query can grab data from, like the Web, Databases, Excel and “Other Sources” but the day to day, bread and butter problem solver is most likely to be .csv since … Continue reading
Excel has been the dominant tool for analysis and reporting for a long time now, updates and improvements have been “software normal” until recently. However, in a rare “hop,skip and jump” Microsoft surprised us with some exciting changes. In Office … Continue reading
Never have so few =(1 person[me]) had so many =(4 musketeers[below links]) to thank for so much BIntelligence. (Paraphrased from the fat guy with the fat cigar) In order to expand your toolbox you need friends, including friends who might … Continue reading
Bakgrund Under många år har jag arbetat med att ladda in .txt-filer i Excel,omvandla text till siffror samt att bygga CONCATENATE, VLOOKUP, INDEX, MATCH och SUMIF formler. Detta är tidskrävande och inte på något vis foolproof, en missad eller felaktig … Continue reading