Tag: name

• Excel and Power BI

  Flash Fill Trick in Excel 2016

  

  Here is a very common exercise that you might have or may come across – You have full names of employees in a column and you are expected to extract last names from these full names into a separate column. In versions prior to Excel 2013, you need to use…

  Jan 4, 2017
• Excel and Power BI

  A quick trick to create in-cell charts in Excel

  Here I share a tricky way to create in-cell charts in Excel with an example. Below is the data of a few employees and the respective volume of requests completed by them. Now enter the below formula in cell C2 and copy it till C8. =REPT(“n”, B2/50)      …

  Jul 29, 2013