Export YouTube Playlist to Excel using Excel Macro

Are you learning from YouTube videos and finding it difficult to track the progress? What if there is a way to extract all the video titles along with their duration into Excel and track their progress. Wouldn't that be easy !!!
Here is a simple Excel Macro to do just that.

Tracking Stock Data using Google Sheets

Google Sheets can pull stock prices (delayed) using a function called GOOGLEFINANCE. This can be helpful if you want to derive your own customized formula like where is the stock positioned w.r.t 52-week high-low prices OR you may want to get the highest price of the last 30 days or 10 days.

Quick Guide to IELTS Preparation

This is not a Complete Preparation Course for the IELTS Exam. As the Blog title suggests, it is for those who want to have a quick grasp of things. Please refer the links given for test details, tips, scoring criteria and practice tests.

IELTS - International English Language Testing System

Converting CSV files to Excel and Formatting using Excel VBA

Requirements:

1. A Spot Billing Machine which records Monthly Gas Usage in an area downloads the data in CSV files.

Numbers - Solved Examples

Examples

Example 1. Find the largest number which divides 238, 358 and 418 leaving the same remainder in each case.
(A) 60      (B) 120      (C) 45      (D) 90

Numbers - Important Formulae

Important Formulae

1. Prime Numbers - A number which doesn't have any factor apart from one and itself. Ex: 2,3,5, etc.

• Every prime number greater than 3 can be written in the form of (6k + 1) or (6k - 1) where k is an integer.
• To find a number N as prime number or not, let k be the smallest number such that k² ≥ N. Now, test whether N is divisible by any of the prime numbers less than or equal to k.

Percentages, Profile & Loss, Partnerships

Important Formulae

1. Percentage Increase = (Actual Increase / Original Quantity) X 100

    Percentage Decrease = (Actual Decrease / Original Quantity) X 100