Excel tutorial for Splitting bills and sharing expenses among friends

Sudeep Acharya
In this post, i will share an Excel tutorial where you can create tables and calculate the total amount spent by each person and find out who owes or need to give to whom. At the end of this post you will be able to make something similar to the following table below. Table1 = List of expenses including name and amount as well as the grand total spent by all.

PTE vocabulary with meaning in Nepali - Most Common

Sudeep Acharya
In this post, i will share most commonly repeated words and their meaning in Nepali as well as in English. Knowing the meaning of these words will help you a lot in scoring good marks in PTE. Word Meaning in Nepali Meaning in English abjure प्रतिषेध, परम्परा to withdraw one’s word or professed belief Abruptly अचानक in a sudden, unexpected, and sometimes unpleasant way abstract सार a summary of the contents of a book, article, or speech abundant प्रचुर मात्रामा present in great quantity accretion वृद्धि growth or increase by the gradual accumulation of additional layers or matter.

Useful Run (win + R) commands in Windows

Sudeep Acharya
Run command in windows are useful for instantly running the tools and softwares in Windows such as Task Manager and control panel. In this post i will be sharing some of the most frequently ones that are used on a daily basis. Also, these commands will work from command prompt. Command Description control Opens up the control panel appwiz.cpl Open up Add/Remove programs winver Shows up the windows version msinfo32 Shows up the system information perfom Performance monitor eventvwr Event viewer regedit Registry editor lusrmgr.

Useful Excel formulas and tricks

Sudeep Acharya
In this post, i will be sharing some commonly used excel formulas to make your life easier while creating report. Find cost in Table 2 by matching Serial Number in Table 1 If you have to find the corresponding value of some data in a table from another table then you can combine the INDEX and MATCH as follows: =INDEX(Table1[Cost],MATCH([@[Serial Number]],Table1[Serial Number],0),0) Check if serial number in Table B exists in Table A Using combination of ISNA and VLOOKUP to check if the serial number in table b exists in table A.

How i RECOVERED my hijacked GOOGLE account [in 6 days]

Sudeep Acharya
When i slept on 6th of December 2022 everything was fine until i woke up at around 7:30 next morning on 7th and found that i have been logged out of google my account from my phone. Day 1 - (7 December 2022) For a second i couldn’t think of anything, i thought the session was expired and tried logging in i was shocked to see my password was changed 5 hours ago.

Architecture and Modes of Cisco 1841 Router

Sudeep Acharya
Understand the external components of Cisco 1841 Router and learn three different modes User EXEC, Previleged and Global Configuration modes. The front view of the router The above is the front view of the Cisco router. We have the logo in the left side and Router model number on the right side which is Cisco 1841. Next, we have two system LED 1 and 2 as follows: System Power (SYS PWR) LED - No power means off and blinking green means that the router is booting.

Get free domain .com.np and free hosting

Sudeep Acharya
For Nepali citizens, you can register free .com.np domain. In this post, I will teach you to point this domain to Github Pages using Cloudflare DNS for free. Mercantile Communications Pvt. Ltd. provides .com.np domain registration for free of cost and provides to use DNS service. Step 1: Setup Github account and upload website To upload your website into the github account you need to learn git. I am not covering the tutorial for using the git.

Moving to Github Pages using Jekyll from WordPress.com

Sudeep Acharya
I started my blog “hellocoding.wordpress.com” in 2013. WordPress.com provides the basic functionality of posting the post for free. It does not give the way to embed JavaScript and does not offer much control over your blog. After a few years of blogging in WordPress.com, I realised that I want more control over my site so that I can improve my SEO, make a page redirection and make my site how I want in every possible way.

How each of the Network Protocol layers work behind the scene

Sudeep Acharya
When we type google.com in our browser, we see the google home page. We are unaware of the back scene about how the each layer of the protocol works. In this post i will describe, how each of the protocol layer works. First of all let’s see what are the layers involved in OSI and TCP/IP protocols. Layers and their functions of OSI model Layer Task At Layer Application Layer Web browser that the user interacts with.

A Silly way to comment in your Code

Sudeep Acharya
During my beginners year of writing code, i used to comment unnecessarily. I realised this after i saw the code written by senior developers. The main purpose of the comment is to make your code understood by other developers who are working together in the same project or for other contributors. Let us take an example of the silly code: <?php // Assigning the value to firstNumber firstNumber = 9 // Assigning the value to secondNumber secondNumber = 12 // Creating variable to store the sum of firstNumber and secondNumber sumOfNumbers = 0; // Adding both firstNumber and secondNumber and storing it to sumOfNumbers sumOfNumbers = firstNumber + secondNumber // Displaying the result echo sumOfNumbers; ?