A simple trick that nobody knows is how to move columns in excel properly.
Welcome to Excelangel!
After 10 long years of struggling with Excel and becoming proficient with it I would like to share what I picked up.
Enjoy my collection of Excel articles.
If you have any request for a particular article or you struggling with something that you can’t solve get in touch by clicking on my photo on the left.
We can insert functional check boxes in excel. This will work as a simple on off check box for your projects.We also included a free check off list template you can download and use.
A simple but useful tutorial. Everything you wanted to know about how to unhide rows in excel.
Here is a quick post about a small but very useful feature in excel. The wrap text button, and how it is working.
In this post we will explain you how to enable excel macros.
There are a few options, we will explain you how to use them.
Pivot Tables are very powerful tools in excel, and want to be efficient with large datasets you must learn how to use them. We will explain in a multi part post on what we can do with them, and how to set them up.
A basic explanation for percentages in Excel and how to use them. We only using basic formulas, a simple human explanation to percentages.
A quick discussion for all of you preparing for an Excel interview.
We talk about Data models, BI, PowerBI, PowerQuery and so on.
Thomas Szigeti Another one of those issues that you come across when you are busy, and have to do things on the fly. When your manager sends you a...
A code to be able to save a range from your workbook as a .jpg picture.
This post will be for a solution that I had to develop to a database where I had to give the option to my end users to be able to delete a row with no hassle. Here I create a button, and if you press that button you can run a piece of code.
Preparing for an excel interview? Come and we will tell you the questions you can expect.
This is a short discussion on the Excel Paste Special command
This issue has such a simple solution you will not believe it!
If you need to convert time to decimal spend 2 minutes and learn this super cool trick.
Trim is a very handy formula to get rid of trailing spaces.
This post will show you how to find the square root in Excel VBA.
Is it possible to make a chart auto format itself?
We figured it out for you!
Make your named ranges expand and contract automatically. Set it once and forget about them. No adjustment needed.
This tutorial will show you how to use the substitute formula to replace part of texts
Thomas Szigeti The SEARCH formula in excel. Is a very handy tool when it comes to text operations. You can easily find text with it in a big data...
With the rand and randbetween formula you can randomize in excel like a pro.
Named ranges makes your life very easy in excel. They will save you a lot of time.
Weighted average is a must. It is a formula that you will be asked to do one in a while.
Use your hyperlinks in excel. You can set up bookmarks, links to files all sorts of impressive features
Something you will be asked to do all the time is to count between dates. We will show you how to do it easily!
Dates are strange things in excel. Check this post, we have it covered.
Changing the language on your Excel is easy!
Annoyed by the print preview lines?
Come we will show you how to get rid of them. Literally 30 sec.
You can make your own custom list for when you dragging a cell. You can have machine numbers etc… Come in we will show you how to set it up!
Here we discuss the rivalry between the two formulas. Come and have an opinion.
Delete rows with VBA?
There is a trick to it! Come and grab the ready made code from us.
Quick tip of the day. How to merge cells. Grab a coffee and learn it in 2 minutes with us!
Do you need to hide your zeros in your pivot table? Here is the solution. A custom format that you can copy and paste to your project.
One of the most used formula in excel. In this tutorial you can learn everything about it.
How to hide the errors for the presentation? Iferror formula to the rescue.
Learn it the right way with us!
Sometimes it is required to convert conditional formatting in to cell formatting. We have written the code for you. You can copy and paste the ready made code to your project.
In this tutorial you can learn how to use the isnumber formula in excel.
There is a lot of things you can use the match formula. In this post we will show you how handy it is to compare lists and so on.
Banded rows with conditional formatting. It is possible. Come and grab the formula from us.
How to clear the clipboard in VBA. Come and grab the code from us.
How to add autosave to your project in Excel VBA. Come and grab the ready made code.
In this post I will explain how to add any code to yook to run macros.
Build contextual drop down menus in excel. One is depending on what selected in the first one.
Excel is an art if you do it long enough.
You can literally build anything. Only your imagination is the limit. Come and experience this wonderful world with us.
Excel average is something you will use daily. Come and check out the tricks about it$
Remove accents in excel with this VBA code.
Come and grab the ready made code.
Call the windows open file dialog from excel VBA. Allow your users to pick the file your macro need.
Learn how to copy a formula in excel. It will come handy when you need to keep everything else.
Freeze panes in excel is a very handy feature. A lot of people not using it because it can be confusing. Come and learn in this tutorial whats the fuss all about
Easily find duplicates in excel. You can do it with a formula that is ready and waiting for you to be copied to your workbook!
Create dropdown lists in excel with ease. We will show you in this tutorial how easy it is.
Struggle to get multiple lines in oe cell? This tutorial show you an easy way to have just that! Grab a coffee and check it out!
This tutorial will show you how to use the countifs formula. With this you can have multiple criterias for what to count.
This post will show you how to use the countif formula for a single criteria.
In this post we will show you two formulas, that are related. Count and Counta. You can use them in many ways.
Named ranges are super handy in excel. In this tutorial you can learn all about them.
Locking formulas is essential in excel. If you confused come and check out our tutorial on this.
In this post we will teach you the daddy of formulas. The feared vlookup. Grab a coffee and learn with ease. Explained in human language.
How to transpose in excel. Before you start to copy and paste from horizontal to vertical read our post. You will thank us later.
What is the quick access toolbar, and how to use it to save tons of time?
This tutorial shows you the perfect setup for quick work.