Skip to main content

Posts

Showing posts from February, 2021

New Article

How to SUM by matching partial text in Excel

Fiverr Tutorial 3: How to Create Excel file with Customer Name and Buyers require format

This tutorial is for beginners. In this tutorial I'll show you how you can save your Excel file with a Customer Name while you are working on Fiverr. Assume that, you have opened a new Excel File. In "Sheet1" you have collected some data for your Customer. Now you want to Save your New Excel file with your Customer's name. Step 1: To do this, you need to Click on "File and then Click on Save. This will highlight the "Save As" menu. Image 1: Save option Step 2: Now Click on Browse button. It will show "File Save as" dialog box. Step 3: In this dialog box, Click on Browse button. This will show the "Save as" dialog box. Step 4: You need to select your desired location. Here I've selected "Desktop" as target location. You can Pin you target location, so that every time the "Save as" dialog box appears, Pinned Folder will stay top always. Then I type the file name "Book4" which I want. Finally Click...

Fiverr Microsoft Excel 2016 Skill Test and Answers 2021

This video will help you about preparing Fiverr Excel Skill Test. I've just taken this Fiverr Excel Skill Test and successfully passed with a scored 6 out of 10. I'm sharing my Fiverr Excel Skill Test and Answers 2021 video so that you can prepare yourself if you would like to give a test on Fiverr.    I have taken the Fiverr Excel Skill Test on Fiverr and obtained 6 out of 10 scores. If you take a test and pass, it will greatly help the buyer to trust you and your skills. Please note that your exam will not be exactly the same as mine because there are many more questions in the pool than 40 which appeared in my test. But I am hopeful that you will succeed in it. If you have any queries, please write them in the comment section. I will try my best to guide you.Follow this video and try to get a general idea. By following the instructions, you can successfully pass the test.    After passing the Fiverr Excel Skill Test, Fiverr shared a Excel Expert Badge on my Profil...

Fiverr Tutorial 2: What is the difference in between xls and xlsx files?

XLS and XLSX are two different versions of Microsoft Excel. XLS File Format: During the 1995 to 2003 Microsoft Excel used the file format XLS. That means if your Microsoft Excel version is 1995, 1997, 2000, Millennium or 2003 and you saved a file in your PC, then it will use XLS format to save that Excel file in your PC. XLSX File Format:   On the other hand if your Microsoft Excel version is 2007, 2010, 2013, 2016, Office 365, Excel Online or in a word 2007 and upper version, and you saved a file in your PC or Online, then it will use XLSX format to save the Excel file in your PC. Difference in Between XLS and XLSX: So, if both format are for same application, then what are the difference in between these 2 extension? Below are the difference: 1. Version: XLSX is latest version of Microsoft Excel and XLS is the older version. 2. Main Difference: XLS is the default file format for the 2003 version of Excel and older. XLSX is the file format for versions since 2007 and upper version...

Fiverr Tutorial 1: Learn these basic Microsoft Excel skills to start work in Fiverr Marketplace

Fiverr Marketplace is one of the most popular Digital Marketplace to earn from online. Before start earning about Microsoft Excel related task, you need to prepare yourself first. But the question is, "what are the basic Microsoft Excel skills to learn for starting work at Fiverr Digital Marketplace?" The answer is, there are lots of Microsoft Excel skills you can learn to start work. But according to my article I will suggest you to learn the basic Microsoft Excel skills which has given below: 1. Excel Data Entry:   Data Entry is a popular task in Fiverr at low budget. Many companis are hiring Freelancer to collect data from various sites and plot them in an excel sheet. So, you can learn below things: What is the difference in between *.xlsx and *.xls files? How to Create an Excel file with Customer Name and Buyers require format? How to create a Database or Datatable in Microsoft Excel? How to copy a specific data from a webpage and Value Paste it in Microsoft Excel? How t...