User Posts: Taryn N

Excel has a wide variety of functions that you can utilize to accomplish a myriad of tasks. We have put a list of tutorials together on the functions that you ...

READ MORE +

Before we dive into creating databases and data-centric applications in Access, it is prudent to go over some basic database and relational database management ...

READ MORE +

Microsoft Office Access is a database management system (DBMS) provided by Microsoft as part of its Office Professional or Business suite, that allows one to ...

READ MORE +

We have already covered worksheet level protection and workbook level protection extensively in a previous tutorial. We are now going to cover securing your ...

READ MORE +

Excel provides a wide variety of functions to handle date calculations. We have already looked at some of these functions in previous tutorials. The EDATE ...

READ MORE +

2017 was a great year for Excel and Excellers (those of us who love using Excel for work or study purposes and can’t wait to learn more about this wonderful ...

READ MORE +

We have already covered an introduction to looping and the simplest type of loop, the For…Next Loop in a previous tutorial. Let’s just remind ourselves of what ...

READ MORE +

We have already covered an introduction to looping and the simplest type of loops, namely the For…Next Loop and the For Each…Next Loop, in previous tutorials. ...

READ MORE +

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

READ MORE +

Performing operations and calculations involving dates requires that one acquires familiarity with some of Excel’s Date and Time Functions.The DATEDIF ...

READ MORE +

Conditional formatting allows one to visually highlight or visually emphasize certain values in one’s dataset, based on the fulfilment of a certain criteria. ...

READ MORE +

The Do Until Loop Structure is utilized, when one has a set of statements or actions to be repeated and repetition occurs until the condition evaluates to ...

READ MORE +

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function and the Proper Function, which can change the case of a specified ...

READ MORE +

Often when writing VBA code, one may need to repeat the same action or series of actions more than a couple of times. One could, in this case, write each ...

READ MORE +

Excel usage is widespread and Excel is often the go-to Office application for data entry, analysis, and manipulation. Microsoft Access provides relational ...

READ MORE +
Browsing All Comments By: Taryn N
  1. Reply
    Taryn N December 16, 2017 at 10:16 PM

    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. Reply
    Taryn N December 16, 2017 at 10:47 PM

    🙂 Thank you so much 🙂

  3. Reply
    Taryn N August 24, 2017 at 3:38 PM

    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. Reply
    Taryn N June 28, 2017 at 5:18 AM

    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. Reply
    Taryn N May 17, 2017 at 3:51 AM

    Thank you so much :-).

  6. Reply
    Taryn N April 16, 2017 at 9:37 PM

    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. Reply
    Taryn N April 10, 2017 at 10:42 PM

    Thank you so much.

  8. Reply
    Taryn N April 5, 2017 at 7:40 PM

    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. Reply
    Taryn N March 31, 2017 at 9:56 PM

    You are very welcome. Thank you for reading and doing Excel with us 🙂

  10. Reply
    Taryn N March 23, 2017 at 8:25 PM

    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. Reply
    Taryn N March 23, 2017 at 8:05 PM

    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. Reply
    Taryn N January 30, 2017 at 4:30 PM

    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.