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 cell
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.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!"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/Can I create a macro of swapping cells?
I have a project where I will have to do a lot of cell swapping like below where I swapped the 3 cells on the left that are highlighted with the 3 cells to the right of it Because I have so many, I tried to record a macro of the process, but it did not work, possibly due to user error. Is there a way to put cell swapping in a macro?
