Excel 2016

Showing 41 - 60 of 72 results
There are scenarios where you might want to add more than one author names for a Workbook in Excel. You...
  • Excel
  • November 16, 2024
This blog will explain how to split the column that contains the full name to first name and last name...
  • Excel
  • November 16, 2024
Assume that you have a text in cell A1 and you wish you to find the 2nd occurrence of a...
  • Excel
  • November 16, 2024
There are plenty of shortcut keys available in Microsoft Excel that lets you to do few repeated tasks quickly. In...
  • Excel
  • November 15, 2024
Hereโ€™s a simple trick that lets you to swap the contents of the cell quickly in Microsoft Excel 2016. How...
  • Excel
  • November 15, 2024
This blog post will explain how the users can change the background color of a cell based on its value...
  • Excel
  • November 15, 2024
There are times when we might have to compare more than one column to find if there are any repeated...
  • Excel
  • November 15, 2024
There are various ways in which you can color the alternate rows or column in excel and these include the...
  • Excel
  • November 14, 2024
This blog post will explain how you can auto populate the cell when you select a value from drop-down list...
  • Excel
  • November 13, 2024
This blog post will provide insights on how you can merge and combine column values in Microsoft Excel 2016. How...
  • Excel
  • November 13, 2024
Do you want to hide the worksheets in Microsoft Excel 2016?. Hereโ€™s how you do it. How to Hide worksheets...
  • Excel
  • November 13, 2024
You can unhide the worksheets in Microsoft Excel 2016 with different ways. These include using the Format option from Home...
  • Excel
  • November 12, 2024
If you want to generate random numbers in Microsoft Excel , you can use the function RANDBETWEEN. How to Generate...
  • Excel
  • November 12, 2024
If you are one of the users who use excel more frequently at work, for instance, Data Analytics user, you...
  • Excel
  • November 12, 2024
You would have been in a scenario where you want to save your entire excel workbook to PDF in Microsoft...
  • Excel
  • November 11, 2024
Microsoft Excel 2016 provides the functions =TODAY() and =NOW() which displays the current date in a cell in Excel sheet....
  • Excel
  • November 11, 2024
Microsoft Excel provides the Wrap Text command that lets the users to quickly wrap long sentences and lets the users...
  • Excel
  • November 10, 2024
In Microsoft Excel , you can use the AutoFill feature to apply the same formula to the entire column by...
  • Excel
  • November 10, 2024
One of the simplest ways to calculate the age of a person in Microsoft Excel 2016 by providing the date...
Microsoft Excel 2016 comes with 3 office themes by default. These are light gray , dark gray and colorful theme....