Marks PC Solution

  Hello guys! In this post I'm gonna write about some basic functions of Excel i.e. left, right, mid, len & mid+len. Normally they look really simple. But they can be of great use if you know how to combine them with other functions . . .    In this tutorial I'm not gonna discuss about complex use of these functions. I will simply show you the basic use of them. Hopefully next time you will see the advanced use of these functions.    Let's start with the image above. There are mainly 04 formulas i.e. Left, Mid, Right & Len. And the next 02 are combinations of Mid and Len functions.  I've tried to explain every formula in this image. I guess nothing is ambiguous with these 04 functions.  You might be confused with the combinations. In the 1st combination the 02 functions are simply merged.  But in the 2nd combination you should notice that len function is not used. Instead we've used the len column i.e. G2. That is the difference. 1st combi...

    If you work with fraction numbers in Excel then you might be familiar with this problem. While summing up fraction figures in Excel the result may vary from manual calculation. This happens because Excel counts every digits after the decimal point even if they don't appear on the screen!    To fix this problem you can round the fraction numbers as per your requirements. Today I will talk about some simple ways to round the numbers. Hope this will solve your problem and save time as well . . .   Rounding the Numbers First you should know that Excel has 03 formulas to round the numbers -  Round Rounddown Roundup Depending on your necessity you can choose any of them. Let's begin . . .   Now I'm begging your attention to the above image. I've tried to show all the formulas in a single worksheet.  Look at the original numbers and their summation. And then look at the values of rounded numbers and their summations. There are some differences. Now i...

    In fact this is not a very difficult task. But in case of emergency you may not find the right option and this happened in my office few days ago! I solved the problem myself and decided to write a note for you at my site . . .   Changing IP Address on Windows 10 Simply move your mouse pointer at the bottom right corner and make a click on network icon > choose Open Network and Internet settings. Follow the image below -    After clicking on this option you will get the following dialogue box. Here you should notice Ethernet properties. Click on it.   Now you will get another screen as below. Here you will get several options. But our concern is IP settings and Properties . If wanna view your IP details then look at the Properties. If you need to change it then hit on the Edit button.    After clicking on the Edit button you will have two options i.e. Automatic (DHCP) & Manual.    In order the change the IP you should choose ...

      Back to my site after a long time with a simple excel trick. It's about countif functions of Excel which can count the cells depending on given criteria. Suppose you're analyzing the results of your students or anything else. You need to count the cells which are equal to or greater than or smaller than a specific value. Using countif function you can do so. And today I'm gonna show you how to add multiple countif function . . .       Countif Function Suppose you're counting the cells which are more than 400. Your range is A3 to A12. Then your formula will be -  =COUNTIF(B3:B12,">400") Similarly you can change the formula depending on your requirement. If you wanna find out the cells which are equal to 400 then -  =COUNTIF(B3:B12,"=400") For below 400, you have to type -    =COUNTIF(B3:B12,"<400")     Adding the Multiple Countif Functions - Hopefully you're done with countif function. Now I will show you how to a...

ছবিটি বড় করে দেখতে চাইলে এর উপর ক্লিক করুন বাংলা টাইপ করার জন্য সবচেয়ে জনপ্রিয় কীবোর্ড হচ্ছে বিজয় কীবোর্ড। বর্তমান সময়ে Mobile এ বাংলা টাইপিং এর জন্য নানা রকম Software/ App পাওয়া যায়। যেগুলো দিয়ে খুব সহজেই আপনি বাংলা টাইপের কাজ সেড়ে ফেলতে পারেন। তাছাড়া কম্পিউটারে লেখার জন্যও বহুদিন ধরে অভ্র Software টি জনপ্রিয় হয়ে উঠেছে। কিন্তু তারপরও বিভিন্ন অফিস আদালতে বিজয়ের ব্যবহার লক্ষ্য করা যায়।  টাইপিং এ যারা অভ্যস্ত না তাদের জন্য বিজয় কীবোর্ডে বাংলা টাইপ করা কিছুটা কষ্টকরই বলা চলে। আর অনেক কীবোর্ডে দেখা যায় বাংলা ফন্ট ও দেয়া থাকেনা। তাদের জন্য আমার তৈরী করা একটা PDF File শেয়ার করতে চাই। এর মাধ্যমে আপনারা খুব সহজেই বাংলা টাইপিং এর নিয়ম কানুন সম্পর্কে শিখতে পারবেন। আর আপনার কীবোর্ডে যদি বাংলা অক্ষর না থাকে তবুও আপনি এর সাহায্যে বাংলা টাইপ করতে পারবেন।  আর একবার যদি আপনি বাংলা কী গুলোর অবস্থান মুখস্ত করে নিতে পারেন তাহলে আর আপনার দেখে দেখে টাইপ করার প্রয়োজন হবে না। অনায়াসে স্ক্রীনের দিকে তাকিয়ে আপনি টাইপের কাজ সারতে পারবেন।  বিজয় টাইপিং এর নিয়ম   ...

More than 80% Smartphones are now operated through Android OS. And all the necessary applications are found on Google Play. But you can also backup your applications if necessary. And later you can share them with someone or restore on your phone when necessary. Android Application File Format The file format of Android applications is known as APK (Android Package Kit). Where in Windows OS we use executable (.exe) files. You can easily backup your installed applications and store them as APK file.  About  the App Name: Assistant for Android/ Android Assistant Category: Productivity App Rating: 4.4 Age Rating: 3 Size: Around 1 MB Offered by: AA Mobile How to Backup Android Apps? There might be different ways to do this task. But I would like to recommend you Android Assistant for this purpose. However it includes many other effective tools which are really helpful to operate your phone smoothly.  Download Android Assistant...

Exporting and Importing Contacts of your Smartphone is not a big deal. You can easily do this from the Settings option of your Contact App. But you will get it really challenging when you've to convert a simple excel file into vCard (.vcf) format and import them as your phone contacts.  If you don't have any third party tool or if you don't know the tricks then you may require few hours to save contacts on your smartphone one by one.  Just few hours ago I faced the same challenge and hopefully you will be glad to know that I've done the job! Of course it costs me nearly 2 hours to discover the trick. But you don't need to wait that long. If you face the same need, you can do this within few minutes. Let's see how . . . Convert Excel Contacts into vCard Format | 3 Steps Convert the Excel file (.xls/ .xlsx) into CSV (.csv)  Import the CSV file using Contacts - It's a default Windows Application in the previous versions of Windows...

From now you can choose and insert your desired special characters in your blog post. Recently Blogger has added this option in its post editor. It offers several fonts and categories of special characters.  While writing a new blog post you may need some special characters. Or sometimes you may need emoticons to share your feelings with the readers. To fulfil your need, blogger has added a new feature named - Insert special characters   👌 .  You will get this option at the editing toolbar and it's very next to the Insert a video option. Look at the image below -  Simply click on the marked icon and you will get the following dialogue box -  Using this dialogue box you can search your required characters from different categories. You can also search a character by keyword or by name.  Another useful search method is also available - drawing . Yes! You can manually draw the your character in the ...

I was expecting some new themes from blogger for a long time. As a renowned blogging platform, blogger should have more professional themes. And finally some beautiful themes have been added to the list. Now the blogger users can choose from 11 categories of themes . . . Previously blogger had only the following themes -  Simple Dynamic Views Picture Window Awesome Inc. Watermark Ethereal Travel And the new categories are -  Contempo Soho Emporio Notable Each new category includes 5 variations.  How to Change Theme? Changing your blog theme is as easy as changing your phone wallpaper. But before you make any change, you should preview it and customize the theme if necessary. You should also keep a backup your current theme .  If you would like to change your theme, then follow the procedure below: Go to your blogger dashboard. Then move to the Theme (Previously it was known as Templa...