Delete All Worksheets Except Active One

Sometimes, you may want to delete all Worksheets except the active one, if the Workbook have many Worksheets, it seems very boring to do it manually. In these situations, you can use this simple macro. VBA Code Sub DeleteAllWorksheetsExceptActive() ‘Step 1: Declare your variables Dim ws As Worksheet ‘Step 2:…

Add and Name a New Worksheet with Specific Name

If you always add and name a new Worksheet with specific name in your Workbook, sometimes it seems very boring to do it manually. This simple macro can help you. VBA Code Add and Name a New Worksheet with Current Date Sub AddAndNameWithCurrentDate() ‘Step 1: Tell Excel what to do…

Nightingale Rose Diagram Excel Template

Nightingale Rose Diagram is the most famous statistical diagram. It’s a form of the Pie Chart now known as the Polar Area Diagram. We often see it in the Business Magazines, Newspapers and Journal of Finance. In this tutorials, I’ll show you two styles of Nightingale Rose Diagram Template use…

Customize the Quick Access Toolbar in Excel

The Quick Access Toolbar (QAT) is an area of the user interface that provides quick access to commands. You can make Excel easier to use by customizing the Quick Access Toolbar to include the Excel commands you use most often. By default, the Quick Access Toolbar is located at the top left of…

Excel 2010 User interface

Beginners to Excel are often intimidated by all the different elements that appear within Excel’s user interface. After you become familiar with the various parts, it all starts to make sense. Excel 2010 User interface Below figure shows a typical Excel 2010 user interface, with the important parts labeled. This…

What’s New in Excel 2013?

When a new version of Microsoft Office is released, sometimes Excel gets lots of new features and other times it gets very few new features. In the case of Office 2013, Excel got quite a few new features.Here’s a quick summary of what’s new in Excel 2013, relative to Excel…