How to SUM by Cell Colour in Excel without VBA This guide will show you how to SUM by cell colour in Excel without VBA. Once you have learned to SUM based on coloured cells in Excel, you can also use COUNT, IF, IFS, SUMIF, SUMIFS, COUNIFS, SUBTOTAL, AGGREGATE, AVERAGE... 
How to Translate Text in Excel This guide will show you how to translate text in Excel. The translate feature in Excel helps you to change content from one language to another right in your spreadsheet. This feature is handy globally where your data needs to be... 
How to use Smart Lookup in Excel This guide will show you how to use Smart Lookup in Excel. The Smart Lookup in Excel is a helpful feature that lets you quickly find information without leaving your spreadsheet. It uses Microsoft’s Bing search to show you... 
How to Spell Check in Excel This guide will show you how to spell check in Excel. The spell check in Excel helps you to keep your data accurate by finding and fixing spelling mistakes. This feature checks the text in your cells, allowing you to easily correct errors... 
How to Make an Excel File Read Only after Opening This guide will show you how to make an Excel file read only after opening. Making an Excel file read-only after opening helps to protect your data by stopping you from making unwanted changes. When a file is... 
How to use Selection Pane in Excel This guide will show you how to use selection Pane in Excel. The Selection Pane in Excel helps you to manage and organize different objects in a worksheet, like shapes, images, charts, and other objects. It shows a list of all the... 