ExcelHow to Insert a New Row in Excel
Building a spreadsheet is rarely a perfect, linear process. You might spend an hour alphabetically...
ExcelHow to Use the IF Function in Excel
Most basic Excel formulas are static. If you type =A1+B1, Excel will always add those...
ExcelHow to Sort Data Alphabetically in Excel
Raw data is rarely entered into a spreadsheet in a logical order. Employees are added...
ExcelHow to Use the SUM Function in Excel
The SUM function is the most basic and most used formula in Excel. Using SUM...
ExcelHow to Use the CONCATENATE Function in Excel
When working with large databases in Excel, data is often split into separate columns. For...
ExcelHow to Use the TRUE and FALSE Functions in Microsoft Excel
When you are building complex formulas in Microsoft Excel, you are almost always dealing with...
ExcelHow to Use the RAND and RANDBETWEEN Functions in Excel
Whether you need to generate dummy data for a software presentation, simulate dice rolls for...
ExcelHow to Use the FV Function in Microsoft Excel to Calculate Future Value
If you are planning for retirement, trying to figure out how much a savings account...
ExcelHow to Use the LEN Function in Microsoft Excel to Count Characters
When working with large datasets in Microsoft Excel, you may need to know exactly how...
ExcelHow to Use the REPLACE Function in Microsoft Excel
When cleaning up messy data in Microsoft Excel, you often need to swap out specific...
ExcelHow to Use the NETWORKDAYS Function in Microsoft Excel
If you are managing a project timeline, calculating payroll, or tracking how long a support...
ExcelHow to Use the CHOOSE Function in Microsoft Excel
Microsoft Excel offers dozens of ways to look up data and return specific values. While...
ExcelHow to Use the SUMPRODUCT Function in Microsoft Excel
When working with inventory, sales data, or complex calculations in Microsoft Excel, you frequently encounter...
ExcelHow to Freeze the Top Row in Excel
When you are working with a large Excel spreadsheet that spans hundreds of rows, scrolling...
ExcelHow to Use the PROPER Function to Capitalize Names in Excel
When you inherit a spreadsheet filled with data collected from a public web form, the...
ExcelHow to Use the MATCH Function in Excel to Find the Position of an Item
When analyzing massive spreadsheets, you rarely need to know simply if a value exists; you...
ExcelHow to Create a Waterfall Chart in Microsoft Excel
When analyzing financial data, simply showing the starting revenue and the final profit often leaves...