Twitter | Search | |
Doctor Moxie
NHS Accountant and Excel whizz with a particular penchant for pivot tables - tutorials have a healthcare focus. Newbie programmer. R, Python, RPi
62
Tweets
220
Following
65
Followers
Tweets
Doctor Moxie Oct 27
I'm on a SQL Server roll - new pictorial showing how to easily import csv as SQL table.
Reply Retweet Like
Doctor Moxie Oct 24
Loads of fun cracking SQL code to support the Pareto Principle today. Here’s my tutorial.
Reply Retweet Like
Doctor Moxie May 15
First day and the staff induction team are coping admirably with the challenges from I'm very impressed.
Reply Retweet Like
Doctor Moxie Apr 24
Playing with the excel WORKDAY function to automate your annual finance timetables.
Reply Retweet Like
Doctor Moxie Apr 18
Reply Retweet Like
Doctor Moxie Apr 18
I have a new job on the horizon so I have updated my personal workbook macro post in readiness.
Reply Retweet Like
Doctor Moxie Mar 10
How to determine Annualised Growth rates from Linear Trendlines
Reply Retweet Like
Doctor Moxie retweeted
SaveKXPond Dec 3
Continuing destruction of King's Cross Pond, a place where banal building blocks were softened in surface reflections
Reply Retweet Like
Doctor Moxie 8 Sep 16
Macro to wrap IFERROR() around formula in cell or range
Reply Retweet Like
Doctor Moxie 20 Mar 16
Reply Retweet Like
Doctor Moxie 6 Jan 16
Macro to convert filtered list to multiple pdf documents.
Reply Retweet Like
Doctor Moxie 5 Jan 16
How to amend a calculated field in a pivot table
Reply Retweet Like
Doctor Moxie retweeted
Angela Wolff 5 Jan 16
Just discovered that the double tilde performs a ~~strikethrough~~ in I needed to scrub out one of my NY resolutions.
Reply Retweet Like
Doctor Moxie 13 Dec 15
Top 5 Excel Pivot Table Tips. Clear fields quickly, auto & manual grouping of data and…
Reply Retweet Like
Doctor Moxie 24 Nov 15
I spent quite a few hours today trying to locate and delete some very resistant and well hidden external links
Reply Retweet Like
Doctor Moxie 24 Nov 15
How to Break Resistant External Links in Excel
Reply Retweet Like
Doctor Moxie 10 Nov 15
Pasting Formulas without Changing Cell References - Exact formula copies.
Reply Retweet Like
Doctor Moxie 17 Sep 15
Using Formulas to create a Dynamic Chart Title in Excel. Includes a demo animation.
Reply Retweet Like
Doctor Moxie 16 Sep 15
Spitfires are such a beautiful planes. I feel nostalgic for kits again.
Reply Retweet Like
Doctor Moxie retweeted
Angela Wolff 1 Sep 15
Achieve the Impossible Fitness Tracking Dashboard - an Excel download to play with
Reply Retweet Like