Excel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!
New free Excel training courses from LinkedIn Learning on Support.Office.com
We have a whole new collection of training courses to help you get the most out of Excel 2016. Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other time-saving features. Please let us know what you think of these new courses. They’re free, along with the rest of the courses and videos in the Office Training Center. Best, Freya Office Newsroom
BinaryFormat.Binary , BinaryFormat.Byte,BinaryFormat.ByteOrder,BinaryFormat.Group,BinaryFormat.Lengt
Dear Experts, Greetings, I have a data like below( Most interesting is the Column "E"-> rat0BitMap:- The max size of the Column "E" is 11 bits ( which is max numOfPRB == 162), I want to perform the above functions in this Column "F" which is the BIN of Column "E", but getting Errors in all functions, in PQ microsoft page, their example also I can't see. Could you please educate me/Perform the above 5 functions in Column "F", using PQ, Thanks in Advance, Br, AnupamComplex 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?
Power BI hierarchies missing when data model consumed in Excel
I posted this issue in the Power BI forums. Power BI hierarchies missing when data model consu... - Microsoft Power BI Community After internal review, the Power BI team said this is an Excel issue and directed me to post here. If a Power BI model contains a DirectQuery or Dual mode table, and that same model also contains attribute hierarchies, those hierarchies are not accessible when the model is consumed through Excel. Example: Model with single table in import mode containing a hierarchy in Power BI Desktop Published model viewed from Excel. Hierarchy works fine in import mode! Model with single table in DirectQuery mode containing a hierarchy Hierarchy missing in Excel 😞 As we have many Excel users on our Power BI enterprise model and also rely on several hierarchies, this prevents us from optimizing our model with any type of aggregation or hybrid table. We are stuck with import on every table and cannot pursue any advanced refresh or query optimization strategies.Data model relations not working properly in power pivot
Hi when doing relations i had some strange results, although same when i did in power bi it worked i have 2 tables of customers one with unique values & one with duplicates, so when i made the relation from unique customer ids to duplicate customer ids, then when i did the pivot table by using data model, i used the customer ids from unique table & customer preferences from customer_preference table which contains duplicate ids, but it gave wrong results dont know why
Power Query Loads Table With Additional Blank Column
Every time I initially load Power Query output to a worksheet the table is always loaded with an additional column that is not in my data. For example, if the query I build has a table with 5 columns when I click Close and Load for the first time the output has 6 columns where the added column is blank and labeled "Column 1". I believe this only happens when I load it to an existing worksheet. Any idea why this is happening? I am loading the output to an existing blank sheet. Thanks in advance.
