This blog post looks at how to group worksheets in Excel, and a couple of reasons why you would want to do that.

This awesome little technique can save tons of time and seriously improve your productivity.

Why would you want to group worksheets?

By grouping worksheets you can make the same change to multiple worksheets at the same time. This can be a formatting change, a structural change such as inserting a row, or even a formula.

Drop down lists can be created in Excel to assist with data entry and to prevent potential typos and misspellings. In this tutorial, you learn how to create multiple dependent drop down lists in Excel.

If you have lists with many entries, you may need to break the list into multiple dependent drop down lists. By creating a cascading set of lists, the entry in one is dependent upon the selection made in another.

I have started to learn German as it has always been a goal of mine to learn the language. So I started to list some vocab in Excel to test myself.

I am using an English keyboard and the German language contains 4 special characters that do not appear on an English keyboard. You have the 3 umlaut accented characters ä, ö, ü and the ß (esszet).

There are two main ways to enter these letters into Word or Excel. One way is to insert the symbol, and the other is to use the number code associated with each character.

In the latest version of Excel it has become your responsibility (if you choose to) to create your own toolbar, and in our basic Excel series we show you how.

The Quick Access Toolbar at the top of your screen begins with just the Save, Undo and Redo buttons. If you require fast access to any other Excel commands you are able to add them yourself. You can add almost any functionality to the toolbar including those not found on the Ribbon.

As part of our basic Excel series, this post explores 7 incredible additions to the toolbar that are sure to improve the way you work.