Functions

Functions are the core of Excel's capabilites to do complex calculations. This part of Excel-King will cover things like different functions (logical, mathematical, date and time functions etc.) as well as which function to use in which circumstance.

How does your Excel look like?

Print
PDF

Written by inservo | 16 February 2010

Hi everyone! Todays post is focussing on the adjustments you have made to your favourite spreadsheet tool which I assume is MS Excel.

Read more... Add new comment

Always in the middle

Print
PDF

Written by inservo | 08 December 2009

In addition to Saturdays post about the LEFT and RIGHT function, I just want to give you an update on the missing stepbrother of this nice little family: The MID function.

Read more... Add new comment

Welcome Thailand

Print
PDF

Written by inservo | 06 December 2009

Today I just want to show you a very funny and for my work totally useless MSXL function. It is called =BAHTTEXT and it translates a given numeric value into the thai word including the font.

Read more... Add new comment

Left, Right, Left

Print
PDF

Written by inservo | 05 December 2009

Today I would like to cover a functionality which is very handy for several purposes. With this function it is possible to extract a certain part of information from a value in a cell. The function is called LEFT.

Read more... Add new comment

The three IFs

Print
PDF

Written by inservo | 01 December 2009

Hi there, finally I found the time to update this blog with some new tips and tricks for MSXL. Sorry for being not online such a long time, as I had some family things to arrange. Todays post will focus on some functions that are used very often to count, sum and average values under given conditions.

Read more... Comments (3)

More Articles...

Tweet, Tweet...

Click the little blue friend to follow Phil on Twitter!

Advertisement

Create Excel dashboards quickly with Plug-N-Play reports.

Popular in the Forums

1. Exceed Excel 2003 limitations - discussion (2075 Views)
2. Conditional styles - discussion (1652 Views)
3. Nudge charts w/ arrow keys - discussion (1190 Views)
4. 3 immediate tips for your chart - discussion (822 Views)
5. Forming your spreadsheet - discussion (798 Views)