Custom Formatting Excel – Number Format Codes Excel
We use a practical example to explain the importance and possible uses of custom formatting in Excel. Number format codes in Excel are not rocket science!
21
04, 2022
18
03, 2022
How to create a dynamic table in Excel
This is how you conveniently create a dynamic table in Excel and have it automatically carry out calculations.
25
02, 2022
Use macros correctly in Excel
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.
27
12, 2021
Excel Scenario manager and target value search
How you can use the scenario manager and target value search in Excel 2016/2019 to present complex issues in a space-saving and clear way.
23
11, 2021
Apply nested functions in Excel
Nested functions in Excel offer the possibility to combine several arguments with each other or to exclude conditions. We explain how it works.
21
09, 2021
Insert Excel spreadsheets into Word Documents
So you can easily insert Excel spreadsheets into Word and link them together to get a dynamic document.
15
09, 2021
Create vacation planner in Excel
We explain how you can create your own vacation planner 2022 in Microsoft Excel. And of course with a display of public holidays and weekends.
14
09, 2021
Create annual calendar 2022 in Excel
In our tutorial we describe how you can create an annual calendar for 2022 with a display of the calendar week and public holidays in Excel, and use it anew every year.
2
09, 2021
Create individual charts in Excel
Charts are created quickly in Microsoft Excel. We explain how you can customize them, and also swap (transpose) the axes.
