Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 7 of 60 · 540 articles
How to Open All Excel Files in a Folder on Startup
In this guide, we're going to show you how you can open all files in a folder on startup. Excel allows you open all files at once on startup.
How to Remove Spaces in Excel
In this guide, we’re going to show you how to remove spaces in Excel with Formulas and Find & Replace dialog.
How to Create a Pareto Chart in Excel
Ideally suited for tracking indicators like acceptance metrics or production quality, Excel Pareto charts are essential for data analysis.
Bar Chart
SpreadsheetWeb • We’re going to show you how to create and cutomize one of the staples of data visualizations, bar charts in Excel.
How to slugify a string with Excel
SpreadsheetWeb • Excel Tips & Tricks • In this guide, we're going to show you how to slugify a string with Excel.
How to Loop through Each Character within a String in Excel
In this guide we will show how to efficiently loop through text data using this simple VBA code to analyze or manipulate strings.
How to hide named ranges in Excel using VBA
SpreadsheetWeb • Excel Tips & Tricks Securing Your Excel Formulas: A Guide to Hiding Named Ranges with VBA.
How to Combine Data from Multiple Sheets in Excel
By leveraging Excel Tables and the intuitive Power Query interface, users can effortlessly merge information from distinct sheets.
Decoding Week Numbers in Excel: A Comprehensive Guide to the WEEKNUM Function
SpreadsheetWeb • Find out what week number, what week of the year is it, and more using WEEKNUM function in Excel.