Hello, I want to create a line chart in Excel with several different lines. However, the data of one line ranges from 100,000 to 500,000 and the data of the other line ranges from 500 to 5,000. This means that changes in smaller data are barely visible. Is there any workaround here?
Hi, I created a link to an Excel file in Excel, but when I try to open the file from Excel, it says I can't open it because I don't have Excel. But I do have Excel! How did I link the file? Insert tab > Object > Create from File > Insert File How…
Hi everyone, I have an Excel spreadsheet with products that lists the item number and price. Now I have a second Excel spreadsheet with only item numbers (in a completely different order than the item numbers in the other document) into which I need to enter the prices. Is there a way to enter a…
I have the date in column (e.g., sorted in ascending order), the expense in column B, and I want the sum of all expenses from the same year in column C. For example, if I had determined the year from column A in column D (e.g., d384=year(a384)), I would write sumif(d$2:d384;d384;b$2:b384). I would like to…
Hello, Why do many IT people (software developers, etc.) dislike Excel (and say things like Excel is not a database)? What's the problem with that? The tool has a low barrier to entry, and for many of the tasks there isn't always a simple replacement tool. Sometimes you have to learn something new, or even…
In other words: Even if you are slow at the beginning, you will get faster with time and practice?
I would like to create an Excel document for my school grades, as shown in the diagram above. The first row in the first column should contain the assignment grade for German, for example. Assignments are graded twice. The second row in the first column should contain the single-grade grades, such as short-term assignment grades,…
Hello, I wanted to create a budget spreadsheet in Excel that calculates the planned monthly budget on a daily basis. It should be calculated so that it always adds up at the end of the month. Line C3 contains my budget for the month. This should now be distributed among the individual days. In column…
(I took the screenshots in Google Docs because I don't have Excel at home, but at work we have Excel 2010) This is the folder I want to create (with sample data): And I want to refer to this separate folder: I want to display the item expenditures of the last 6 months (not beyond)…
Hi, I want to create a dropdown list in Excel where you can select several options from a selection list. The following example scenario: A list is given for managing employees on different projects. One column of the Excel spreadsheet lists the projects. In the second column, I want to have a dropdown list where…
Hello, I programmed a user mode and a developer mode according to the following video: https://www.youtube.com/watch?v=QplgVS_ljbI Once I start my user mode, I can exit it with ESC. How can I ensure that I can't exit the view as a normal user? I've created a mask as a login window that allows me to log…
Hello, how can I format a combobox in Excel as a date using the RowSource method? Thank you, greetings