Featured Image

All About “Developer Tab” in Excel

Hello Excel Developers, To know how to add Developer tab in Excel Ribbon, visit this article. Now let’s go through how to insert and work around basic Form Controls. We will be using “Form Controls” and not “ActiveX Controls” (Under Insert group in Developer Ribbon). The reason being Form Controls are very simple and easy to […]

Featured Image

How to add Developer tab in Excel Ribbon!!

Hello Excel Developers, I hope you must have activated the Developer tab in your copy of Excel by now. If yes, it will appear like below image.   If not yet, Follow this simple steps to activate “Developer Ribbon” How to add Developer tab into Excel 2007 Ribbon? Click the Office Button; Click the Excel Option […]

Case-Study-Recipe

Case Study 1 – Multi Choice Question-Answer Model in Excel

NOTE : There are many interlinked articles for separating basic lesson from this main article. View those links if you want to learn Basics. Hello Excel Modelers, Yes you heard it right. I am sure after going through this article thoroughly, you will gain a great insight on implementing various SIMPLE (simple if you know and […]

1year

One Year Completion of xlguru.in and smartcapractice.com

Hey my blog lovers, I just realised while renewing the domains that its been a 1 year since I planted the seeds of my passion of blogging. Its been a long and learning experience for me. And I wish with your blessing I will continue doing better in upcoming years as well. Stay connected.

Password

How to remove protection in workbook/worksheet!

Hello Excelhackers, Many a times you receive a protected file and you desperately want to un-protect it to view the hidden cells and formulas etc. This is very simple with the help of running below macro. password remover macro for EXCEL protected workbook Steps Opening VBA (ALT +F11) Paste the code at above link in Module 1. […]

Sniping Tool

Snipping Tool – A hidden Treasure in your Windows OS

Hello Presentation Givers, If you give a lot of support/demo to clients through screenshot then this is the best tool for you to start using “Snipping Tool” instead of old “PrntScr” button. Snipping Tool is a screenshooting utility included in Windows Vista and later. It can take screenshots of an open window, rectangular areas, a […]

Taskbar icon shortcuts

Open Taskbar icons with keyboard shortcut – Quick Tip

A Quick Tip for Accessing Taskbar icon with keyboard shortcut. Use combination of Windows key + 1,2,3……0 to open 10 icon in sequence from first icon. For example for below screenshot of my Taskbar, following keyboard will open corresponding icon/application.     + 1 Open MS Power Point 2 Open MS Excel 3 Open MS Word […]

All About "Named Ranges" in Excel

All About “Named Ranges” in Excel

Hello Super Excel Users, In this post I am going to cover every aspect of Named Ranges. What is a named range? Cells are generally named for a column and row that intersect, like A1 or C3. A range of cells is indicated by the colon between the beginning and ending cell of the range, […]

LinkedIn Connections

Export all LinkedIn connections with email ID

Hello Networking people out there, Have you ever aspired to write emails to all your LinkedIn connections but not through LinkedIn platform. Mails regarding spreading professional updates or your new startup or any relevant stuff to build audience. I have already written a blog to help you out send Effective Email Campaigns through mailchimp. You […]

Subscribe for Newsletter