Taryn Nefdt

About author

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS), and biofuels. She enjoys showcasing the functionality of Excel in various disciplines. She has over ten years of experience using Excel and Access to create advanced integrated solutions.

Latest Posts From Taryn Nefdt

0
Most Useful and Advanced Excel Functions List

Method 1 - VLOOKUP & HLOOKUP Functions In this VLOOKUP function in Excel: Learn with Examples tutorial, we provide an overview of VLOOKUP and an example ...

0
Microsoft Excel Security Tips: Secure Workbook & Worksheet

If you are looking for some exclusive security tips for Microsoft Excel, then this article will be helpful for you. We have already covered worksheet level ...

0
How to Use EDATE Function in Excel (5 Simple Examples)

While working in Microsoft Excel we often need to calculate dates. But without proper function, you won’t be able to do it. Using the EDATE function you can ...

0
How to Use For Each Loop in Excel VBA (3 Suitable Examples)

A For Each Loop is a piece of code that handles repetitive tasks efficiently without using any repetitive coding blocks. In this article, we demonstrate how to ...

0
How to Use Do While Loop in Excel VBA (3 Examples)

When you would like to repeat a statement as long as the condition meets, you can use the do while loop in Excel VBA. Using the do while loop, you can set ...

0
How to Use Sparklines in Excel [With a Snail Farming Example]

Sparklines are tiny mini-charts that are contained wholly within worksheet cells. Sparklines were introduced in 2010 and later versions of Excel. Sparklines ...

0
How to Use DATEDIF Function in Excel (6 Suitable Examples)

MS Excel users often need to calculate the difference between two particular dates. The difference can be in days or months, or years. The DATEDIF function ...

0
How to Use Do Until Loop in Excel VBA (with 2 Examples)

People like to be adventurous. They do not like to do the same thing again, again and again. In terms of working with VBA, we can skip the same code writing ...

0
How to Use For Next Loop in Excel VBA (10 Suitable Examples)

Are you looking for ways to use the VBA For Next loop in Excel? Then this is the right place for you. A loop is used when we need to run an operation ...

0
Comparison Among MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel

In our day-to-day life, we feel the necessity of finding the highest value as well as the lowest value. We even need to find out a specifically positioned ...

0
How to Use Select Case Statement in Excel VBA (2 Examples)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article will show ...

0
Difference Between Protect Sheet and Protect Workbook in MS Excel

  What Are Protect Sheet and Protect Workbook in Excel? In Microsoft Excel, the feature that prevents other users from accidentally or deliberately ...

0
How to Use CEILING.MATH and FLOOR.MATH Functions in Excel

The CEILING.MATH function is a new function that we can see in Microsoft Excel 2013 and later versions. The CEILING.MATH function rounds a specified number up ...

0
3D Referencing & External Reference in Excel

Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets ...

0
NOW vs TODAY Functions in Excel (3 Practical Examples)

While working in an Excel spreadsheet, you may have a good thought about the Excel NOW vs TODAY Function. The TODAYΒ Function is used to determine the current ...

Browsing All Comments By: Taryn Nefdt
  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.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo