Bringing Immersive Reader to Excel for the web
We’re excited to announce that Immersive Reader is now available in Excel for the web! Immersive Reader lets you customize your reading experience to be most comfortable to you, resulting in increased reading speed, increased comprehension, and fewer errors while reading.
Introduction to the Data Science Process
We are excited to collaborate with Club for the Future and introduce your students to the data science process. In this free and interactive Excel based curriculum, students use data and a step-by-step data science process to simulate the decision-making process that data scientists in a command center use to give a Go/No-Go signal for a rocket launch.
How to trigger in Office Read-only yellow ribbon message?
Hi, Is there a way how i can show/trigger in Office (Word, Excel) a yellow ribbon message "Read-only This document was opened in read-only mode..."? I have my custom WebDAV server where i serve my files (Word, Excel files) Already tried: - To return 403 Forbidden on LOCK. (didnt worked) - Removed MS-Author-Via Header (Didnt worked) Also is there a way how i can show that Session is expired?
Merge multiple XML files (with same layout) into 1 merged XML file (addition of data needed)
Hi, I don't have any experience with XML and I don't seem to have found any other discussion that could help me further. I would like to combine multiple XML files that have exactly the same lay-out but different data (different multiple amounts) into 1 file that keeps the original layout but adds up the amounts of the different data rows. My idea was to use power query on the folder where I will monthly download the individual XML files, automate the merging process including the necessary additions and export the 'merged' XML file. Is that possible and if yes any instructions on how I could do this? What would be the necessary steps in setting this up? Thank you in advance!
Combinaison de sommes
Bonjour, Je travaille actuellement sur Excel, et je cherche un moyen de trouver une combinaison de sommes parmi une liste définie afin d'obtenir le résultat que je souhaite. Après avoir lu plusieurs articles, je dois normalement avoir accès à l'outil "Gestionnaire de noms". Il doit se trouver dans la partie Formules mais je ne le vois pas. Quelqu'un pourrait m'expliquer à quoi serait-ce dû ou bien une autre méthode pour ce que je cherche ? Merci d'avance.
Excel - percentage
Hi all, I've got a table with some data where few columns are different percentage. I am pasting this percentage every month from my source where are these formatted as numbers. So for example I have 45 in my source and want to copy that and paste it to my excel table as 45%. However, when I do this it displays as 4500% Is there a way how to paste it as a 45% without the need of formula or changing the source to 0.45? Than you for any adviseExcel - Enter Numbers in a column
Excel VBA macro-Need help to correct macro-number rows in a column I am a novice on this site and Excel VBA within macros. Trying to finish the macro without errors. Using pick button to run the macro. Fill in the yellow column with quantity, math is done with columns B10*G10= in H10 Go to the Next sheet Move all rows which have B column greater than 0 - all works fine Start of macro works fine - remove all blank rows if Column B is blank. The problem is to renumber column A rows after all blank rows are deleted. This is what I want the result to be: Here is the current macro: Sub Button1_Click() Dim LastRow As Long, Firstrow As Long Dim r As Long With ActiveSheet Firstrow = 10 LastRow = .UsedRange.Rows(.UsedRange.Rows.Count).Row For r = LastRow To Firstrow Step -1 If .Range("B" & r).Value = "" Then .Range("B" & r).EntireRow.Delete End If Next r End With 'These attempts give me errors or just doesn't work '___________________________ 'With Range("A10:A" & Cells(Rows.Count, "B").End(x1UP).Row) ' .Value = Evaluate("Row(" & .Address & ")") 'End With '___________________________ 'Range("A10:A" & Range("B" & Rows.Count).End(x1Up).Row).DataSeries , x1Linear '___________________________ 'Range("A10).AutoFill Range("A10:A" & Range("B" & Rows.Count).End(x1Up.Row), x1FillSeries End Sub Can't seem to paste. Will attach file. Note: Excel version 2010 Thanks in advance, from Frustrated
Excel Makro Zellen fortlaufend einfügen
Hallo liebe Community, ich hätte folgende frage an euch ich habe ein Tabelle und möchte das ich mittels Makro eine Muster Zelle am ende der Tabelle einfügen kann beim ersten mal klappt es super die neue Zelle landet bei M beim nächsten mal landet sie allerdings wieder bei M ich hätte sie aber gerne bei N und so weiter. ich danke im voraus der code des Makros lautet : Sub Makro1() ' ' Makro1 Makro ' ' Sheets("Tabelle2").Select Columns("A:A").Select Selection.Copy Sheets("Tabelle1").Select Columns("M:M").Select ActiveSheet.Paste End Sub
