by Ilker | Jun 7, 2021 | Excel Tips & Tricks
Using different coloring makes it easy to highlight differences in data or the layout of your spreadsheets. Excel has support for rows with alternating coloring in tables. What if your table contains similar values in groups, and you want to color the rows based on...
by Ilker | Jun 4, 2021 | Blog, Excel Tips & Tricks
Bar charts display data with the use of horizontally placed rectangular bars. Each bar represents a category and they are drawn with proportional length to the represented values. Download Workbook Bar Chart Basics Sections A bar chart has 5 main sections: Plot Area:...
by Adam | May 13, 2021 | Blog
Streamlining document generation process in your business comes with many benefits like better collaboration, easier bookkeeping, and fewer errors. Using SpreadsheetWeb, you can take automated document generation another step further and integrate any kind of...
by Ilker | Apr 1, 2021 | Excel Tips & Tricks
Finding formulas or displaying them can help troubleshoot or improve upon a spreadsheet. In this guide, we’re going to show you how to find formulas in Excel. Download Workbook Go To Special Go To Special is tool for finding not just formulas, but also other...
by Evan | Dec 7, 2020 | Templates
Unit conversion can be tricky, especially when dealing with some scientific units such as velocity, or energy. This Excel template was built to make conversions simple and easy to understand. One of the biggest advantages of using an Excel tool for unit conversion is...
by Evan | Dec 4, 2020 | Templates
This is an easy to use depreciation calculator template that can give you the annual depreciation rates and book values using straight-line, double-declining balance, and units of production methods. Simply enter the asset details like the initial value, salvage...
by Ilker | Nov 23, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a dynamically changing calendar in Excel. Download Workbook Populate variables First step is creating the variables to be used in the formulas. These variables need to provide the present day information so that...
by Ilker | Sep 8, 2020 | Excel Tips & Tricks
Finding your active file’s location can be a bit tricky at times. However, you can see the file location and even copy its location as a text from the Quick Access Toolbar. In this article, we are going to show you how to show workbook location in Quick Access...
by Adam | Jul 13, 2020 | Blog
Removing the barrier of entry into developing complex web applications even further with each step, we are excited to have brought you another version, jam-packed with new features. Excel’s flexible input/output structure allows for creating straightforward and...
