The Tech PlatformJun 204 minHow to Create Graph in Excel?A graph is a visual element that represents data in a worksheet. You will be able to analyze the data more efficiently by looking at a...
The Tech PlatformApr 184 minAdvanced Microsoft Excel Features You Must KnowWhile Microsoft Excel has been around for the longest time, it has plenty of features that you probably know nothing about. Even...
The Tech PlatformJan 66 minConditional Formatting in ExcelConditional formatting is used to highlight the required information. Conditional Formatting changes the appearance of the cell on the...
The Tech PlatformJul 21, 20211 minHow to make a row stay at the top in excelWhen you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first...
The Tech PlatformJun 19, 20213 minHow to Make Pie Chart in ExcelIn this articles, you will learn about Pie Chart, Types and steps to make pie chart in Microsoft Excel. Pie Chart The “pie chart” or ...
The Tech PlatformJun 19, 20212 minMaps in Microsoft ExcelMicrosoft Power Map for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways. A power...
The Tech PlatformJun 3, 20213 minHow to Create a Graph in ExcelYou can create a graph from data in both the Windows and the Mac versions of Microsoft Excel. Steps 1. Open Microsoft Excel. Its app icon...
The Tech PlatformJun 2, 20213 minHow to use Automatic Data Type feature in Microsoft ExcelWant to know how to use the Automatic Data Type feature present in Microsoft Excel? Excel’s Automatic Data Type feature allows you to...
The Tech PlatformMay 29, 20213 minHow to Add a Watermark in Microsoft ExcelHere is a tutorial on how to add a watermark in Microsoft Excel. While Excel doesn’t provide any direct option to insert watermarks into...
The Tech PlatformMay 20, 20214 minHow to merge Excel sheets into oneOverall, there are four ways to merge Excel worksheets into one without copying and pasting: Combine sheets with Ultimate Suite VB...
The Tech PlatformMay 20, 20213 minConsolidate data from multiple worksheets in a single worksheetThe quickest way to consolidate data in Excel (located in one workbook or multiple workbooks) is by using the built-in Excel Consolidate...
The Tech PlatformMay 13, 20213 minWhat is Spilling in Excel? What it means and How to use it?The term spill or spilling refers to Excel's behavior when a formula that has resulted in multiple values outputs or "spills" all those...
The Tech PlatformMay 13, 20212 minHow to correct a #DIV/0! errorMicrosoft Excel shows the #DIV/0! error when a number is divided by zero (0). It happens when you enter a simple formula like =5/0, or...
The Tech PlatformMay 13, 20212 minHow to do calculations in Excel?Making calculations in Excel is easy. Here's how: Type the equal symbol (=) in a cell. This tells Excel that you are entering a formula,...
The Tech PlatformMay 9, 20216 minHow to Make a Line Graph in ExcelA line graph has a horizontal and a vertical axis and uses one or more lines to show where two values intersect. Line graphs are some of...
The Tech PlatformMay 9, 20215 min21 Important Uses of Excel (Other Than Spreadsheets)Here are a few broad categories to keep in mind when it comes to implementing Excel for anything numbers-related. 1. Calculating Find...
The Tech PlatformMay 3, 20217 minPython Jupyter Notebooks in ExcelEmbed Jupyter into Microsoft Excel and write Python instead of VBA Jupyter Notebooks in Microsoft Excel. Image by the author. It used to...
The Tech PlatformApr 26, 20215 minBasic Excel Formulas GuideMastering the basic Excel formulas is critical for beginners to become highly proficient in financial analysis. Microsoft Excel is...
The Tech PlatformApr 21, 20213 minHow to create a QR code in PowerPoint and ExcelQR codes are very useful for promoting business online. You have seen many apps in Google Play and App Stores that help you create QR...
The Tech PlatformApr 16, 20212 minIF Statements in Formulas in Microsoft ExcelA simple example of an IF statement is giving grades for percentages. We’ll assume that our percentage is in cell A2, and our formula...