Faysal Easy Excel

Have you ever tried to insert Emoji (Icons) in your Excel Formulas? Let's learn it. In Windows 8 or later version, you can insert Emoji. If you are still running Windows 7 or earlier version, you can insert Symbols by clicking "Insert > Symbols" instead of Emojis. Use Emojis or Symbols in your Excel Charts, Formulas to make your report attractive. Emoji picker shortcut key for Windows: Windows Key + "." or Windows Key + ";" Emoji picker shortcut key for Mac: Control + Command + Space Bar

Match function in Excel used to find the position number of a cell value in a data range, data table. It is the most popular Excel function for data analyst to compare two data range. In this video you are going to learn Excel Match function and how to use Match function in Excel. Best of luck.

In this tutorial, you will learn how to create a Database or DataTable in Microsoft Excel. Please follow these simple steps to create your Microsoft Excel Database or Datatable. Step 1: Open Microsoft Excel Workbook Step 2: Enter below data Image 1: Sample data   Step 3: Select all data Step 4: Click on Insert | Table Step 5: A dialog box will appear where the data range was automatically selected based on your data.   Image 2: Insert | Datatable   Step 6: Place a check mark on " My table has headers ".   Image 3: Create "Ok"   Step 7: Click on "Ok". Your current data is now converted to Database or Datatable.

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...