Normalization 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.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."Never use your mouse" -- but I'm faster!
I saw this thread on Reddit, and I thought I'd ask the community here. Are you faster with Excel using keyboard shortcuts or using your mouse? Which do you prefer, or do you use both? https://www.reddit.com/r/excel/comments/a7dji5/never_use_your_mouse_but_im_faster/Congratulations to our new and renewed MVP's
Let me congratulate the following MVP"s. They really are what makes our community so strong and fibrant. If you like to learn more about our MVP program and what it takes to become one, see mvp.microsoft.com During the first 3 months of 2017 we have added 2 new MVP's. Gerardo Zuccalà Kenneth Barber Segundo Miguéns Romeu We have also renwed the following MVP's. Congratulations on your renewal and thank you for all the great contributions. Aki Ebisawa (海老澤 亜希) Boriana Plamenova Petrova Herve Thiriez Ingeborg Hawighorst Jinjia Xi (郗金甲) Liam Bastick LiMing Fa Mike Girvin Mourad Louha Purnachandra R Duggirala Tony Christopher De Jonker Toru Tanaka Victor Roman Castro Yolanda Cuesta
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.Conditional Formatting :) ... :(
I love the concept of Conditional Formatting and I try to use it frequently but its a love/hate relationship. Recently I upgraded from 2010 to 2016 as the new formulas (maxifs, etc) were a help in getting rid of some array functions. I was hoping that there would be updates to address the hate part of the love/hate relationship with Conditional Formatting to no avail. MS needs to take conditional formatting to the next step and make the entry/edit box for conditional formatting formulas work like a true cell with predictive functions, identification of errors in function construction, allow table references, allow the Find function to look in conditional formatting formulas, etc. I've wasted more time looking through conditional formatting to find invalid references and references to tabs or ranges where the name has changed that I care to discuss. Its time to bring Conditional Formatting up to a real usable feature.
