Excel Date Picker
Hello , I would like to add date picker on an excel sheet. The goal is to create an excel file and have this sent to users to fill in. When filling the excel, and click on the start date, a calendar dropdown should appear and users select the date from the calendar so as to eliminate different date format and make it unique across the document. I was able to get a date picker add-in however this wont work because I am sending to users please see below:Can you lock an excel document so only 1 person can work at a time
Please how can you lock an excel file in a shared work environment so that only one person can work on the file at a time. Should someone want to work, they should see the file is locked for one person or one person editing at a time. Please i need helpHow to add user name if they edit a value in a row
I'm wondering if there is a way for Excel to tell me if a user has made changes to any entry in a row in a workbook? For example, if someone changes any cell value in a particular row in a workbook, I want a particular cell in that row to tell me who changed it, based on the user information logged in Excel. Value Value Person who make change in any row Row 1 Any change Any change User log in will show in this cell if they change Row1 Row 2 Any change Any change User log in will show in this cell if they change Row2 Row 3 Any change Any change User log in will show in this cell if they change Row3
Complex numbers in Excel
Did you know that Excel can handle complex mathematical operations with complex numbers? Complex numbers, expressed as "a + bi," where 'a' and 'b' are real numbers and 'i' is the imaginary unit, can be powerful tools in various scenarios. Think engineering, physics, signal processing, or even financial modelling. Excel offers native support for complex numbers, and you can perform basic operations like addition, subtraction, multiplication, and division just as easily as with real numbers. If you haven't explored this yet, give it a shot! It's as simple as entering a formula like =IMSUM(A1:B1) or =IMPRODUCT(A1:B1) One nifty feature is the ability to convert complex numbers from rectangular to polar form and vice versa. This can be a game-changer in certain calculations, especially when dealing with phase angles or magnitude-based analyses. For this you can make use of the =IMABS(A1) and =IMARGUMENT() functions. As complex numbers are considered to be text within Excel you will need special functions to perform arithmetic with them, such as IMSUM, IMSUB, IMPRODUCT, and IMDIV. Excel can help you plot complex numbers on the complex plane using the XY Scatter chart! you will need the IMREAL and IMAGINARY functions to extract the real and imaginary coefficients from the complex number to use them to plot the numbers. This feature can be invaluable when dealing with complex data sets or analysing the behaviour of complex functions. If you're interested in learning more about complex numbers, I made a video covering all functions that work with complex numbers in Excel: https://www.youtube.com/watch?v=_A2DIUibkmk Have you worked with complex numbers before in Excel? What specific use case did you have? Were there any obstacles you had to overcome?
Den höchsten Wert von SVERWEIS ausgeben
Hallo zusammen, ich benutze eine sverweis Formel (Liste A) im Bezug auf eine seperate Liste (B). Beispiel: Den Wert den ich aus Liste A über den SVERWEIS in Liste B Suche ist 1, dieser kommt in Liste B genau zweimal vor. Das erste Ergebnis von 1 ist 100 und das zweite Ergebnis ist 200. DIe Formel wirft mir jedesmal den Wert 100 raus. Ich möchte aber immer gern den größeren wert: in diesem Fall 200 haben.Pinning folders in Excel 2016 / Office 365
Hello everyone, Sorry if this is a topic that's ben done to death but I've had a look and I can't see anything really. We've just moved our users to 365 after a short pilot phase. The biggest problem our users are having (apart from Outlook attachments, don't get me started on that) is accessing files and folders they regularly use in Excel. In Word, we've been showing users how to 'Pin' folders and that generally works for most people. But in Excel, a lot of our users not only cannot pin but they have no recent history accumulating either. Within the IT team we can all pin and see our history. In reading around, I found a long thread suggesting that the Excel team had deliberately removed pinning and the 'correct' method was adding locations to Quick Access. However, if the pinning feature is gone, why can I still do it? I had a user who cannot pin sign into the Office 2016 on the same PC as I had signed into and I could pin and he couldn't. So now I don't know if I am looking at a bug, a permissions issue, or something else entirely. On a seperate but related issue, opening Sharepoint sites in File Explorer via Webdav and pinning those sites to Quick Access is likely to be popular with our users, but it drives a cart and horses through our attempts to move people away from Network Locations and get them actually interacting with SharePoint! I'm confused where MS are going with this... Any ideas folks? Paul
