by Ilker | Jun 9, 2020 | Excel Tips & Tricks
Excel has built-in support for adding chart and map combinations – also as known as map charts – since Excel 2016. A map chart is an easy-to-use tool that is great for when you want to visualize geographic data on a map. In this article, we are going to...
by Ilker | Jun 5, 2020 | Excel Tips & Tricks
Bing Maps is an add-in for Excel, that has been featured since Excel 2013 to create dynamic maps in your Excel workbook. You can create a dynamic map with data visualizations by using location data in your workbook. In this article, we are going to show you how to...
by Ilker | May 28, 2020 | Excel Tips & Tricks
Workbook_Open and Auto_Open are two predefined events for Excel VBA. Both events allow you to run a macro right after the workbook is loaded. You may want to open the workbook without triggering anything in some cases – either to skip a certain code block for...
by Ilker | May 28, 2020 | Excel Tips & Tricks
Workbook Statistics is a new feature Microsoft has released recently for Excel 365 users. Workbook Statistics is a dialog box that contains information about your spreadsheet such as the number of sheets, tables, formulas, charts, and PivotTables. In this guide,...
by Ilker | May 27, 2020 | Excel Tips & Tricks
You may want to set an expiration date for a workbook and prevent access for when creating a trial application, or simply ensuring that the application data is up to date. Unfortunately, Excel doesn’t have a built-in tools to handle this scenario, but you can use VBA...
by Ilker | May 5, 2020 | Excel Tips & Tricks
You sometimes get text with line breaks when copying a text from a website or word document. Although line breaks can be useful for a better layout, they can also make Excel tables look weird. In this guide, we’re going to show you how to Remove Line Breaks in Excel...
by Ilker | Apr 20, 2020 | Excel Tips & Tricks
Excel’s Status bar which is found on the bottom of the application window (like in some other Windows applications), displays additional information about various details, such as some workbook operations, statistical and aggregated values for a selected cell...
by Ilker | Apr 17, 2020 | Excel Tips & Tricks
How to enter number starting with zero in Excel Having trouble with entering values that start with zero? By default, Excel removes any leading zeros in front of a number when you type in such a value and press enter. So, this behavior makes it a bit hard to enter...
by Ilker | Apr 14, 2020 | Excel Tips & Tricks
When it comes to flipping the rows and columns your data in Excel you have two options: The Paste Special feature and the TRANSPOSE formula. Transposing in this sense means rotatating a range of values columns to rows or vice versa. In this guide, we’re going to show...
