How To Use Excel

 cropped-locks-on-bridge.png

Make a better use of Microsoft Excel

Excel is a massive tool with many capabilities and techniques only few know about. Most people will not need to know most of the features and functions. And that is perfectly ok.

This page, however, focuses on the elements that you should know about. A collection of pragmatic tutorials that made my life with Excel better. I hope these tutorials be of use for you as well…

Yours,

The OfficeWizKid

 


 

Embedded Charts

Do-It-Yourself Inline Charts

Do-It-Yourself Inline Charts

Embed simple charts in Excel worksheets (Different from the standard floating charts).

Continue Reading »

Sparklines Inline Charts

Sparklines Inline Charts
Introduced in Excel 2010, Sparklines allow you to embed mini-charts inside worksheet cells.

Continue Reading »

 


 

Cell Formatting

Icon Sets

icon-sets
They say that a picture is worth a thousand. Learn how to show icon indicators to represent cell values. There are multiple icon sets for various scenarios.

Continue Reading »

Harvey Balls

harvey-balls-1
Spice your Worksheets with Harvey Balls (The black and white quadrant circles). Short tutorial on how to use conditional formatting and Icon Sets to draw Harvey Balls.

Continue Reading »

Conditional Formatting of Complete Rows

The tutorial starts by demonstrating a simple one-cell conditional formatting and extends this concept for formatting a complete row based on a value of one of its cells.
Continue Reading »

 


 

Clasic Functions

Basic COUNTIF

Let’s start with the basics of COUNIF. A description of what it is and a simple example why it is useful. Let’s assume we want to find the number (or count) of rows that include the work “Money”.

Continue Reading »

COUNTIF Complex Conditions

Excel COUNTIF is one of these functions that are simple enough to understand the concept but make you scratch your head when you try to do something less trivial with the condition part. Entry dedicated to condition examples.

Continue Reading »

VLookUp

VLookup is an Excel search function. Part of a family of search functions that includes Lookup, VLookup, HLookup and Match. Each one with a slightly different behavior. This tutorial shows a classic use case for the VLookUp function.

Continue Reading »

Trim

Learn how to use the Trim function to normalize your data by removing extrace spaces before or after values. In addition we will mention additional functions to remove spaces only at the front or only at the back of the value (LTrim and RTrim).

Continue Reading »

Basic PivotTable example

PivotTable is a query tool that quickly generates reports on top of a base table of data. Once you get the basics, it is easy, interactive and very useful tool to know. Let’s see very simple examples on how to use this tool.

Continue Reading »