Upwork

Build On Your Success At Upwork With Our New *FREE* Online Course

Upwork has already proven to be a rewarding marketplace for freelancers, and you too can start taking advantage of the marketplace and new opportunities with both new clients and ones you’ve worked with before on Elance. We’re committed to making the transition as easy as possible for our Elancers as we wind down the Elance […]

Share
Upwork

Introducing Upwork – the evolution of Elance and oDesk

Hello Freelancers, I hope you are aware about the new development in two major Freelacing Platform, Elance and odesk. The Elance have merged with odesk and have been launched as a single platform called “Upwork”. Below is the post to read this update from their Blog: Dear Elance Community, I’m thrilled to announce an important […]

Share

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 […]

Share

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 […]

Share

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 […]

Share

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.

Share

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. […]

Share
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 […]

Share
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 […]

Share

Subscribe for Newsletter