0

## How to Make a Single Line Graph in Excel (A Short Way)

In this article, you'll learn how to make a single-line graph in Excel and some other tips related to Excel charting. Line charts are useful for showcasing ...

0

## How to Make Excel Tables Look Good (8 Effective Tips)

Editor's Note: "How to make Excel tables look good/professional?" - this is a general question by a new user of Excel. I asked Taryn to make a detailed article ...

0

## How to Modify Theme Color, Font, & Effects & Create Custom Excel Theme

Excel has themes, which have different default colors, auto shape effects, SmartArt effects, and fonts. When utilizing themes one can quickly change the look ...

0

## How to Count Frequency of Text in Excel (Using VBA)!

Have you ever wondered how to count the frequency of text in Excel, i.e the number of times a specific text appears in a range? We have already seen how to use ...

0

## How to Format a Pie Chart in Excel

A pie chart is used to showcase parts of a whole or proportions of a whole. There should be about five pieces in a pie chart if there are too many slices, then ...

0

## How to use INDEX & MATCH worksheet functions in Excel VBA

You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and applications ...

0

## The Different Ways of Counting in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, ...

0

## How to Use Form Controls in Excel

Introduction You can give your worksheets form-like functionality without ever having to use VBA. In order to achieve this, you will have to use form ...

0

## Calculate Depreciation in Excel (Straight Line, Double Declining…)

An asset is defined as a resource with an inherent economic value that is owned by an individual, corporation, or country which will yield future economic ...

0

## Nominal Interest Rate vs. Effective Interest Rate Excel Formulas

There are different types of interest rates and it is prudent for every investor or potential investor to know the differences between interest rates. The ...

0

## The FVSCHEDULE Excel Function

We have already seen how to use the FV (Future Value) function to calculate the future value of an investment with a constant or fixed interest rate, in a ...

0

## How to Use the Excel MIRR Function

We have already seen how to use the IRR (Internal Rate of Return) Function in a previous tutorial. The IRR Function is used to calculate the internal rate of ...

0

## XIRR vs IRR – How to Calculate IRR and XIRR in Excel

The IRR (Internal Rate of Return) function is used to calculate the internal rate of return for a series, of given periodic cash flows. These cash flows do not ...

0

## How to Create a Body Mass Index (BMI) Calculator in Excel Using VBA

The Body Mass Index (BMI) is used by nutritionists and other health scientists, in order to give an indication of the body fat of an individual. It is based on ...

0

## Calculating the Rate an Investment Achieves Using the RRI Function

We have already seen how to use the PV Function, the FV Function, and the PDURATION Function in a previous tutorial. We have also seen how to calculate NPV and ...

##### Browsing All Comments By: Taryn N
1. Hi Mike thanks for the comment :-). Yes definitely and see which one of the three you prefer using.

I am wondering now if there is some other variable that is related to whether one prefers using TAB, ENTER or CTRL-ENTER in Excel. I am right-handed so I am wondering if it (my preference) maybe is related to that, or something else entirely.

It would also be interesting to see the results of a poll of Excel users and which of the three turned out to be the most popular.

2. π Thank you so much π

3. Hi Agnius
Thank you for your comment. Point taken. However, these are topics tested in many Excel exams and there is often confusion since workbook level is actually protecting the worksheet structure, so it was in that context that the tutorial was made and made in order to address those issues.

This topic (worksheet level and workbook level protection) is covered in the detailed syllabus for the Microsoft Excel Expert Exam for 2013 that is exams (77-427 and 77-428), in the official book released by Microsoft Press – MOS 2013 Study Guide Microsoft Excel Expert by Mark Dodge.

So it is relevant to go over, for people who are studying for the MOS Excel Expert Exam and any other Excel exam. Also while I agree with you that encryption and VBA also play a role in more advanced level protection (I will do another tutorial on the more advanced level options :-)) .

My personal opinion is sometimes depending on one’s organization, one’s needs may not be that complex so its worthwhile knowing what Excel has available in terms of simpler options. It is one layer of protection and something is better than nothing at all, in my opinion. A workbook that has sensitive information that has no protection at all, is less secure than a workbook that has worksheet level and workbook level protection. Also from the psychological perspective there is now some form of inhibiting barrier, if one uses worksheet level or workbook level standard protection options.

However, you have opened up a very interesting debate with your points – is something in terms of protecting one’s data at a simpler level really better than nothing at all or should one address this issue from the VBA and encryption level only.

I will in the next tutorial, address some of the points you’ve raised and give you credit for the interesting questions/points you’ve posed in the debate section of the next tutorial on Encryption and VBA protection.

4. Hi Henk thanks for the comment, the reason I use CTRL-ENTER is because after pressing CTRL-ENTER one stays in the cell that contains the actual formula, whereas pressing ENTER takes you to one cell below the actual formula, TAB of course takes one to one cell right of the cell containing the formula. So its a preference on my part basically :-). It would actually be interesting to see what the preferences of general Excel users are – and if its related to anything else – maybe ambidextrous people for example, prefer for the most part using the TAB key. So yes one can use ENTER or TAB instead of CTRL-ENTER but I like staying in the cell that contains the actual formula.:-)

5. Thank you so much :-).

6. You are most welcome. I’m glad you found the tutorial useful and yes the database functions are very helpful when it comes to looking up data with criteria π

7. Thank you so much.

8. You are most welcome. We are intending to do a financial functions tutorial series so lookout for that π Best of luck with your studies as well π

9. You are very welcome. Thank you for reading and doing Excel with us π

10. I’ve updated the article with your suggestion just added the @ symbol, as well as commentator Rahul Singh’s. Thanks for the formula suggestion and please keep contributing. π

11. Thank you, I am going to update the article with your formula suggestion. I know the text formula is complicated – it was mainly for demonstration purposes of how LEN, RIGHT, LEFT and other text functions can work together to deliver results π

12. Thank you for your contribution. The modification of the formula, you suggested, would work for additional detailed routes that the hospital in question, may feel they need to add.

We can lead on from this and design an Excel Sheet with VBA using Nested IFS and a small picture of the routes, for the ten most common routes patients at a certain hospital need to take based on the most often noted diseases and disease combinations. So I will include the routes you specified in the Visual Basic Application.

So look out for that post.