training
1027 TopicsComplex 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?25KViews2likes4CommentsConditional formatting
I'm making a rule to Highlight cells in Column AZ when the value is lower than Adjacent cells in Column P. For the most part it works except for two cells in AZ (1 shown as an example) that are higher than P but are being picked up by the conditional formatting. The two cells I'm focusing on here are P14 (£0.27) and AZ14 (£0.43). £0.43 should not be being highlighted pink as it isn't lower than £0.27. This has to be something obvious but I have looked at it too long. Please help if you can :)Solved315Views0likes3CommentsLooking for advice on leveraging AI for Excel in a price-sensitive, third-world country
I work for a training company in a price-sensitive, third-world country and have been conducting training in MS Excel for close to 2 decades. My company has asked me to design Excel training that teaches how to use AI to improve productivity. Ethical considerations aside, it’s something I have been thinking about for a while. The main roadblock I see is the average purchasing power of participants in our market. Right now the cheapest Copilot plan is USD 99.99/yr for MS 365 Personal. The cheapest plan for Business or Enterprise is USD 18/user/month for MS 365 Copilot business (billed at USD 216/user/year). I’ve been casually speaking with the participants in training sessions and most are happy with the free chatbot versions of Copilot/ChatGPT/Gemini that almost no one would upgrade to a paid subscription to integrate AI with Excel - they describe their problem to the AI, send screenshots or upload files and then try and implement the solution that’s returned. It’s similar in the business/enterprise context. Larger organisations may have paid for AI subscriptions for their employees but those are few in number. Most businesses in this market are classified as Small-Medium-Enterprises (SMEs) and feedback from participants is that their management would not likely approve of the cost. It’s worth mentioning that my training company does not provide computers instead requiring participants to bring their own laptops with valid Excel licences though we standardize things as much as possible e.g. Windows only, no tablets etc… This means if we design a training that requires a paid Copilot subscription, then it is up to the participants to buy it for themselves which I don’t think many of them will. After speaking with management, they are open to designing a training that uses the free AI chatbots. I’m fine with that but don’t know how much value that would add to what people are already doing. I’m quite sure this strategy is management trying to revive Excel training which used to be top-sellers (demand fell off ever since COVID) and they see other Excel training incorporating AI so want to follow suit. So right now the most viable option is to create training that teaching using free AI chatbots. But I’d like to hear the opinions of others - what other options do you see for a price-sensitive, third-world market? And yes, I did ask AI how Excel users can leverage AI without paying for expensive subscriptions and it basically said “use the free chatbots”.234Views0likes1CommentCreating Sankey Diagrams
Hi, Does anyone have any guides for creating Sankey Diagrams in Excel. I deal with the analysis of a reasonably long process which has various customer inputs and outcomes. I am looking for a visual way to show everyone who came into the process, and what happened to each person. Sankey Diagrams seem to fit that bill perfectly. Any help would be appreciated. Thanks T319KViews0likes9CommentsScenario basic help please
Hi. I have a spreadsheet which calculates electricity usage and solar input etc. As the price keeps changing I am putting the new prices into the spreadsheet. I was thinking that I could use Scenarios or similar to be able to see what the bill would have been previously. I have looked at the Scenario instructions but I'm not quite sure how to use it (bit rusty in Excel recently). Is there a training video or similar I could watch. Any help gratefully received. Regards Bluey355Views0likes2CommentsRemove a comma from a number treated as text
Greetings! I'm new to this forum, and I don't know if this is the right place to ask. But, here it goes: I have a column of currency values which is a mess. I managed to clean it as much as possible using the functions SUBSTITUTE and TRIM. These functions transformed the unformated numbers into text, and now it looks something like this: 6,764,68 1,319 1,948 301,40 2848,08 The former is a sample from 165 entries. Is it possible to remove the first comma of the string, so the values look like this instead? 6764,68 1319,00 1948,00 301,40 2848,08 What I would like to do is to remove the second comma from right to left in each value, while keeping the first which marks the cents of the transaction. Can this be done? Thanks all in advance :D507Views0likes3CommentsGLSU Excel add-in fails to load after Office update from Version 2607 to 2608
Our Excel add-in, Process Runner GLSU , fails to load after Microsoft Office updates from Version 2607 to Version 2608. This started August 17, 2026 and is actively growing in scope. Error messages: Excel: Cannot run the macro 'onLoad' VBA: System Error &H80004005 (-2147467259). Unspecified error VBA: Compile error in hidden module: ThisWorkbook Has anyone encountered similar issue with their own custom add-on. If yes, any pointers to fix it. We are seeking help on priority. Thanks, Vrushali Pawale, Sr. Manager, Insightsoftware.1.2KViews0likes1Commentmulti Vehicle maintenance log record
i need to make a vehicle maintenance log that will have 7 different vehicles, track all the oil changes, inspections, registrations that will notify us when something is expiring, and be able to attach receipts and documents to it. what is the best way to do this?21KViews0likes3Comments