ONLY CERTAIN FUNCTIONS AVAILABLE TO OFFICE USERS
I am a long time(30+ years) user of Microsoft products, both at home and at work. I am also a new father and need to work from home to support my family. I recently purchased two copies of MS Office, one for my desktop and the other for my laptop, because my profession requires the interpretation of large amounts of data and I wanted to have the most current version of Excel. To my dismay the "=SORT" function and other features are not included in Excel for Office and I'm therefore stuck with two copies of Office that are essentially useless to me. I thought this was an error on MS' part so I called the support line and was greeted by a recording that said I would be unable to get live help unless I was a monthly subscriber, this after I had just purchased their products! After going through the prompts and acting like I was going to buy something else I was finally able to speak with a helpful woman who had no idea that =SORT isn't available across the Excel platform. She put me in touch with a supervisor who also didn't understand why this wasn't offered across the board. He, the supervisor, was kind enough to offer me a 3 month trial to the 365 product so I could at least continue to do my job until I figured out how to (hopefully) get a refund from the Office vendor and figure out what to do. However, once installed that too didn't work! So after more than 2 hours on phone with 3 different people and $230 spent on software that doesn't do basic tasks, I'm sitting here waiting for yet another person to get in touch with me and try to figure out what's going on. I've heard many people talk about how ruthless Microsoft is to upstarts that could pose a threat. I didn't know they applied similar tactics to customers in an effort to up-sell them to their subscription model. To say I'm disappointed is an understatement. As of last quarter, Microsoft had $136bn in cash. Why would they try to nickle and dime hard working people who pay for their software? Why not make essential features and functions available to people like myself who paid hundreds of dollars for their products? What a shame.
Rookie user; need help please
New user, apologies for asking for help for IF statement with several conditions. If cell value is<7, then return "purple fill" of the cell, and if cell value is 7-8:59, then return "green fill" of the cell, and if cell value is 9-12:59, then return "yellow fill" of the cell and if cell value is 13-15:59, then return "orange fill" of the cell and if cell value is >16, then return "red fill of the cellNormalization of data
Hey, i am stuck in normalization of data whose values are between 0-1. The function STDEVA and its associates assumes data to be a population stat which in my case is not. I use STANDARDIZE function to normalise the data. Is there a any way to normalize data ranging 0-1 in excel? I would appreciate the help.
Operational Model help
Hi Guys, I'm a final year college student, and in one of our modules, we have to create an operational model in excel. I was just wondering if anyone has any templates or articles about creating these types of models. My class and I have been looking all over the internet for examples for ideas and have come up short. Any help would be great!Excel and Power BI – better together
Great new feature (preview) is introduced in Apr update of Power BI Desktop. Now we may connect directly to the dataset published in the Power BI service. Other words – create and support the data model in Excel, and generate visualization in Power BI Desktop connected to such model. Exactly the way I prefer to do.Hybrid model refresh - it's worth to read the documentation
That's not the question, just to share my experienceif it'll be useful for someone. I had Excel data model published on Power BI with two queries(actually much more, but these two are in questions) - Q1 which pick-ups data from on-premisesSQL server, and Q2 which takes the data from Excel file published on SPO At the end of first one it was like =Table.Combine(Source, Q2), other words query to on-premises data and right after the to cloud one. It worked fine before Dec previous year. After that manual refresh worked, schedule one failed to refresh. More detailed investigation shows what oAuth2 request token (SPO) works fine (by default lives an hour), but ADFS refuses to give refresh token. Finally I found this articlehttps://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshooting-power-bi-personal-gateway/ which explains the bug in Power BI services. The solution was to extract Q2 from Q1, i.e. Q1 takes only on-premises data, Q2 only cloud one, and new Q3 which appends Q1 to Q2 gives the result. With such separation scheduled refresh works.
