Tutorials

Inserting Shapes and Pictures in an Excel Sheet

Often, there is a need to insert shapes and pictures in Excel to accompany values, for clarity. This article introduces you on how to insert them. Shapes and Pictures in Excel -Where are the ‘Pictures’ and ‘Shapes’ options present? The ‘Pictures’ and Shapes’ options can be found in the ‘Insert’ menu in the ‘Illustrations’ grouping. …

Inserting Shapes and Pictures in an Excel Sheet Read More »

Sparklines in Microsoft Excel- Line, Column and Win/Loss

What are Sparklines in Microsoft Excel? Sparklines in Microsoft Excel are small chart like figures that provide a summary of the data, visually, in a cell. Why Use Sparklines in Microsoft Excel? Sparklines can be used to show a recurring pattern in values like increasing or decreasing, periodic economic cycles or even simply to emphasize …

Sparklines in Microsoft Excel- Line, Column and Win/Loss Read More »

Borders for Cells in MS Excel – Bottom, Top, Left, Right, All and Outside

There are various options for setting borders for cells in MS Excel, some of which we will discuss here Bottom Border Top Border Left Border Right Border Top and Bottom Border All Borders Outside Borders Where to Find the Border Icon in MS Excel Ribbon? Go to the ‘Home’ menu. You can find the Border …

Borders for Cells in MS Excel – Bottom, Top, Left, Right, All and Outside Read More »