Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 38 of 60 · 540 articles
How to make Excel calculate faster
Complex files can slow your workbook and impact calculation time. In this guide we're going to show you how to make Excel calculate faster.
All You Need to Know on How to Create a VBA loop in Excel
A loop is an essential concept for programming. In this guide, we're going to show you how to create a VBA loop in Excel.
Control Shift Enter Excel Shortcut (CSE) and Array Formulas
In this guide, we're going to explain you Control Shift Enter Excel shortcut (CSE) and how to apply array formulas in Excel.
10 Things You Need to Know About the VLOOKUP Excel Function
In this guide we're going to list 10 things you should know about VLOOKUP Excel function. These tips also work for the HLOOKUP function.
How to convert seconds to time value in Excel
Excel evaluates them a bit different than real world. In this guide, we are going to show you how to convert seconds to time value in Excel.
How to solve quadratic equations in Excel – Formula and VBA
In this guide, we are going to show you a different approach to solving quadratic equations in Excel using formulas and VBA.
How to solve quadratic equations in Excel - Goal Seek
In this guide, we are going to show you how to solve quadratic equations in Excel. The first part of the article focuses on Goal Seek.
How to create bullet points in Excel (•)
In this article, we are going to show you how to create bullet points (•) in Excel. We have listed 4 ways to insert a bullet point in Excel.
How to concatenate strings in Excel
In this guide, we're going to show you how to concatenate strings in Excel using the ampersand character and also with the help of functions.