+1-2033499909
[email protected]

Tutorials

1 2 3 9

Tutorials

Sedial eiusmod tempor

Sedial eiusmod tempor

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Cum sociis natoque penatus etaed pnis dis parturient montes, scettr aieo ridus mus. Etiam portaem mleyo.

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Pharetra Malesuada Cursus Euismod
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Learn how to compare values in Excel

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines, misjudged trends, wrong decisions and lost revenues. While Excel formulas are always perfectly true, their results may be wrong because some flawed data penetrated into the system.

In this case, the only remedy is to check data for accuracy. It’s no big deal to compare two cells manually, but it’s next to impossible to spot the differences between hundreds and thousands of text strings. In this tutorial, we will learn how to compare values in Excel and find matches and differences between them.

Now, let’s go through the following steps to compare values of two cells.

Case Study 1: Case-sensitive formula to compare values in Excel.compare values in Excel Step 1

Imagine that sometimes it may be important for you not only to compare text in two cells but also to compare the character case. Case-sensitive text comparison can be done using the Excel EXACT function:

Step 1: Create a table same as like above picture. This table is showing the list of Two departments of an office. We will compare two cells between each row with case-sensitive formula. Column C will show the exact matching of each cell. If exact match found, then the result will be TRUE, if not then the result will be FALSE.

compare values in Excel Step 2Step 2: Now input this formula in cell C2 to compare cell A2 and B2:

=EXACT(A2, B2)

Now press ENTER.

compare values in Excel Step 3Now, cell C2 is showing False because John and Johm do not match exactly.

compare values in Excel Step 4Step 3: Copy the formula into another cell of column C. Now we will get above result like the picture. In here we can see only row 4 has the TRUE result. Means cell A4 and B4 contain the exact value Vijay, this is the reason we have got the result TRUE.

Tip 1: If you want to see Exact instead of TRUE as result and Not Exact instead of FALSE, you can use this formula instead of our previous formula and see the magic:

=IF(EXACT(A2 ,B2), “Exactly equal”, “Not equal”)

So, in this way, we can compare two cells value with Case-sensitive formula!

Case Study 2: Compare values in Excel by string length.

compare values in Excel Step 5Sometimes we want to check if the text strings in each row contain an equal number of characters.

How can we check text strings in each row contain an equal number of characters?

Easy, first, you get the string length of two cells using the LEN function and then compare the numbers.

Step 1: In our previous table use column D as length match. We will type the formula in each cell of column D for length comparison of each cell between particular row.

Supposing the strings to be compared are in cells A2 and B2, use the following formulas in cell D2:

=LEN(A2)=LEN(B2)

Now press ENTER and see the Magic.

compare values in Excel Step 6Step 2: Now we can see that the result is showing True for cell A2 and B2. A2 contain John and B2 contain Johm. In here both names contain 4 characters, for this, the result is showing TRUE. Now copy the formula into another cell of column D and see the result.

 

compare values in Excel Step 7Step 3: After using the formula in another cell we can see that 3 rows are showing the FALSE result in above picture. Because their length of characters is not same. Those rows are row 6, row 8 and row 9.

Tip 2: If you want to see Equal instead of TRUE as result and Not Equal instead of FALSE, you can use this formula instead of our previous formula and see the magic:

=IF(LEN(A2)=LEN(B2), “Equal”, “Not equal”)

So, now we have learned successfully learned two ways to compare two cells value! Enjoy Excel Tips

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

One day I received a call from one of my client companies (a prominent non-banking financial service,) which receive applications for loans and processes it for further action – approved & disbursed vs. rejected. Read along know what you can do with PowerPoint graphs.

powerpoint graphs ideas and innovative implementation

Learn how to use PowerPoint graphs based on real-life cases:

Situation: A senior level meeting had been called and they had to quickly assemble a PowerPoint deck. One of the hurdles were that some of the key performance factors, when put into graphs in presentation slides were not showing any meaningful information or trend.

Complication: The same chart type had been used in the last meeting and it was pointed by the Senior Management that it wasn’t satisfactory.

powerpoint graphs

Picture 1 : Simple bar PowerPoint graphs- which is boring

Question: How can we present 3 variables of one scale and 2 variables of another scale without cluttering the slide and losing the essence of the data?

Variable Set 1 – Logins (no. of accounts), No. of Files Approved & No. of Files Disbursed.

Variable Set 2 – Loan Approved (Value) & Loan Disbursed (Value).

Answer:  Finally, I used the combination of Thermometer Chart with line graph (markers only) on primary axis for Set 1. For set 2 I used simple line graph on the secondary axis. This is how it looked.

powerpoint graphs

Picture 2: The powerpoint graphs which I used

powerpoint graphs

picture 3: The smart and changed powerpoint graphs

Visual representation of data helps skate holders understand the problem and their solution better. Knowledge of tools like PowerPoint comes handy at times where the problem and its solution need visual explanations.

Summary: The bosses were delighted to see some fresh look. The trend was noticeable and clear. I was happier :). Powerpoint Graphs, when used right can work wonders for you and also for your boss.

You can learn all this and more from our newly launched “PowerPoint Graphs Ninja” online program. Click here to know more about benefits course.

NB – I wrote the post in SCQA format – Situation, Complication, Question, Answer. It’s one of the ways to draft a report.

 

Excel Security | How to lock cells in excel | Protect Sheet

Excel Security | How to lock cells in excel | Protect Sheet

Maintaining the integrity of an excel file that has to be shared with peers is a challenging job. Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy to crack. However, the latest versions have fortified the security and password features to protect your file from external attacks and alterations.
[…]

How to make original Good-looking Presentation slides

How to make original Good-looking Presentation slides

Guide to make original Good-looking Presentation slides

Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides. […]

Working with Excel VLOOKUP Formula

Working with Excel VLOOKUP Formula

Today, I have noticed every Professional working with Microsoft Excel using Vlookup formula. What I have experienced while interacting with my workshop participants is that they could tremendously magnify its application power if they learn two associated techniques of VLookup.

[…]

Excel Dashboard using What-if Analysis, Indirect Function & more

Excel Dashboard using What-if Analysis, Indirect Function & more

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. […]

Working with Excel INDEX Formula

Working with Excel INDEX Formula

Excel Index is probably one of the most favourite Excel formulae of many. In my previous post, I had mentioned about my favourite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer to be either VLOOKUP() formula or INDEX() or MATCH().

[…]

Create Magnifier Glass Effect in Powerpoint Picture

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerised by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides.
[…]

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts:

[…]

PowerPoint Tips on converting text to graphics using Smartart

PowerPoint Tips on converting text to graphics using Smartart

MS Word & PowerPoint Tips on how to convert a simple ordered or unordered List like converting text to graphics.

Microsoft Word & PowerPoint has built-in shapes and designs in SmartArt Tool which can be used directly; while preparing project report or presentation you may need to design some charts, lists, graphs, shapes etc. In order to meet the standard of good reports, use of ms word or powerpoint SmartArt is a must.

[…]

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

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

Find circular reference for dummies

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 formula includes a cell which is covered by the formula. […]

Sedial eiusmod tempor

Sedial eiusmod tempor

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Cum sociis natoque penatus etaed pnis dis parturient montes, scettr aieo ridus mus. Etiam portaem mleyo.

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Pharetra Malesuada Cursus Euismod
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Learn how to compare values in Excel

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines, misjudged trends, wrong decisions and lost revenues. While Excel formulas are always perfectly true, their results may be wrong because some flawed data penetrated into the system.

In this case, the only remedy is to check data for accuracy. It’s no big deal to compare two cells manually, but it’s next to impossible to spot the differences between hundreds and thousands of text strings. In this tutorial, we will learn how to compare values in Excel and find matches and differences between them.

Now, let’s go through the following steps to compare values of two cells.

Case Study 1: Case-sensitive formula to compare values in Excel.compare values in Excel Step 1

Imagine that sometimes it may be important for you not only to compare text in two cells but also to compare the character case. Case-sensitive text comparison can be done using the Excel EXACT function:

Step 1: Create a table same as like above picture. This table is showing the list of Two departments of an office. We will compare two cells between each row with case-sensitive formula. Column C will show the exact matching of each cell. If exact match found, then the result will be TRUE, if not then the result will be FALSE.

compare values in Excel Step 2Step 2: Now input this formula in cell C2 to compare cell A2 and B2:

=EXACT(A2, B2)

Now press ENTER.

compare values in Excel Step 3Now, cell C2 is showing False because John and Johm do not match exactly.

compare values in Excel Step 4Step 3: Copy the formula into another cell of column C. Now we will get above result like the picture. In here we can see only row 4 has the TRUE result. Means cell A4 and B4 contain the exact value Vijay, this is the reason we have got the result TRUE.

Tip 1: If you want to see Exact instead of TRUE as result and Not Exact instead of FALSE, you can use this formula instead of our previous formula and see the magic:

=IF(EXACT(A2 ,B2), “Exactly equal”, “Not equal”)

So, in this way, we can compare two cells value with Case-sensitive formula!

Case Study 2: Compare values in Excel by string length.

compare values in Excel Step 5Sometimes we want to check if the text strings in each row contain an equal number of characters.

How can we check text strings in each row contain an equal number of characters?

Easy, first, you get the string length of two cells using the LEN function and then compare the numbers.

Step 1: In our previous table use column D as length match. We will type the formula in each cell of column D for length comparison of each cell between particular row.

Supposing the strings to be compared are in cells A2 and B2, use the following formulas in cell D2:

=LEN(A2)=LEN(B2)

Now press ENTER and see the Magic.

compare values in Excel Step 6Step 2: Now we can see that the result is showing True for cell A2 and B2. A2 contain John and B2 contain Johm. In here both names contain 4 characters, for this, the result is showing TRUE. Now copy the formula into another cell of column D and see the result.

 

compare values in Excel Step 7Step 3: After using the formula in another cell we can see that 3 rows are showing the FALSE result in above picture. Because their length of characters is not same. Those rows are row 6, row 8 and row 9.

Tip 2: If you want to see Equal instead of TRUE as result and Not Equal instead of FALSE, you can use this formula instead of our previous formula and see the magic:

=IF(LEN(A2)=LEN(B2), “Equal”, “Not equal”)

So, now we have learned successfully learned two ways to compare two cells value! Enjoy Excel Tips

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

One day I received a call from one of my client companies (a prominent non-banking financial service,) which receive applications for loans and processes it for further action – approved & disbursed vs. rejected. Read along know what you can do with PowerPoint graphs.

powerpoint graphs ideas and innovative implementation

Learn how to use PowerPoint graphs based on real-life cases:

Situation: A senior level meeting had been called and they had to quickly assemble a PowerPoint deck. One of the hurdles were that some of the key performance factors, when put into graphs in presentation slides were not showing any meaningful information or trend.

Complication: The same chart type had been used in the last meeting and it was pointed by the Senior Management that it wasn’t satisfactory.

powerpoint graphs

Picture 1 : Simple bar PowerPoint graphs- which is boring

Question: How can we present 3 variables of one scale and 2 variables of another scale without cluttering the slide and losing the essence of the data?

Variable Set 1 – Logins (no. of accounts), No. of Files Approved & No. of Files Disbursed.

Variable Set 2 – Loan Approved (Value) & Loan Disbursed (Value).

Answer:  Finally, I used the combination of Thermometer Chart with line graph (markers only) on primary axis for Set 1. For set 2 I used simple line graph on the secondary axis. This is how it looked.

powerpoint graphs

Picture 2: The powerpoint graphs which I used

powerpoint graphs

picture 3: The smart and changed powerpoint graphs

Visual representation of data helps skate holders understand the problem and their solution better. Knowledge of tools like PowerPoint comes handy at times where the problem and its solution need visual explanations.

Summary: The bosses were delighted to see some fresh look. The trend was noticeable and clear. I was happier :). Powerpoint Graphs, when used right can work wonders for you and also for your boss.

You can learn all this and more from our newly launched “PowerPoint Graphs Ninja” online program. Click here to know more about benefits course.

NB – I wrote the post in SCQA format – Situation, Complication, Question, Answer. It’s one of the ways to draft a report.

 

Excel Security | How to lock cells in excel | Protect Sheet

Excel Security | How to lock cells in excel | Protect Sheet

Maintaining the integrity of an excel file that has to be shared with peers is a challenging job. Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy to crack. However, the latest versions have fortified the security and password features to protect your file from external attacks and alterations.
[…]

How to make original Good-looking Presentation slides

How to make original Good-looking Presentation slides

Guide to make original Good-looking Presentation slides

Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides. […]

Working with Excel VLOOKUP Formula

Working with Excel VLOOKUP Formula

Today, I have noticed every Professional working with Microsoft Excel using Vlookup formula. What I have experienced while interacting with my workshop participants is that they could tremendously magnify its application power if they learn two associated techniques of VLookup.

[…]

Excel Dashboard using What-if Analysis, Indirect Function & more

Excel Dashboard using What-if Analysis, Indirect Function & more

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. […]

Working with Excel INDEX Formula

Working with Excel INDEX Formula

Excel Index is probably one of the most favourite Excel formulae of many. In my previous post, I had mentioned about my favourite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer to be either VLOOKUP() formula or INDEX() or MATCH().

[…]

Create Magnifier Glass Effect in Powerpoint Picture

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerised by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides.
[…]

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts:

[…]

PowerPoint Tips on converting text to graphics using Smartart

PowerPoint Tips on converting text to graphics using Smartart

MS Word & PowerPoint Tips on how to convert a simple ordered or unordered List like converting text to graphics.

Microsoft Word & PowerPoint has built-in shapes and designs in SmartArt Tool which can be used directly; while preparing project report or presentation you may need to design some charts, lists, graphs, shapes etc. In order to meet the standard of good reports, use of ms word or powerpoint SmartArt is a must.

[…]

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

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

Find circular reference for dummies

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 formula includes a cell which is covered by the formula. […]

Sedial eiusmod tempor

Sedial eiusmod tempor

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Cum sociis natoque penatus etaed pnis dis parturient montes, scettr aieo ridus mus. Etiam portaem mleyo.

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Pharetra Malesuada Cursus Euismod
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean
Ipsum Portalion Elitesimo Aenean

Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Idque Caesaris facere voluntate liceret: sese habere. Magna pars studiorum, prodita quaerimus. Magna pars studiorum, prodita quaerimus. Fabio vel iudice vincam, sunt in culpa qui officia. Vivamus sagittis lacus vel augue laoreet rutrum faucibus.

Nihilne te nocturnum praesidium Palati, nihil urbis vigiliae. Non equidem invideo, miror magis posuere velit aliquet. Qui ipsorum lingua Celtae, nostra Galli appellantur. Prima luce, cum quibus mons aliud consensu ab eo. Petierunt uti sibi concilium totius Galliae in diem certam indicere.

Learn how to compare values in Excel

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines, misjudged trends, wrong decisions and lost revenues. While Excel formulas are always perfectly true, their results may be wrong because some flawed data penetrated into the system.

In this case, the only remedy is to check data for accuracy. It’s no big deal to compare two cells manually, but it’s next to impossible to spot the differences between hundreds and thousands of text strings. In this tutorial, we will learn how to compare values in Excel and find matches and differences between them.

Now, let’s go through the following steps to compare values of two cells.

Case Study 1: Case-sensitive formula to compare values in Excel.compare values in Excel Step 1

Imagine that sometimes it may be important for you not only to compare text in two cells but also to compare the character case. Case-sensitive text comparison can be done using the Excel EXACT function:

Step 1: Create a table same as like above picture. This table is showing the list of Two departments of an office. We will compare two cells between each row with case-sensitive formula. Column C will show the exact matching of each cell. If exact match found, then the result will be TRUE, if not then the result will be FALSE.

compare values in Excel Step 2Step 2: Now input this formula in cell C2 to compare cell A2 and B2:

=EXACT(A2, B2)

Now press ENTER.

compare values in Excel Step 3Now, cell C2 is showing False because John and Johm do not match exactly.

compare values in Excel Step 4Step 3: Copy the formula into another cell of column C. Now we will get above result like the picture. In here we can see only row 4 has the TRUE result. Means cell A4 and B4 contain the exact value Vijay, this is the reason we have got the result TRUE.

Tip 1: If you want to see Exact instead of TRUE as result and Not Exact instead of FALSE, you can use this formula instead of our previous formula and see the magic:

=IF(EXACT(A2 ,B2), “Exactly equal”, “Not equal”)

So, in this way, we can compare two cells value with Case-sensitive formula!

Case Study 2: Compare values in Excel by string length.

compare values in Excel Step 5Sometimes we want to check if the text strings in each row contain an equal number of characters.

How can we check text strings in each row contain an equal number of characters?

Easy, first, you get the string length of two cells using the LEN function and then compare the numbers.

Step 1: In our previous table use column D as length match. We will type the formula in each cell of column D for length comparison of each cell between particular row.

Supposing the strings to be compared are in cells A2 and B2, use the following formulas in cell D2:

=LEN(A2)=LEN(B2)

Now press ENTER and see the Magic.

compare values in Excel Step 6Step 2: Now we can see that the result is showing True for cell A2 and B2. A2 contain John and B2 contain Johm. In here both names contain 4 characters, for this, the result is showing TRUE. Now copy the formula into another cell of column D and see the result.

 

compare values in Excel Step 7Step 3: After using the formula in another cell we can see that 3 rows are showing the FALSE result in above picture. Because their length of characters is not same. Those rows are row 6, row 8 and row 9.

Tip 2: If you want to see Equal instead of TRUE as result and Not Equal instead of FALSE, you can use this formula instead of our previous formula and see the magic:

=IF(LEN(A2)=LEN(B2), “Equal”, “Not equal”)

So, now we have learned successfully learned two ways to compare two cells value! Enjoy Excel Tips

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

One day I received a call from one of my client companies (a prominent non-banking financial service,) which receive applications for loans and processes it for further action – approved & disbursed vs. rejected. Read along know what you can do with PowerPoint graphs.

powerpoint graphs ideas and innovative implementation

Learn how to use PowerPoint graphs based on real-life cases:

Situation: A senior level meeting had been called and they had to quickly assemble a PowerPoint deck. One of the hurdles were that some of the key performance factors, when put into graphs in presentation slides were not showing any meaningful information or trend.

Complication: The same chart type had been used in the last meeting and it was pointed by the Senior Management that it wasn’t satisfactory.

powerpoint graphs

Picture 1 : Simple bar PowerPoint graphs- which is boring

Question: How can we present 3 variables of one scale and 2 variables of another scale without cluttering the slide and losing the essence of the data?

Variable Set 1 – Logins (no. of accounts), No. of Files Approved & No. of Files Disbursed.

Variable Set 2 – Loan Approved (Value) & Loan Disbursed (Value).

Answer:  Finally, I used the combination of Thermometer Chart with line graph (markers only) on primary axis for Set 1. For set 2 I used simple line graph on the secondary axis. This is how it looked.

powerpoint graphs

Picture 2: The powerpoint graphs which I used

powerpoint graphs

picture 3: The smart and changed powerpoint graphs

Visual representation of data helps skate holders understand the problem and their solution better. Knowledge of tools like PowerPoint comes handy at times where the problem and its solution need visual explanations.

Summary: The bosses were delighted to see some fresh look. The trend was noticeable and clear. I was happier :). Powerpoint Graphs, when used right can work wonders for you and also for your boss.

You can learn all this and more from our newly launched “PowerPoint Graphs Ninja” online program. Click here to know more about benefits course.

NB – I wrote the post in SCQA format – Situation, Complication, Question, Answer. It’s one of the ways to draft a report.

 

Excel Security | How to lock cells in excel | Protect Sheet

Excel Security | How to lock cells in excel | Protect Sheet

Maintaining the integrity of an excel file that has to be shared with peers is a challenging job. Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy to crack. However, the latest versions have fortified the security and password features to protect your file from external attacks and alterations.
[…]

How to make original Good-looking Presentation slides

How to make original Good-looking Presentation slides

Guide to make original Good-looking Presentation slides

Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides. […]

Working with Excel VLOOKUP Formula

Working with Excel VLOOKUP Formula

Today, I have noticed every Professional working with Microsoft Excel using Vlookup formula. What I have experienced while interacting with my workshop participants is that they could tremendously magnify its application power if they learn two associated techniques of VLookup.

[…]

Excel Dashboard using What-if Analysis, Indirect Function & more

Excel Dashboard using What-if Analysis, Indirect Function & more

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. […]

Working with Excel INDEX Formula

Working with Excel INDEX Formula

Excel Index is probably one of the most favourite Excel formulae of many. In my previous post, I had mentioned about my favourite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer to be either VLOOKUP() formula or INDEX() or MATCH().

[…]

Create Magnifier Glass Effect in Powerpoint Picture

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerised by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides.
[…]

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts:

[…]

PowerPoint Tips on converting text to graphics using Smartart

PowerPoint Tips on converting text to graphics using Smartart

MS Word & PowerPoint Tips on how to convert a simple ordered or unordered List like converting text to graphics.

Microsoft Word & PowerPoint has built-in shapes and designs in SmartArt Tool which can be used directly; while preparing project report or presentation you may need to design some charts, lists, graphs, shapes etc. In order to meet the standard of good reports, use of ms word or powerpoint SmartArt is a must.

[…]

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

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

Find circular reference for dummies

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 formula includes a cell which is covered by the formula. […]

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.