access (1)

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

access-sql (1)

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

bridge-diagram (2)

• The Double Bridge - An Excel Waterfall Template
  Jan 14 2015 · a 2 min read
• Excel Waterfall Charts with Ease
  Jan 11 2014 · a 10 min read

calculated-field (1)

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

charts (7)

• Annual Growth rates from Linear Trendlines
  Mar 10 2017 · a 6 min read
• Using Formulas to create a Dynamic Chart Title
  Sep 16 2015 · a 2 min read
• Using Ramp-Up Profiles for QIPP Savings and Expenditure
  Apr 26 2015 · a 5 min read
• Forecasting using Excel's Linear Trendline
  Mar 31 2015 · a 3 min read
• The Double Bridge - An Excel Waterfall Template
  Jan 14 2015 · a 2 min read
• Excel Waterfall Charts with Ease
  Jan 11 2014 · a 10 min read
• Waterfall Charts that Cross the X-axis
  Nov 27 2011 · a 3 min read

code-to-group (2)

• Code to Group Spreadsheet Walkthrough with Acute Kidney Injury
  May 3 2018 · a 14 min read
• NHS Ref - Code to Grouper and PbR Tariff on your iPhone
  Jan 29 2012 · a 4 min read

compatability-mode (1)

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

consolidate (1)

• Macro to Consolidate Data Ranges from Multiple Excel Spreadsheets
  Dec 4 2011 · a 10 min read

countifs (1)

• Excel's Missing RANKIF Function
  Jan 2 2014 · a 4 min read

custom-formats (1)

• Using Custom Cell Styles
  Mar 20 2016 · a 5 min read

dates (1)

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

eomonth (1)

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

external-links (1)

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

file-size (1)

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

formulas (1)

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

function (5)

• Working Day Formulas for Monthly Finance Timetables
  Apr 24 2017 · a 5 min read
• Excel's Missing RANKIF Function
  Jan 2 2014 · a 4 min read
• Sumproduct Function and Conditional Criteria
  Dec 7 2011 · a 3 min read
• The SUMIF Function using Named Ranges
  Dec 2 2011 · a 3 min read
• How to Test for an Integer Value in Excel
  Nov 24 2011 · a 2 min read

getpivotdata (1)

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

histogram (1)

• Excel Histogram Charts from a Pivot Table
  Apr 19 2013 · a 2 min read

hrg-grouper (1)

• Code to Group Spreadsheet Walkthrough with Acute Kidney Injury
  May 3 2018 · a 14 min read

iferror (1)

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

iphone-app (1)

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

is-function (1)

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

isinteger (1)

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

last-updated (1)

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

macro (9)

• Macro to convert filtered list to multiple spreadsheet files
  May 15 2018 · a 7 min read
• Macro to wrap IFERROR() around formula in cell or range
  Sep 8 2016 · a 3 min read
• Macro to convert filtered list to multiple pdf
  Jan 6 2016 · a 5 min read
• Excel Pivot Table or Crosstab to Flat List
  Jan 28 2014 · a 7 min read
• What to do with the Personal Macro Workbook
  Jan 25 2014 · a 13 min read
• How to Use Excel VBA to Log-In to a Website
  Mar 21 2012 · a 4 min read
• Refresh Multiple Pivot Tables - The Easy Way
  Jan 28 2012 · a 2 min read
• Macro to Insert a "Last Update On:" Date Value
  Dec 19 2011 · a 1 min read
• Macro to Consolidate Data Ranges from Multiple Excel Spreadsheets
  Dec 4 2011 · a 10 min read

multiple-workbook (1)

• Macro to Consolidate Data Ranges from Multiple Excel Spreadsheets
  Dec 4 2011 · a 10 min read

named-range (1)

• The SUMIF Function using Named Ranges
  Dec 2 2011 · a 3 min read

nhsref (1)

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

patient-level-costing (1)

• Excel Histogram Charts from a Pivot Table
  Apr 19 2013 · a 2 min read

personal-macro-workbook (1)

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

personal-workbook (1)

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

pivot (6)

• Before and After Comparisons with Pivot Tables
  Apr 10 2018 · a 5 min read
• GetPivotData Empty Strings and Data Fields
  Mar 5 2018 · a 4 min read
• How to amend a calculated field in a pivot table
  Jan 5 2016 · a 3 min read
• Excel Histogram Charts from a Pivot Table
  Apr 19 2013 · a 2 min read
• Massive Excel Spreadsheets - How to Reduce the Size of Pivot Table Workbooks
  Dec 24 2012 · a 9 min read
• Backwards Compatibility - Create Pivot Tables that Work in Excel 2003
  Apr 6 2012 · a 5 min read

pivot-table (1)

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

rankif (1)

• Excel's Missing RANKIF Function
  Jan 2 2014 · a 4 min read

split-spreadsheet (1)

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

sql-server (4)

• Import csv into SQL Server Using the Import Export Wizard
  Oct 27 2017 · a 4 min read
• SQL and the 80/20 Rule
  Oct 24 2017 · a 16 min read
• Converting T-SQL for MS Access SQL Queries
  Feb 4 2015 · a 3 min read
• Importing CSV files to an SQL Server Database
  Jul 25 2014 · a 4 min read

styles (1)

• Using Custom Cell Styles
  Mar 20 2016 · a 5 min read

sumif (1)

• The SUMIF Function using Named Ranges
  Dec 2 2011 · a 3 min read

sumproduct (2)

• Excel's Missing RANKIF Function
  Jan 2 2014 · a 4 min read
• Sumproduct Function and Conditional Criteria
  Dec 7 2011 · a 3 min read

tips (6)

• GetPivotData Empty Strings and Data Fields
  Mar 5 2018 · a 4 min read
• Macro to wrap IFERROR() around formula in cell or range
  Sep 8 2016 · a 3 min read
• Using Custom Cell Styles
  Mar 20 2016 · a 5 min read
• How to Break Resistant External Links in Excel
  Nov 24 2015 · a 4 min read
• Pasting Formulas without Changing Cell References
  Nov 10 2015 · a 3 min read
• Revealing Formulas in Hidden and Protected Cells
  Dec 12 2013 · a 3 min read

trendline (1)

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

waterfall-chart (3)

• The Double Bridge - An Excel Waterfall Template
  Jan 14 2015 · a 2 min read
• Excel Waterfall Charts with Ease
  Jan 11 2014 · a 10 min read
• Waterfall Charts that Cross the X-axis
  Nov 27 2011 · a 3 min read

website-log-in (1)

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

workday (1)

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