by Ilker | Mar 11, 2022 | Excel Tips & Tricks
Big or small, all business operations need forecasting. Forecasting can be either qualitative or quantitative. In the end, you should estimate future incomes and expenses to draw up a budget. Since each business sector and the company have their own dynamics, there is...
by Ilker | Mar 3, 2022 | Excel Tips & Tricks
The FORECAST.ETS.SEASONALITY function is a Statistical function that predicts the length of the season in a repetitive pattern, for a given specified time series. The function returns the same season length which is calculated by the FORECAST.ETS function...
by Ilker | Feb 24, 2022 | Excel Tips & Tricks
Versioning is the best way to prevent data loss in case of software crashing or faulty updates. If you are a Microsoft 365 subscriber, the AutoSave feature handles getting copies frequently and allows you to access previous autosaved versions. If you are not a...
by Ilker | Feb 24, 2022 | Excel Tips & Tricks
Although CSV stands for comma-separated values, it has become a common file type to define simple text files including delimiter-separated data. Thus, a CSV file can use a semicolon or tab character as a delimiter as well. In this guide, we’re going to show you how to...
by Ilker | Feb 23, 2022 | Excel Tips & Tricks
How to hide used items in dropdown lists in Excel Dropdowns are a great way to controls user entries to specific values. Although the default data validation dropdown in Excel doesn’t support hiding items as they are used, we can mimic the behavior with formulas. In...
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 | Feb 22, 2022 | Excel Tips & Tricks
Nothing beats visuals when you need a simple way to track progress. Visual indicators can tell you which project is leading immediately without delving into numbers. In this guide, we’re going to show you How to visualize percentage progress in Excel. Download...
by Ilker | Feb 21, 2022 | Excel Tips & Tricks
If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...
by Ilker | Dec 27, 2021 | Excel Tips & Tricks
Excel supports various methods and formulas to calculate depreciation. There 7 built-in functions dedicated to depreciation calculation. In this guide, we’re going to show you How to calculate depreciation in Excel in 7 ways. Download Workbook Depreciation types in...
