Protect Worksheet and Workbook in Excel

Access restriction is key to report generation to avoid unnecessary alteration to records. More so, it is very essential in excel to control access to either spreadsheet or workbook. Sometimes you may decide not to allow access to the entire workbook or protect users from edit any part of the worksheet. To protect either workbook[…]

Shares 0

Window splitting in Excel

Window splitting is very essential when there is need to compare or monitor parts of an excel worksheet that are far from each other but dependent. This tool will not just allow us to have view of two independent windows but can be scroll independently. Below is a table comprises all our revenue for the year[…]

Shares 0

Building Logical Formula under Conditional Formatting

This involve building rules to satisfy some condition using different criteria. In a table below I want to build a formula that will highlight the entire rows that have the same transactions date with the date supplied in cell A3. To do this is very simple. All you need to do is to follow the[…]

Shares 0

How to Create Bridge (Waterfall) Chart in Excel

This post was informed by an email received from a client who was asked to create a Bridge chart for a given data sets showing their company sales trends for the year 2015 by his boss. Bridge chart is a special type of column chart in excel that doesn’t have a built-in chart template but[…]

Shares 0

Conditional Formatting: Icon sets

Icon Sets enhance visualisation of  data with arrows, flags, check marks, shapes, and rating starts to mention few. It basically format cells based on their own values. Let’s applied icon sets on the data sets below. Highlight cells range B3:B10 Go to Home menu >> Conditional formatting >> Icon Set >> Choose from the options. But I will like[…]

Shares 0

Conditional Formatting: Color Scales

Color Scales enhance the visualisation of values in a range of cells. Let’s applied color scales on the data set below to see how effective it is. We can still follow the usual procedures to get it done. Highlight cells range B3:B10 Go to Home menu >> Conditional formatting >> Color Scale Choose any of the[…]

Shares 0

Conditional Formatting: Top / Bottom Rules

Under this we can highlight the cells that hold highest values or least ones, top percentages or bottom percentages, and above average or below average. Let’s applied Top/Bottom Rules on the given data set below. To highlight the TOP 3 values in the range. Highlight cells range B3:B10 Go to Home menu >> Conditional formatting[…]

Shares 0

How to Insert Gantt Chart in Microsoft Excel

Gantt chart remains one of the most useful ways of showing task (events or activities) displayed against time (period). It’s commonly use in project management, scheduling production process, employee rostering, and in IT to represent already collected data. On the top of the chart is the time scales while on the left is the list[…]

Shares 0