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…

What’s New in Excel 2010?

When a new version of Microsoft Office is released, sometimes Excel gets lots of new features. And sometimes it gets very few new features. In the case of Office 2010, Excel got very few new features. Here’s a quick summary of what’s new in Excel 2010, relative to Excel 2007:…