Archive by Tag
A collection of site posts, listed by tag
access (1)
-
Converting T-SQL for MS Access SQL Queries
a 3 min read
access-sql (1)
-
Converting T-SQL for MS Access SQL Queries
a 3 min read
bridge-diagram (2)
-
The Double Bridge - An Excel Waterfall Template
a 2 min read -
Excel Waterfall Charts with Ease
a 10 min read
calculated-field (1)
-
How to amend a calculated field in a pivot table
a 3 min read
charts (7)
-
Annual Growth rates from Linear Trendlines
a 6 min read -
Using Formulas to create a Dynamic Chart Title
a 2 min read -
Using Ramp-Up Profiles for QIPP Savings and Expenditure
a 5 min read -
Forecasting using Excel's Linear Trendline
a 3 min read -
The Double Bridge - An Excel Waterfall Template
a 2 min read -
Excel Waterfall Charts with Ease
a 10 min read -
Waterfall Charts that Cross the X-axis
a 3 min read
code-to-group (2)
-
Code to Group Spreadsheet Walkthrough with Acute Kidney Injury
a 14 min read -
NHS Ref - Code to Grouper and PbR Tariff on your iPhone
a 4 min read
compatability-mode (1)
consolidate (1)
countifs (1)
-
Excel's Missing RANKIF Function
a 4 min read
custom-formats (1)
-
Using Custom Cell Styles
a 5 min read
dates (1)
-
Working Day Formulas for Monthly Finance Timetables
a 5 min read
eomonth (1)
-
Working Day Formulas for Monthly Finance Timetables
a 5 min read
external-links (1)
-
How to Break Resistant External Links in Excel
a 4 min read
file-size (1)
formulas (1)
-
Pasting Formulas without Changing Cell References
a 3 min read
function (5)
-
Working Day Formulas for Monthly Finance Timetables
a 5 min read -
Excel's Missing RANKIF Function
a 4 min read -
Sumproduct Function and Conditional Criteria
a 3 min read -
The SUMIF Function using Named Ranges
a 3 min read -
How to Test for an Integer Value in Excel
a 2 min read
getpivotdata (1)
-
GetPivotData Empty Strings and Data Fields
a 4 min read
histogram (1)
-
Excel Histogram Charts from a Pivot Table
a 2 min read
hrg-grouper (1)
iferror (1)
iphone-app (1)
is-function (1)
-
How to Test for an Integer Value in Excel
a 2 min read
isinteger (1)
-
How to Test for an Integer Value in Excel
a 2 min read
last-updated (1)
-
Macro to Insert a "Last Update On:" Date Value
a 1 min read
macro (9)
-
Macro to convert filtered list to multiple spreadsheet files
a 7 min read -
Macro to wrap IFERROR() around formula in cell or range
a 3 min read -
Macro to convert filtered list to multiple pdf
a 5 min read -
Excel Pivot Table or Crosstab to Flat List
a 7 min read -
What to do with the Personal Macro Workbook
a 13 min read -
How to Use Excel VBA to Log-In to a Website
a 4 min read -
Refresh Multiple Pivot Tables - The Easy Way
a 2 min read -
Macro to Insert a "Last Update On:" Date Value
a 1 min read -
Macro to Consolidate Data Ranges from Multiple Excel Spreadsheets
a 10 min read
multiple-workbook (1)
named-range (1)
-
The SUMIF Function using Named Ranges
a 3 min read
nhsref (1)
patient-level-costing (1)
-
Excel Histogram Charts from a Pivot Table
a 2 min read
personal-macro-workbook (1)
-
What to do with the Personal Macro Workbook
a 13 min read
personal-workbook (1)
-
What to do with the Personal Macro Workbook
a 13 min read
pivot (6)
-
Before and After Comparisons with Pivot Tables
a 5 min read -
GetPivotData Empty Strings and Data Fields
a 4 min read -
How to amend a calculated field in a pivot table
a 3 min read -
Excel Histogram Charts from a Pivot Table
a 2 min read -
Massive Excel Spreadsheets - How to Reduce the Size of Pivot Table Workbooks
a 9 min read -
Backwards Compatibility - Create Pivot Tables that Work in Excel 2003
a 5 min read
pivot-table (1)
-
Refresh Multiple Pivot Tables - The Easy Way
a 2 min read
rankif (1)
-
Excel's Missing RANKIF Function
a 4 min read
split-spreadsheet (1)
sql-server (4)
-
Import csv into SQL Server Using the Import Export Wizard
a 4 min read -
SQL and the 80/20 Rule
a 16 min read -
Converting T-SQL for MS Access SQL Queries
a 3 min read -
Importing CSV files to an SQL Server Database
a 4 min read
styles (1)
-
Using Custom Cell Styles
a 5 min read
sumif (1)
-
The SUMIF Function using Named Ranges
a 3 min read
sumproduct (2)
-
Excel's Missing RANKIF Function
a 4 min read -
Sumproduct Function and Conditional Criteria
a 3 min read
tips (6)
-
GetPivotData Empty Strings and Data Fields
a 4 min read -
Macro to wrap IFERROR() around formula in cell or range
a 3 min read -
Using Custom Cell Styles
a 5 min read -
How to Break Resistant External Links in Excel
a 4 min read -
Pasting Formulas without Changing Cell References
a 3 min read -
Revealing Formulas in Hidden and Protected Cells
a 3 min read
trendline (1)
-
Forecasting using Excel's Linear Trendline
a 3 min read
waterfall-chart (3)
-
The Double Bridge - An Excel Waterfall Template
a 2 min read -
Excel Waterfall Charts with Ease
a 10 min read -
Waterfall Charts that Cross the X-axis
a 3 min read
website-log-in (1)
-
How to Use Excel VBA to Log-In to a Website
a 4 min read
workday (1)
-
Working Day Formulas for Monthly Finance Timetables
a 5 min read