BCG Matrix

In this tutorial you will learn how to create BCG Matrix in Excel. BCG Matix is a chart which show you potential of your company’s products. BCG stands for Boston Consulting Group – this company c [ ... ]

ChartsRead more
How to copy a table without borders from Excel to ...

In this lesson you can learn how to copy a table without borders from Excel to Word.

Tips & TricksRead more
Developer Tab

To use VBA in Excel you need Developer Tab in the Ribbon. In this tutorial you will learn how to enable developer tab in Excel.

VBARead more
Filling series

In this lesson you can learn how to fill data series.

Tips & TricksRead more
How to calculate ROI?

In this lesson you can learn how to calculate ROI in Excel.

Tips & TricksRead more
Pie chart

In this lesson you can learn how to insert pie chart.

ChartsRead more
Conditional Formatting for a row

You are going to learn, how to format whole row not only one cell. It can be useful for some reports or presentations.

Tips & TricksRead more
Waterfall chart

In this lesson you can learn how to insert Waterfall Chart.

ChartsRead more
Histogram

In this lesson you can learn what is and how to insert histogram chart. Histogram and Pareto Diagram are two types of charts connected with quality management that can be created in Excel. A histogra [ ... ]

ChartsRead more
Check box

In this lesson you will learn how to insert check box to the worksheet In Excel.

VBARead more
Cut pieces of text in Excel

In this tutorial I will describe the functions used to cut pieces of text - LEFT, RIGHT, and MID.

Tips & TricksRead more
Funnel Chart

In this lesson you will learn how to create funnel chart in Excel.

ChartsRead more
Wind Rose

In this lesson you will learn how to create Wind Rose chart in Excel’s spreadsheet.

ChartsRead more
Functions 101

In this lesson you can learn basic informations about functions in Excel.

BasicsRead more
MEDIAN function

In this article you will learn how to use median function. It can be used for calculating median of given numbers in Excel.

FunctionsRead more
COUNTIF function

In this lesson you can learn about COUNTIF function.

FunctionsRead more
How to calculate logarithms and inverse logarithms...

In this lesson I remind you what is logarithm. You will also get to know how to calculate logarithm, common logarithm, natural logarithm, inverse logarithm and inverse natural logarithm in Excel.

Tips & TricksRead more
FV function

In this lesson you can learn how to use FV (future value) function.

FunctionsRead more
What is Excel?

You can learn here, what the Excel is and why to use it.

BasicsRead more
Forecast function

In this lesson you can learn how to use forecast function and how to... predict future.

FunctionsRead more
TRIM function

In this lesson you can learn how to use TRIM function.

FunctionsRead more
Pivot Chart

In this lesson you can learn how to use a Pivot Chart.

ChartsRead more
Group Box

In this lesson you will learn how to create and configure frame in Excel.

VBARead more
Gauss Chart

In this lesson you can learn what is and how to insert gauss chart. The graph of the probability of normal distribution was named after the German mathematician and scientist Johann Gauss. It is he,  [ ... ]

ChartsRead more
Spin Button

In this lesson you will learn how to create and configure spin button in Excel.

VBARead more
Sorting a list of words by character count

In this lesson you will learn how to sort words in cells in Excel by character count, eg. from the shortest to the longest.

Tips & TricksRead more
MATCH function

MATCH function allows you to determine the position of the search item in the range of cells.

FunctionsRead more
How to calculate CAGR?

In this lesson you can learn how to calculate CAGR in Excel.

Tips & TricksRead more
Open and Close workbook with VBA

In this lesson you can learn how to open and close workbook using VBA code.

VBARead more
Charts 101

In this lesson you can learn basic information about chart in Excel.

BasicsRead more
PMT function

In this lesson you can learn how to calculate loan installment using PMT function in Excel.

FunctionsRead more
How to calculate variance in Excel?

In this lesson you will learn how to calculate variance in Excel.

Tips & TricksRead more
Logarithmic scale

In this lesson, you will learn what a logarithmic scale is, and how to use it with charts.

ChartsRead more
Freeze Panes and Split

In this lesson you can learn how to freeze panes and how to split spreadseet.

AdvancedRead more
Sharing workbook

In this lesson you can learn how to share workbook in Excel.

AdvancedRead more
Subtotals

In this lesson you will learn how to use Subtotals in Excel. It will help you dealing with data in Excel and creating reports.

AdvancedRead more
Index Function

In this lesson you can learn how to use INDEX function in Excel.

FunctionsRead more
Two chart types in one chart

In this lesson you can learn how to insert two chart types in one chart.

ChartsRead more
Header and Footer

In this lesson you can learn how to insert header and footer to your spreadsheet. You may need it when you are printing your spreadsheet.

AdvancedRead more
Pivot table

In this lesson you can learn how to use pivot tables in Excel.

AdvancedRead more
How to calculate the real interest rate?

In this lesson you will learn how to calculate the real interest rate.

Tips & TricksRead more
NPER function

In this lesson you can learn how to use NPER function in Excel.

FunctionsRead more
Pareto Chart

You will learn how to create a Pareto Chart in Excel. This is the example: Pareto diagram is an advanced type of chart in Excel. Consists of both a column chart and line chart. It presents a graphi [ ... ]

ChartsRead more
IF function

You can learn here what IF function is and how to use it. IF function is one which are used the most often in Excel. IF is a logical function. But you can not only check TRUE / FALSE values. Let [ ... ]

FunctionsRead more
Updating values without using formulas

I show you how to update value in cells without using formula.

Tips & TricksRead more
Conditional formatting

In this lesson you can learn how to use conditional formatting.

BasicsRead more
Gantt Chart

In this lesson you can learn how to create a Gantt chart.

ChartsRead more
OFFSET function

In this tutorial you will learn how to use the offset function.

FunctionsRead more
Define Name

In this lesson you will learn how to define name to cells and ranges. It will help you to use these name in your formulas.

AdvancedRead more
Excel FAQ

There are many common issues in Excel. Most people have the same difficulties. In this post I answer frequently asked questions, which you ask me. This post will develope. I hope it will help.

BasicsRead more
HLOOKUP

In this lesson you will learn HLOOKUP function.

FunctionsRead more
Line Chart

In this lesson you can learn how to insert line chart.

ChartsRead more
OR function

In this lesson you can learn how to use Excel's OR function.

FunctionsRead more
How to protect Excel files?

In this lesson you can learn how to protect Excel files.

AdvancedRead more
Array Formulas

In this lesson you can learn what are and how to use array formulas.

AdvancedRead more
PV function

In this lesson you can learn how to use PV (present value) function.

FunctionsRead more
Getting started with Excel

You can learn here some basics about Excel which helps you with your first steps.

BasicsRead more
Thermometer Chart

In this article you will learn how to create a chart which looks like a thermometer. This type of chart you will want to present data that show the percentage of a value (eg. the annual plan for the s [ ... ]

ChartsRead more
Database Functions

In this lesson you can learn about all database functions in Excel.

FunctionsRead more
Sparklines

In this lesson you can learn how to use Sparklines.

ChartsRead more
ADDRESS function

In this lesson you can learn how to use ADDRESS function. By using the ADDRESS function, you can get the address of the cell in the spreadsheet, giving a specific row and column number.

FunctionsRead more
Combo box

In this lesson you will learn how to insert combo box to your spreadsheet.

VBARead more
Exploding out slices of a Pie Chart

In this lesson you will learn few tricks in pie charting. You will know how to explode single slices out of a pie chart in Excel.

Tips & TricksRead more
SUMIF function

SUMIF function allows the aggregation of cells with specified criteria.

FunctionsRead more
How to hide the content of a cell in Excel?

In this article you will learn quick trick how to hide content of cell. This trick is really useful and easy. Even beginners can use this trick as well.

Tips & TricksRead more
Trendlines

In this lesson you can learn how to use trendlines in Excel.

ChartsRead more
How to compare columns to find duplicates?

In this lesson you will learn how to find duplicates in Excel. This is quick way to search bunch of data in just a second.

Tips & TricksRead more
Edit multiple sheets at the same time

In this lesson you can learn how to edit many worksheets at the same time.

Tips & TricksRead more
How to remove green triangles from cells?

In this lesson you will learn how to turn off green triangles which sometimes shows in the left corner of cell. It will make your spreadsheet more professional and save a lot of your time.

Tips & TricksRead more
Data Validation

In this lesson you can learn how to use Data Validation. If you share one sheet to use with lots of people, you might want to use this feature to validate data entry.

AdvancedRead more
Automatic age calculation

In this lesson you can learn how to calculate date difference between two dates. In an Excel spreadsheet, you can calculate the age based on date of birth.

Tips & TricksRead more
Option Button

In this lesson you will learn how to insert Option Button in Excel.

VBARead more
VLOOKUP

VLOOKUP is a function of Lookup & Reference. Use it to Excel is very easy to find and match to their data, which are located in two separate tables.

FunctionsRead more
Dynamic chart

In this lesson you will learn how to create dynamic chart in Excel. There are useful when you want to have charts which change when you change the scope of data.

ChartsRead more
Recording macros

In this lesson you can learn, how to record macros in Excel.

VBARead more
Sorting

In this lesson you will learn to sort data in Excel.

BasicsRead more
How to zoom in graph?

In this lesson you will learn how to zoom in your graph. It will help you improving visibility of values in your graph.

Tips & TricksRead more
Visual Basic Editor

On this page I present the Visual Basic Editor - an environment where you can edit recorded macros and write new macros and programs in Visual Basic for Applications. This is practically relevant wor [ ... ]

VBARead more
Assign macro to a button

In this lesson you can learn how to assign macro to a button (or other object).

VBARead more
Removing of unwanted rows

In this article you will learn how to easily remove of unwanted rows with just a few clicks. All easy and fun (without using macros or VBA).

Tips & TricksRead more
Speedometer Chart

In this lesson you can learn how to insert Speedometer Chart.

ChartsRead more
SUMPRODUCT function

In this lesson you can learn how to use SUMPRODUCT function in Excel.

FunctionsRead more
How to remove non printable characters in Excel?

In this lesson you can learn how to remove non printable characters in Excel with clean function.

Tips & TricksRead more
How to highlight every second row?

In this lesson you will learn how to highlight every second row. Excel will highlight cells automatically instead doing it manually.

Tips & TricksRead more
TODAY function

In this lesson you will learn how to use TODAY function. This function is really easy and is more powerful than you thought.

FunctionsRead more
AVERAGE function

In this lesson you can learn how to use Average function.

FunctionsRead more
Calculating percent change

In this lesson you will learn how to calculate change between two numbers.

Tips & TricksRead more
How to enable macros?

In this lesson you will learn how to enable macros in Excel 2010. This is useful trick because in Excel 2010 it is not so easy to find this option.

VBARead more
How to stop Excel from doing numbers E+?

In this lesson you will learn how to disable scientific notation (eg.1,23457E+17) in Excel spreadsheet.

Tips & TricksRead more
How to chage background color?

In this lesson you can learn how to chage a color of workbook in Excel.

Tips & TricksRead more
How apply formula to entire column?

In this article you will learn how to copy formula to every cell in column or row.

Tips & TricksRead more
Consolidation

Data consolidation in Excel can be useful when you want to combine data from different table, even from different Excel spreadsheets. In this post you will learn how to add together data from various  [ ... ]

AdvancedRead more
Text to Columns

In this lesson you can learn how to separate the text written in one cell. For this purpose one of the possibilities Excel is Text to Columns. This option is used to separate text, usually copied fro [ ... ]

AdvancedRead more
Counting Repeated Words in a Cell

In this lesson you can learn some trick - how to count repeated words.

Tips & TricksRead more