This is how the Name Manager works in Excel
Calculate instead of numbers but just by name in Microsoft Excel, and make easier with the name manager's work.
7
06, 2019
27
10, 2018
Customize auto-completion and auto-correction in Word, Outlook & Excel
What is not suitable, is made suitable. How to Customize Auto Completion & Auto-Correction to Your Needs
9
07, 2018
The absolute, relative and mixed references in Excel
This is how you correctly use relative and absolute references in Excel and save yourself a lot of work
18
12, 2017
The Sreference and the Wreference in Microsoft Excel
Microsoft Excel: How to get S-reference and W-reference purposefully data out of a source.
13
09, 2017
Create Pivot Table and Pivot Chart in Excel
So you can easily create pivot tables with Microsoft Excel, and also sort large amounts of data without much effort.
25
03, 2017
How does Conditional Formatting work in Microsoft Excel
Many times, you have certainly wished that certain contents of your Excel spreadsheet be highlighted a little bit more, so that they catch your eye at a glance.
11
03, 2017
Why is my Excel File so big?
Solve the problem with Excel spreadsheets that take up several megabytes of space without any apparent reason.
25
02, 2017
Use macros correctly in Microsoft Excel 2016/2019
Almost everyone has heard of the term "macro" in the context of Excel, and perhaps has shied away from it because it sounds like a rather complicated affair for which you have to deal with Excel programming.
14
01, 2017
Create dependent dropdown menus in Microsoft Excel
In Excel, it may make sense to create a drop-down list that is based on a data source and also adapts dynamically instead of creating a very long list in rows or columns.
