Showing posts with label Tutorials. Show all posts
Showing posts with label Tutorials. Show all posts

15 June 2017

Tutorial for Students: How to Master Speed Reading

Learning speed reading is of great importance to students as it enables them to cover, comprehend, and retain the huge chunks of study material and in turn, obtain good grades. On average, the majority of people read at about 200 to 400 words per minute. 


Mastering this skill will enable you to become a better reader as you will be able to take in more information faster and retain more of it.

17 November 2016

11 May 2016

HOW TO: Hide Last/Active Now Feature On Facebook

  • For PC Users, this is to disable the last active in minutes ago feature on Facebook.
  • Sometimes, we need to hide our last online active status when using Facebook.
  • Adblock Plus is a great tool for protecting last active online in Facebook.
  • Downside: You need to refresh the browser for new notifications update or chat message.
  • How to hide last online status on Facebook Chat
Although, last active online is a quite powerful feature, but people with privacy issues prefer not to be seen by other Facebook friends on Chat.

26 March 2016

HOW TO: Play Facebook Basketball Game

First off,  Facebook Messenger already had its chess game that works on a Web browser, just recently, Facebook Messenger announced its new minigame-hidden-yet-highly-addictive shooting game, Basketball, that works within its Messenger mobile app.

If you are bored, then you need to shoot and get a high score on it.

Image: http://www.eonline.com/news/750394/facebook-messenger-has-a-hidden-basketball-game-here-s-how-to-play

Facebook Messenger has a hidden addictive basketball game (celebrating the college basketball's March Madness tournament) within its app.

04 February 2016

30 January 2016

HOW TO: Convert Numbers(Currency) Into English Words In Excel

Microsoft Excel is an excellent spreadsheet software program for computing and sorting out data. Well, it is roughly designed to process large data arrays after its predecessor —  VisiCalc. 

Short history: In 1928, a Harvard Business school student, Daniel, Bricklin has this idea for a visible calculator. Later, Bricklin and Bob Frankston created the so-called "First Killer" application for PC; that is VisiCalc.  Must read: http://www.dssresources.com/history/sshistory.html

HOW TO: Convert Numbers(Currency) Into English Words In Excel

Microsoft Excel indeed solves accounting records problem. Thus, it's quite one of the best tools among users including me. 

But there is limitation with this powerful program, sometimes, we need to convert number currency (Peso, Dollar, Euros, GPC, pounds, etc.) to English Words, and doesn't have this built-in function.

Examples: 
  • 123 to "one hundred and twenty-three."
  • $123 to "one hundred and twenty-three dollars."
  • $123.50 to "one hundred and twenty-three dollars and fifty cents."
  • Php 123.00 to "one hundred and twenty-three pesos."
  • Php 123.50 to "one hundred and twenty-three pesos and fifty centavos."
However, the good thing is, they made a function module. (found on https://support.microsoft.com/en-us/kb/213360) Honestly, it gives me a great deal with it. I don't need to reinvent the wheel from scratch.

Here it goes:

HOW TO: Convert Numbers(Currency) Into English Words In Excel

1. Open Microsoft Excel
2. Press ALT+F11 on your keyboard to open Microsoft Visual Basic window.
3. Then, Choose Insert menu then click Module
4. Copy the following code and paste on that module window

Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
    Dim Dollars, Cents, Temp
    Dim DecimalPlace, Count
    ReDim Place(9) As String
    Place(2) = " Thousand "
    Place(3) = " Million "
    Place(4) = " Billion "
    Place(5) = " Trillion "
    ' String representation of amount.
    MyNumber = Trim(Str(MyNumber))
    ' Position of decimal place 0 if none.
    DecimalPlace = InStr(MyNumber, ".")
    ' Convert cents and set MyNumber to dollar amount.
    If DecimalPlace > 0 Then
        Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
                  "00", 2))
        MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
    End If
    Count = 1
    Do While MyNumber <> ""
        Temp = GetHundreds(Right(MyNumber, 3))
        If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars
        If Len(MyNumber) > 3 Then
            MyNumber = Left(MyNumber, Len(MyNumber) - 3)
        Else
            MyNumber = ""
        End If
        Count = Count + 1
    Loop
    Select Case Dollars
        Case ""
            Dollars = "No Dollars"
        Case "One"
            Dollars = "One Dollar"
         Case Else
            Dollars = Dollars & " Dollars"
    End Select
    Select Case Cents
        Case ""
            Cents = " and No Cents"
        Case "One"
            Cents = " and One Cent"
              Case Else
            Cents = " and " & Cents & " Cents"
    End Select
    SpellNumber = Dollars & Cents
End Function
      
' Converts a number from 100-999 into text 
Function GetHundreds(ByVal MyNumber)
    Dim Result As String
    If Val(MyNumber) = 0 Then Exit Function
    MyNumber = Right("000" & MyNumber, 3)
    ' Convert the hundreds place.
    If Mid(MyNumber, 1, 1) <> "0" Then
        Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
    End If
    ' Convert the tens and ones place.
    If Mid(MyNumber, 2, 1) <> "0" Then
        Result = Result & GetTens(Mid(MyNumber, 2))
    Else
        Result = Result & GetDigit(Mid(MyNumber, 3))
    End If
    GetHundreds = Result
End Function
      
' Converts a number from 10 to 99 into text. 
Function GetTens(TensText)
    Dim Result As String
    Result = ""           ' Null out the temporary function value.
    If Val(Left(TensText, 1)) = 1 Then   ' If value between 10-19...
        Select Case Val(TensText)
            Case 10: Result = "Ten"
            Case 11: Result = "Eleven"
            Case 12: Result = "Twelve"
            Case 13: Result = "Thirteen"
            Case 14: Result = "Fourteen"
            Case 15: Result = "Fifteen"
            Case 16: Result = "Sixteen"
            Case 17: Result = "Seventeen"
            Case 18: Result = "Eighteen"
            Case 19: Result = "Nineteen"
            Case Else
        End Select
    Else                                 ' If value between 20-99...
        Select Case Val(Left(TensText, 1))
            Case 2: Result = "Twenty "
            Case 3: Result = "Thirty "
            Case 4: Result = "Forty "
            Case 5: Result = "Fifty "
            Case 6: Result = "Sixty "
            Case 7: Result = "Seventy "
            Case 8: Result = "Eighty "
            Case 9: Result = "Ninety "
            Case Else
        End Select
        Result = Result & GetDigit _
            (Right(TensText, 1))  ' Retrieve ones place.
    End If
    GetTens = Result
End Function
     
' Converts a number from 1 to 9 into text. 
Function GetDigit(Digit)
    Select Case Val(Digit)
        Case 1: GetDigit = "One"
        Case 2: GetDigit = "Two"
        Case 3: GetDigit = "Three"
        Case 4: GetDigit = "Four"
        Case 5: GetDigit = "Five"
        Case 6: GetDigit = "Six"
        Case 7: GetDigit = "Seven"
        Case 8: GetDigit = "Eight"
        Case 9: GetDigit = "Nine"
        Case Else: GetDigit = ""
    End Select
End Function
Take note: the currency is a dollar, therefore, depends on your location, you need to change the text above. The function yields to these results:


Notice that if there is no decimal point, it will add "No Cents." In a real world, there is no need to put such words. Ideally, the "only" word shall put at the last of those sentences.

You can still edit it in the code above.

Tip: No need to manually type over again that function. All you need is to point and drag down until it displays the result. See below in action.

You will notice that it is not capitalized. If you wish to convert it to ALL UPPER CASE then right thing, Excel has built-in ALL CAPS. Thanks to function UPPER().

5. Then you close that window. In your Excel window, try to type =SpellNumber you will notice, if successfully embedded, display the function.

By the way, the function is called SpellNumber(Cell) (try to see above code)

6. There you have it! After accomplishing the desired output, you need to SAVE it to macro-enabled format. At first, it will prompt something like this:


As per instruction, you need to save it in a macro-enabled to include the function code. Therefore, click NO, and start choosing .xlsm file format.



19 October 2015

26 September 2015

21 September 2015

27 August 2015

HOW TO: Prepare Perfect Boodle Food Fight

This is a kinda delicious way to enjoy and have fun with friends or couple of family members —  with Food experience!

Those who are planning for a reunion, this kind of treat is very helpful and enjoyable!

From sending invites to making sure you have a bunch of food and drinks enough for everyone, planning a party can be quite tedious work, no matter how much you enjoy having people over. And although having one ‘pot luck’ style is a good hack, your guests would much rather prefer that you, as the host, took care of everything. 

23 August 2015

HOW TO: Generate Secure Password

The typical users tend not to be concerned about their simple passwords, you can't blame them, they have nothing at least their account information. However, as the technology emerges at beyond reasonably innovative, people these days rather choose internet to transact business or purchase or sell products or services.

07 August 2015

11 July 2015

HOW TO: Get Online Report of Rating For CSC Examiners

Civil Service Commission (CSC) provides and generates a report of rating report via online if the  examiner does not meet the passing rate of 80% in Paper and Pencil Test (PPT) Career Service Examinations (CSE).

Yes, it's a quick way to review your scores and those subjects need to improve for the next examination.

07 July 2015

HOW TO: See Who Unfriended/Deleted You On Facebook

Do you want to know who those people unfriended or deleted you on Facebook are? Well, there is an app for that. 

Introducing, Who Deleted Me, a FREE Facebook Friend-tracking app that used to show WHO UNFRIENDS or DELETES you on Facebook.

25 January 2015

HOW TO: Make YouTube Videos Load Faster

Pretty sure, you are frustrated to view YouTube videos that are relatively slow to buff. While it is painfully irritating and annoying to watch these slow buffering videos, there is quite existing extension or plugin that makes YouTube videos load faster and smarter. Learn more here.

22 June 2014

HOW TO: Download SCRIBD Documents 100% FREE

In doing research, we tend to get more external online sources particularly on subjects which need facts especially on documents/presentations — of course, we, in most cases, know a quite useful website, Scribd (which holds largest online documents ranging from e-books, documents, ppts, etc.)

However, most of those files in Scribd that are so important require to PAY before viewing or downloading it. Quality and eye-catching-best presentations are not available FOR FREE. You need to pay for membership for it. The good news is that you can actually DOWNLOAD it For FREE! How?

20 April 2014

How to Force Windows to Boot in Safe Mode? [ Windows ]

If you are wondering what F8 key does not seem to work, and you need to boot your system in the safe mode. How could you achieve in booting it in the Safe Mode?

Unlocking to safe mode with ASUS motherboard is kinda complicated thing to do. This article can help you somehow.

In order to boot up in the safe mode without trying to press F8 key, there is an system option via MSCONFIG.EXE that you can FORCE Windows to ALWAYS boot into SAFE MODE.

19 April 2014

[Solved] HOW TO: Fix CRCDISK.SYS Error In Safe Mode [ Windows Operating System ]

If power outage interruption occurred, most likely, you will have the problem in booting up your system. Sometimes worst, you will encounter crdisk.sys problem(it freezes) whenever you will try to access in the Safe mode in your system. How to fix it? What are the solutions?

In my experienced, crcdisk.sys error happened when the power supply is fluctuated. Thus, it will not boot up system normally. It hangs in the loading screen and repeatedly restart the system which is annoying at the same time disgusting. So how did I fix it? See below solutions.

What is CRCDISK.SYS?
CRCDISK.SYS was written by Microsoft that verifies and checks CR that is being read in the hard disk. It is also identified as "Disk Block Verification Filter Driver". 

22 March 2014

HOW TO: Add/Remove Horizontal Lines in Microsoft Word

One of the annoying yet useful features of Microsoft Word is HORIZONTAL Line. Annoying in a sense that whenever you attempt to delete it, it simply refuse to remove in the word document. On the other hand, those people who are working hard with this feature, simply know the importance to it.

The good news is that here is a good chance to remove this line, in very,  although not so complicated way, you need to be more nerdy about this.

Sometimes, Microsoft Word  adds border line in a paragraph because it thinks you want it in the first place. Also, when Auto Borderline is checked, it will automatically create border horizontal line whenever you put underscore.

16 February 2014

HOW TO: Set AutoPlay on Program To Use Media

Autoplay is quite awe feature in Windows. It will choose which program to open different media. However, sometimes, it can be annoying. Why? At the middle of work, when you insert CD or Flashdisk, if not properly configured, it will popup and certainly lags the system.

In order to fully utilize and optimize this, we, usually need to use program or set another light software to open.