Jump to: 2018 2017 2016 2015 2014 2013 2012 2011

2018

• Macro to convert filtered list to multiple spreadsheet files
  May 15 2018 · a 7 min read · macro split-spreadsheet

• Code to Group Spreadsheet Walkthrough with Acute Kidney Injury
  May 3 2018 · a 14 min read · code-to-group hrg-grouper

• Before and After Comparisons with Pivot Tables
  Apr 10 2018 · a 5 min read · pivot

• GetPivotData Empty Strings and Data Fields
  Mar 5 2018 · a 4 min read · pivot tips getpivotdata

2017

• Import csv into SQL Server Using the Import Export Wizard
  Oct 27 2017 · a 4 min read · sql-server

• SQL and the 80/20 Rule
  Oct 24 2017 · a 16 min read · sql-server

• Working Day Formulas for Monthly Finance Timetables
  Apr 24 2017 · a 5 min read · function dates eomonth workday

• Annual Growth rates from Linear Trendlines
  Mar 10 2017 · a 6 min read · charts

2016

• Macro to wrap IFERROR() around formula in cell or range
  Sep 8 2016 · a 3 min read · macro tips iferror

• Using Custom Cell Styles
  Mar 20 2016 · a 5 min read · tips custom-formats styles

• Macro to convert filtered list to multiple pdf
  Jan 6 2016 · a 5 min read · macro

• How to amend a calculated field in a pivot table
  Jan 5 2016 · a 3 min read · pivot calculated-field

2015

• How to Break Resistant External Links in Excel
  Nov 24 2015 · a 4 min read · tips external-links

• Pasting Formulas without Changing Cell References
  Nov 10 2015 · a 3 min read · tips formulas

• Using Formulas to create a Dynamic Chart Title
  Sep 16 2015 · a 2 min read · charts

• Using Ramp-Up Profiles for QIPP Savings and Expenditure
  Apr 26 2015 · a 5 min read · charts

• Forecasting using Excel's Linear Trendline
  Mar 31 2015 · a 3 min read · charts trendline

• Converting T-SQL for MS Access SQL Queries
  Feb 4 2015 · a 3 min read · access sql-server access-sql

• The Double Bridge - An Excel Waterfall Template
  Jan 14 2015 · a 2 min read · charts bridge-diagram waterfall-chart

2014

• Importing CSV files to an SQL Server Database
  Jul 25 2014 · a 4 min read · sql-server

• Excel Pivot Table or Crosstab to Flat List
  Jan 28 2014 · a 7 min read · macro

• What to do with the Personal Macro Workbook
  Jan 25 2014 · a 13 min read · macro personal-macro-workbook personal-workbook

• Excel Waterfall Charts with Ease
  Jan 11 2014 · a 10 min read · charts bridge-diagram waterfall-chart

• Excel's Missing RANKIF Function
  Jan 2 2014 · a 4 min read · function countifs rankif sumproduct

2013

• Revealing Formulas in Hidden and Protected Cells
  Dec 12 2013 · a 3 min read · tips

• Excel Histogram Charts from a Pivot Table
  Apr 19 2013 · a 2 min read · pivot histogram patient-level-costing

2012

• Massive Excel Spreadsheets - How to Reduce the Size of Pivot Table Workbooks
  Dec 24 2012 · a 9 min read · pivot file-size

• Backwards Compatibility - Create Pivot Tables that Work in Excel 2003
  Apr 6 2012 · a 5 min read · pivot compatability-mode

• How to Use Excel VBA to Log-In to a Website
  Mar 21 2012 · a 4 min read · macro website-log-in

• NHS Ref - Code to Grouper and PbR Tariff on your iPhone
  Jan 29 2012 · a 4 min read · code-to-group iphone-app nhsref

• Refresh Multiple Pivot Tables - The Easy Way
  Jan 28 2012 · a 2 min read · macro pivot-table

2011

• Macro to Insert a "Last Update On:" Date Value
  Dec 19 2011 · a 1 min read · macro last-updated

• Sumproduct Function and Conditional Criteria
  Dec 7 2011 · a 3 min read · function sumproduct

• Macro to Consolidate Data Ranges from Multiple Excel Spreadsheets
  Dec 4 2011 · a 10 min read · macro consolidate multiple-workbook

• The SUMIF Function using Named Ranges
  Dec 2 2011 · a 3 min read · function named-range sumif

• Waterfall Charts that Cross the X-axis
  Nov 27 2011 · a 3 min read · charts waterfall-chart

• How to Test for an Integer Value in Excel
  Nov 24 2011 · a 2 min read · function is-function isinteger