Skip to main content

Posts

Showing posts from April, 2021

New Article

How to SUM by matching partial text in Excel

How to insert Emojis in Excel formula with Shortcut Key

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

Excel Match function and how to use Match function in Excel

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.

Excel MID Function | Extract the Time from Middle of a Text