online

In Excel desktop you can use the formula =CELL("filename",A1) to extract the filename of the workbook. However when the workbook is opened in Excel Online, it only returns #VALUE . I have already had to modify the complete formula I use so it caters for Excel desktop opening a local file...

I poked around online and couldn't find the answer (only others facing the same problem with no solution), but I'm hoping against hope there is one... Control+tab and control+shift+tab used to allow navigation between workbooks in an (in retrospect) incredibly predictable fashion. Now, in 2016...

I am new to Power Query and would appreciate it, if someone could recomend a few online tutorials as well as online training on this topic

Hello, I'm trying to find a way to have a PowerPoint slide contain a linked Excel Worksheet that is housed on the cloud so that we (team of peers) no longer have to send the worksheet in tow with the presentation every time we email it. I accessed my O365 One Drive acct. which my company...

I would like some recommendations of some online Excel training (intermediate & Advanced) as well as Power Pivot & query online training it would be appreciated if someone can recommend any (paid or free)

Hey everyone, I'm looking to figure out a way to have a cell B1 time stamped when cell A1 changes. I know how to do this through VBA, however I need this done with excel online. I have a work book that has 40 users that I need to know when they change a cell that's correlated to them. Any...

I recently created an excel workbook that contains a user form that opens as soon as the app opens. This works fine on my desktop app but it appears to not be working when it opens in the excel online version. I basically have VBA code: Private Sub Workbook_Open() ufmTripSignup.Show End Sub...

I was wondering if someone could help me retrieve data from an api from http://www.coinapi.io Does this require VBA? If not, will VBA cause data retrieval to be less sluggish? I have tried looking online for the answer, but keeping running across complicated vba explanations.

Hi guys, I have problems of round up function and would like to ask for help. I have a lot of data needed to be auto round up. 90,91,92,93,94 - all round down to 90 95,96,97,98,99 - all round down to 95 I have tried to search online and tried by myself in excel but couldn't find the solution...

Hi guys, Great forum, I found many answers of great help here :). I now have one issue which I can't find a way around it: In one cell I have: ='https://www.[..]/[MBSS_DATA_OCT17.xlsx]Table 10.2'!$C$18 Which gives me the value on cell C18 of that online excel file called...

Some Background We provide a software system to organisation to manage their grant making processes. Our online system removes laborious paper centric practices and moves this all online. When a client signs up with us, we need to import a history (3 years) of their grants so that when...

Hi All: I've never used Advanced Filter and I'm having trouble getting the results I want. Here's my problem - I have a list of about 12,000 SKUs along with their price and description in columns D,E,F. I need to remove about 2,000 of those SKUs from the original list and I have those SKUs...

Hi all! I'm having some trouble trying to recover a number of images from an online server. I can manage to insert an image knowing it's absolute path + filename, but I just know the path.. The name of the *.jpg that's inside each folder is arbitrary, I just know that inside each directory...

Hi all, trying to help daughter with this basic excel formula to apply to all of column M =IF(K1>=L1,"Y","N") but I don't want to return a value where L1 is blank. I apologise for such a basic question, but have been searching & trying code from online without success and my daughter is...

Hi I wanna make/find the ultimate BlackJack software to beat online live BlackJack. What I want it to have: Let's you input: - All the relevant rules for the online casino in question - You can press a button of card value and suit and register it as it is dealt via buttons - True count and...

Hi Guys, First of all this is great forum, before opening this thread i already searched around and found some formulas that has helped me tremendously. I will be opening few more threads one after another to make things easy on my tiny brain. as of now I want to do the following: I have List...

Hi all Can anyone recommend Excel Tests that are online (preferably free) for beginners and intermediate. Part of a job I am recruiting for, requires a certain amount of Excel Knowledge, I am ok, but not great. So need some assessment tool, that will give me results to go along with their CV...

Hi all, I don't understand macro at all but I want to learn it. Can you pls let me know the easiest way to learn macro online? Thanks for the help in advance. Regards, Harshad

Hello Experts, I am using Excel Online/Web App for the first time. I am trying to insert a Wingding character into a cell. I am copying the character from Excel 2010 and pasting it into Office 365. Since Excel Online doesn't support the Wingding font (as best as I can tell), the character...

Is this resource only available online now?