Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular cooking show, Chopped. The one where Chefs are given a mystery box of four ingredients to make a meal from. The four mystery ingredients we’ve been given are: MAX function FREQUENCY function Form Controls 3D …
In this post I'm going to look at how you can create an Azure Machine Learning experiment to predict diamond prices. Then set up the experiment as a web service, connect Excel to it, and use it to estimate the prices of diamonds. If I had to explain what machine learning meant, in this context, …
From time to time I get asked which Microsoft Office licence* should I get; Office 365 subscription, or the one-time payment for a perpetual licence i.e. perpetual licences are the ones you pay for once and own forever…or until you decide to upgrade. The answer is simple really; perpetual licences are dead. There I said …
Last week I wrote about getting real time data into Excel using PyXLL and Python code. I described a way to do this using HTTP connections. HTTP is the type of connection your browser uses to read web pages. In this article I'm looking at using sockets to get real time data into Excel. Sockets …
Updated April 2020 Excel does support getting real time data into the worksheet with the RTD function, but this requires programming a COM server with which the RTD function communicates. Power BI is able to make use of streaming data via API connections or PubNub, but what if I just want to pull some live …
On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the ALT key and then using the numeric keypad to type the ASCII or Unicode code for that character. For example, holding down ALT and then typing 184 on the numeric keypad, prints ©, the copyright …
There are hundreds of Excel keyboard shortcuts but we don't use them all frequently. There'll be some that you use more often than me, but in this post I'm listing the keyboard shortcuts I use all the time. It was hard to pick just a few, it was like being asked to pick your favourite …
Dates incorrectly entered or imported as text are a showstopper. We need our dates entered as date serial numbers to be able to leverage the Date Functions, use them in math and lookups, or even use them in PivotTables. So, often the first thing we need to do is fix Excel dates formatted as text. …
Even though dates and time are actually stored as a regular number known as the date serial number, we can make use of extensive Excel date and time formatting options to display them just the way we want. We can access some quick date and time formats from the Home tab > in the Number …
The objective of this post is to teach you how Excel handles date and time and provide you with all the tools you will need. It’s designed to be read in conjunction with the accompanying Excel file, which you can download below. Download the Files Enter your email address below to download the comprehensive Excel …
