Advertisements

Office

Excel Tutorial: INDEX MATCH primer

Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.

Advertisements

Recover MS Word and MS Excel password Easily

If you have lost your password for any MS Word or Excel document and are unable to recover it, try using this Free Word / Excel Password Recovery application. It’s a freeware product and all you need to do is install it, open the file that you need to recover. Choose the character set “a to z” and the expected lenght of your password and click GO.

Compress PowerPoint and Word files without zipping software

How many times have you struggled to send PowerPoint Presentations and Word documents to your friends / colleagues only to be overwhelmed by their sheer size! You can choose to zip or rar these files and send them across, but this would require the user there to have a program to unzip or unrar the files. PPTminimizer for Word and PowerPoint compresses PowerPoint presentations and Word documents without changing the file formats.