Black And White Extended


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. You are purchasing version 3