Template

Black & White Reporting Extended Template by Mark Kubiszyn

A brief outline of this Project and what is in the purchased file

This Excel File contains two Sheets. Sheet1 is a single formatted Sheet in 5 Colours with a striped Background used for any "No fill" parts of the Sheet and an Arial Font of 10pt. The last Columns are Hidden and Gridlines/Headers are turned off. It contains an example of a Pivot Table with a custom 'Black & White Pivot Style', two Slicers with custom Styles, 'Black & White Slicer Style' and 'Black & White Borderless Slicer Style'. The Template also details thin horizontal and vertical lines including a cool 3D vertical line. A Combination Chart is included in a similar Style detailing Scheduled Deliveries against Forecast. Sheet2 is a Table containing the data used by the Pivot Table. The Template also features A Pivot Table Calculated Field used for the Variance calculation and a Conditional Format used to highlight anything in the 'Σ %' Field above the Target in Cell "H5". I use this Template as the basis for a number of reports at work and ususally add Code to create the Text at the top of the Report and a Logo of the Company that I work for. The result is a simple, stylish, bespoke reporting template that looks good to a Zoom level of 70%. The Spreadsheet can be used multiple times and amended to whatever you want for your reporting purposes. Once purchased you can request the Background stripe if you want it for any other Projects


 



Prerequisites

  • 32bit or 64bit Excel
  • Basic Excel skills
  • Windows PC · NOT a Mac!
  • No support is provided for customization of this Software

Features

  • A single formatted Sheet
  • 5 Colours
  • A thin Horizontal and Vertical 3D line
  • Pivot Table with a custom Pivot Table Style
  • A Pivot Table Calculated Field used for the Variance
  • A Pivot Table Conditional Format used to highlight anything in the 'Σ %' Field above the Target in Cell "H5"
  • Two Slicers with different Slicer Styles including a Borderless Slicer Style
  • A Combination Chart in a similar Style
  • An embedded Background Image used for any "No fill" areas of the Sheet

Support

Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support for my Software

  • Responding to questions or problems regarding the Software and its features
  • Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include

  • Customization and installation services
  • Support for third party software or ANY kind of development whatsoever

Before seeking support

  • Make sure your question is a valid Software Issue and not a customization request
  • Make sure you have read through the FAQ's, online documentation and any related video guides before asking support on how to accomplish a task
  • Ensure that you access to the VBOM is allowed and that Macros can run in Excel
  • Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
Remember to be patient, if there has been an issue with your download, Mark will always respond within 48 hours and will Email you the File directly if neccessary. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Changelog

You can find the version history below - the latest Version including a description of any changes made is always shown first:

16.04.2022 - (Version 1) Released

General release of the Black & White Extended Template