Excel King is a blog focussed on delivering tips, tricks and workshops on all aspects of Microsofts premier spreadsheet solution. I want you to be excellent in Excel!

Welcome to Excel-King.com

Phil Kowalski image

I would like to thank you for visiting my blog. Here I want to show all the nitty-gritty little tips and tricks you can use to enhance your MS Excel knowledge. I would invite you to join my mailing list (see the box to the right) to always receive the newest information on Excel-King and what’s happening around Microsofts premier spreadsheet solution. Watch my welcome video to learn a little bit more about me and this blog

READ MORE...

Introduction to the VLOOKUP function

Today I want to give you an introduction into the mysterious VLOOKUP function of MSXL (woohooo, spooky!!). This is the first article in a series on posts on the lookup functions of MS Excel. Those come in very handy and are actually very powerful, as they give you possibilities which otherwise would have needed VBA.

READ MORE...

Being TRUE with VLOOKUP

Being TRUE with VLOOKUP As promised in Thursday's post on an introduction in the VLOOKUP function, we will today have a look on a change of the last parameter of the VLOOKUP function: The Range lookup. In the previous post we entered the value FALSE which told MSXL that we are searching for an exact match of the ID we used as identifier (read the introduction in the VLOOKUP function for further details).

READ MORE...

Checking more than one table with VLOOKUP

Checking more than one table with VLOOKUP This post concludes our mini-series on MS Excel's VLOOKUP funtionality. You can see the other two posts here:

Introduction to the VLOOKUP funtion and Being TRUE with VLOOKUP

Do you know that situation? You have more than one table as your target matrix to search in. A combination of some of MSXL's functions makes it very nice and easy to search in several tables.

READ MORE...

Home

Welcome to Excel-King

A warm and honest welcome to you, my dear visitors. Thank your for stopping by at www.excel-king.com. I am committed to serve you with tips, tricks, workshops and tutorials so you will get the most out of Microsoft's number one office product.

Tiger image I have been working with Excel for more than 10 years and it always happens that I am still surprised by the capabilities of this amazing piece of software. Any, hey, I am not talking about pretty advanced stuff like VBA programming, which exceeds all limitations Excel might have. There are so many complex (or easy depending on your point of view) calculation models, tools, charts, presentations (yes, presentations!) you can develop with this program, that I hope, you will be surprised as well.

This blog is organized in several categories which can be accessed by the main menu above or the content menu on the left.

If you like what you see here, I would be grateful, if you subscribe to our RSS syndication which delivers our newest post right onto your virtual doorstep. Also you can sign up for our newsletter, which will send you each new post directly into the inbox of your email program. As a little thank you for signing up to my newsletter (don't worry , I hate spam as much as you, so your contact details will be kept private) you will receive a copy of my ebook 14 days to dashboard mastery. This ebook incluides my series on creating a managment dashboard from scratch including some very valuable extras.

Again, let me thank you for visiting Excel-King.com and I hope you have a lot of fun here.

Yours,

Phil

Click the little blue friend to follow Phil on Twitter!

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

1. Exceed Excel 2003 limitations - discussion (2068 Views)
2. Conditional styles - discussion (1646 Views)
3. Nudge charts w/ arrow keys - discussion (1181 Views)
4. 3 immediate tips for your chart - discussion (816 Views)
5. Forming your spreadsheet - discussion (791 Views)

Excel King is a blog focussed on delivering tips, tricks and workshops on all aspects of Microsofts premier spreadsheet solution. I want you to be excellent in Excel!