Info Technology Files

Range : All 1 yr 6 months 30 days 1 week

2377 KB

Excel VBA & Macro

This is very useful for develop your excel knowledge...

Posted on 26 April 2013 (Downloads: 4055) Info Technology

92 KB

Tally 9 ERP - Shortcut Keys

Tally 9 ERP - Shortcut Keys...

Posted on 25 April 2013 (Downloads: 2990) Info Technology

2925 KB

CO-PA SAP

Costing Profitability via COPA Analysis SAP...

Posted on 19 April 2013 (Downloads: 1086) Info Technology

3937 KB

Excel Conditional Formatting

Excel Conditional Formatting ...

Posted on 12 April 2013 (Downloads: 1745) Info Technology

19 KB

Create Running Text in Excel

CREATE RUNNING TEXT IN EXCEL USING VBA CODE...

Posted on 08 April 2013 (Downloads: 3547) Info Technology

24 KB

Short Keys

Short Tally Keys...

Posted on 05 April 2013 (Downloads: 1440) Info Technology

310 KB

Incorporate licensing in your excel file

Incorporate licensing in your excel file

Now you can incorporate licensing in your excel file like we do....

Posted on 04 April 2013 (Downloads: 863) Info Technology

25 KB

Basic of SAP T-code

simple way to understand SAP T-codes. ...

Posted on 02 April 2013 (Downloads: 1752) Info Technology

97 KB

Remove duplicates & sort a list using Pivot Tables

today I want to show you a technique I have been using toÂ dynamically extract and sort all unique items from a last list of values using Pivot Tables & OFFSET formula....

Posted on 02 April 2013 (Downloads: 1372) Info Technology

25 KB

SAP T Code

simple way to understand SAP T CODE...

Posted on 02 April 2013 (Downloads: 375) Info Technology

233 KB

How to Look up Based on Multiple Conditions

Not always we want to lookup values based on one search parameter. For eg. Imagine you have data like below and you want to find how much sales Joseph made in January 2007 in North region for product â€œFast carâ€?...

Posted on 30 March 2013 (Downloads: 1449) Info Technology

45 KB

How to Lookup Values to Left?

There is no argument that VLOOKUP is a beautiful & useful formula. But it suffers from one nagging limitation.Â It cannot go left....

Posted on 30 March 2013 (Downloads: 1557) Info Technology

85 KB

Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week]

Sometimes we donâ€™t know what we want. If this happens when I am in a bar, I usually order a cocktail. Just a mix of everything. The same will work in Excel too....

Posted on 30 March 2013 (Downloads: 3352) Info Technology

67 KB

Tips on Rounding numbers using Excel Formulas

We can use a variety of formulas to round numbers in Excel depending on the situation.Â We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers ba...

Posted on 30 March 2013 (Downloads: 1540) Info Technology

132 KB

Excel Pivot Tables Tutorial : What is a Pivot Table and How

In this tutorial, we will learnÂ what is a pivot tableÂ andÂ how to make a pivot table using excel....

Posted on 26 March 2013 (Downloads: 3701) Info Technology

34 KB

Comprehensive List of Excel Keyboard Shortcuts

Few weeks back I have invited all of you toÂ share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks...

Posted on 25 March 2013 (Downloads: 2187) Info Technology

261 KB

Conditional Formatting in Excel - 5 Tips to make you a Rocks

Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and go...

Posted on 25 March 2013 (Downloads: 3755) Info Technology

40 KB

Excel Date function Practice

Excel...

Posted on 25 March 2013 (Downloads: 589) Info Technology

42 KB

Delete Blank Rows in Excel-Quick Tip

Blank rows or Blank cells is a problem we all inherit one time or another.Â This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel sprea...

Posted on 23 March 2013 (Downloads: 2344) Info Technology

49 KB

Extracting Unique, Duplicate and Missing Items using Formula

Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they h...

Posted on 23 March 2013 (Downloads: 1648) Info Technology