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 [ ... ]

How apply formula to entire column?

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

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.

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.

How to calculate ROI?

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

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 [ ... ]

Pie chart

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

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.

Waterfall chart

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

Check box

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

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.

Funnel Chart

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

Wind Rose

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

Functions 101

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

What is Excel?

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

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,  [ ... ]

TRIM function

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

FV function

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

Cut pieces of text in Excel

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

COUNTIF function

In this lesson you can learn about COUNTIF function.

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.

Pivot Chart

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

Group Box

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

Forecast function

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

Spin Button

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

Charts 101

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

MATCH function

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

How to calculate CAGR?

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

Logarithmic scale

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

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.

Sharing workbook

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

How to calculate variance in Excel?

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

Open and Close workbook with VBA

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

Freeze Panes and Split

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

PMT function

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

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.

Index Function

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

Two chart types in one chart

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

Pivot table

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

How to calculate the real interest rate?

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

NPER function

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

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 [ ... ]

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 [ ... ]

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.

Conditional formatting

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

Line Chart

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

OR function

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

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.

Gantt Chart

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

OFFSET function

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

PV function

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

How to protect Excel files?

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

HLOOKUP

In this lesson you will learn HLOOKUP function.

Database Functions

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

Updating values without using formulas

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

Getting started with Excel

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

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 [ ... ]

Array Formulas

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

Sparklines

In this lesson you can learn how to use Sparklines.

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.

Combo box

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

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.

SUMIF function

SUMIF function allows the aggregation of cells with specified criteria.

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.

Trendlines

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

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.

Sorting

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

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.

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.

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.

Edit multiple sheets at the same time

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

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.

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 [ ... ]

Assign macro to a button

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

Option Button

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

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.

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.

Recording macros

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

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.

Speedometer Chart

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

SUMPRODUCT function

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

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).

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.

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.

How to chage background color?

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

Calculating percent change

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

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.

Filling series

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

Counting Repeated Words in a Cell

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

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.

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  [ ... ]