Knowledge base

All posts
What's new
Knowledge

1 min

Copying and pasting gives different text - Extracting transactions from encrypted bank statements

Select the text from your PDF bank statement, copy, then paste into notepad - if you see gibberish or different characters in notepad,...

2 min

Excel Top Tip #10 - Hide #N/A, #VALUE and #DIV/0, and more tips

Here is the email sent to all subscribers on 31 March 2021. To receive Excel top tips just like this, you can subscribe by clicking...

1 min

Lloyds TSB duplicate bank template - Extracting a PDF with a scanned image and searchable text

Lloyds TSB send out bank statements like this: Some of the text here is searchable, and some is an image, so the OCR engine skips the...

1 min

New complex international bank templates

A selection of bank templates from India and UAE have been added in the latest release of StatementReader - helping you to get more...

2 min

Excel Top Tip #9 - Level up in four new areas

Here is the email sent to all subscribers on 4 March 2021. To receive Excel top tips just like this, you can subscribe by clicking here....

1 min

New bank templates for extracting transactions to Excel

Here are the latest templates to be added to StatementReader for banks from UK, UAE, Switzerland, Hong Kong, India, USA, New Zealand:...

2 min

Excel Top Tip #8 - Improve Excel with Python

Here is the email sent to all subscribers on 28 January 2021. To receive Excel top tips just like this, you can subscribe by clicking...

1 min

Improving Excel with Python (Day 5 of 5)

My starter scripts in January 2021: Track changes in Excel My most hated feature of Excel is tracked changes. Tracked changes in Excel...

1 min

Improving Excel with Python (Day 4 of 5)

My starter scripts in January 2021: Set the file attributes for multiple Excel files Setting file attributes for multiple files in one...

1 min

Improving Excel with Python (Day 3 of 5)

My starter scripts in January 2021: List Excel file attributes in Excel File attributes of Excel files (the file properties accessible on...

1 min

Improving Excel with Python (Day 2 of 5)

My starter scripts in January 2021: Split Excel file into separate files As an extension on yesterday’s problem (combining multiple Excel...

1 min

Improving Excel with Python (Day 1 of 5)

My starter scripts in January 2021: Combine multiple Excel files from a folder I always advocate finding a problem early on when picking...

1 min

New: No Excel needed

We have now removed the need to have Excel installed on the user's machine; this improves the availability and stability of...

1 min

Land Registry Charts (Day 6 of 6)

My exploratory data analysis of Land Registry data in November 2020: The highest number of inter-country transfers over a 5-year period...

1 min

Land Registry Charts (Day 5 of 6)

My exploratory data analysis of Land Registry data in November 2020: Pairs of companies with the highest number of transfers over 5 years...

1 min

Land Registry Charts (Day 4 of 6)

My exploratory data analysis of Land Registry data in November 2020: Ownership history for St. Pauls House, Church Street, Canterbury -...

1 min

Land Registry Charts (Day 3 of 6)

My exploratory data analysis of Land Registry data in November 2020: Country preference for property ownership by region This graph forms...

1 min

Land Registry Charts (Day 2 of 6)

My exploratory data analysis of Land Registry data in November 2020: A snapshot of properties in England and Wales with overseas...

1 min

Land Registry Charts (Day 1 of 6)

My exploratory data analysis of Land Registry data in November 2020: Overseas companies that own property in England and Wales This...

2 min

Excel Top Tip #7 - Set up Excel just for you

Here is the email sent to all subscribers on 19 November 2020. To receive Excel top tips just like this, you can subscribe by clicking...

{"items":["6071b75ee1dd6100de4daad3","606358e44abd010015314d26","605da0a6420bb10015b9f589","6053221b2fc09e006ee3dafc","6041e8938959fc0015cd004f","601bbe15763f900017e7fb02","60191d381879eb00178b847b","600d4a577a96720017e773ad","600d49f895f70b001782ce4c","600d49c286b2aa0017f97dd9","600d49614570cd0017fc5017","600d478c04ef030017844262","601e635c4a51e40017b1bb75","5fc4c0fe06bac40017e4e4b8","5fc4c0bffbc68c001736f1b1","5fc4c084b982f60017b7ff5f","5fc4c03adbed950017fa7d48","5fc4bfdde92c180017257d91","5fc4be3c605a9d0017d5849f","5fb65bde265caf0017f4eb3d"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":true,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":940,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_12","value":"rgba(227,227,227,0.75)"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":940,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":0,"scrollBase":0,"height":null}}

2 3 4 5