by Olivia | Dec 27, 2022 | Blog
Make.com is an online platform that allows businesses to visually create, build, and automate workflows by linking applications and services together with just a few clicks. With Make.com, businesses can automate workflows across thousands of apps and easily...
by Ilker | Feb 23, 2022 | Excel Tips & Tricks
A waffle chart is basically a square display that shows progress towards a target or a completion percentage. They can be a fancy alternative to pie charts. In this guide, we’re going to show you How to create waffle charts in Excel. Download Workbook Creating a...
by Ilker | Nov 2, 2021 | Excel Tips & Tricks
Apparently, Excel doesn't have a hover (mouse over) event support for cells. However, we can use the HYPERLINK function to mimic this functionality, thanks to mouse-over support for hyperlinks in Excel. In this guide, we’re going to show you how to trigger a macro by...
by Ilker | Sep 13, 2021 | Excel Tips & Tricks
Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. Download Workbook...
by Ilker | Aug 4, 2021 | Uncategorized
Excel doesn’t have a predefined chart category for slopegraphs, but you can modify a line chart to create one. In this guide, we’re going to show you how to create slopegraphs in Excel. Download Workbook What is a slopegraph? Slopegraphs are good for displaying...
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...