Tutorials

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the […]

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

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

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