Tutorials

Find circular reference for dummies

What is all that noise about Circular Reference? Circular reference warning is received with raised eyebrows and terrified looks most of the time. But from our experience we know it to be all smoke and no fire, which we will prove to you right here. So what really is a circular reference? It simply means that your […]

20 Excel Keyboard shortcuts for Beginners

When starting with Microsoft Excel, knowing a few shortcuts will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are a few shortcuts to use when you just begin working with Microsoft Excel. These Excel Keyboard shortcuts for beginner works with […]

Excel VLOOKUP Function: Why and How?

Before we learn how to use Excel VLOOKUP function, we must learn WHEN do we use Excel VLOOKUP function? Task: Imagine if you have to find when does train no. 6948 departs in the schedule chart above? Your approach: You will scan the first column top to bottom. When you find the same train no., […]

Time Travel with PowerPoint tricks – Smart Art for Powerpoint

Powerpoint Tricks Time travel has been a core theme for many Hollywood science fiction flicks. Well, let me make it a reality for you. You can zoom past an hour in less than five minutes with these special powerpoint tricks. a) Convert boring bullet points in attractive SmartArt in 5 seconds – I borrowed some […]

PowerPoint Picture Tools to Create Magnifier Glass Effects

Learn a new PowerPoint trick using picture tools: Magnifier Case Study: Let’s say my company has launched a new water dispenser. I would like to highlight the new features of the product. To do so, I will like to use a magnifier like an effect to attract the viewers’ attention (Picture tools). This is a […]

Learn how to unprotect Excel or remove worksheet password

This is a Step-by-step blog on how to unprotect excel spreadsheet without using any software. This includes changing file extension and manipulating its constituents to get an unprotected excel file. Almost ALL Excel users wish at some point or the other felt the need of some magic to “Unprotect Excel Sheet” password so that they […]

How to Customize PowerPoint Slides Only in 15 Minutes?

Is your boss constantly nagging on your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tips that you wished you would know much before so that you would complete creating your presentation within […]

Learn how to use Countif function in Excel

Want to know how many records of a certain type you have in your Excel spreadsheet? Well, the Countif function is here to help. The Excel Countif function returns the number of cells within a supplied range, that satisfy a given criteria. When to use Countif? COUNTIF function can be used when you want to […]

Excel Versions: Evolution of Spreadsheets [Infographic]

Excel versions aka Spreadsheets have a come a long way over the years and plenty of companies today are attempting to build the best one. Spreadsheets have been used by accountants for hundreds of years. Computerised or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspapers and magazines […]

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? [This post on Excel tips and tricks is just a 5 min read] Well, there are high chances that you may have committed the […]

error: Content is protected !!