excel
19 TopicsFrom the Classroom to Las Vegas: MVP David Brown and the Excel Esports Revolution
What if crunching numbers could land you on a championship stage in Las Vegas? Welcome to the Microsoft Excel Collegiate Challenge (MECC) - where spreadsheets meet esports, and students battle for the championship in Las Vegas! Meet the Visionary: MVP David Brown When the ModelOff competition closed, David Brown, Microsoft MVP and professor, saw a gap for his students. “ModelOff closed and left a void for my students – I had been using it for years as extra credit and enhancement for honors students,” David shares. So, he rallied the Excel community and built MECC to make Excel fun, competitive, and accessible for everyone David’s advice for anyone starting out? “Change expectations – it’s tough to get students involved when they are so busy. And starting at an easier level – simpler, short challenges – getting more people involved that way. Also, letting myself know how much work it was going to be. Although, I am not sure I would have done it if I knew that, and I am glad I did do it.” own (left) with the 2024 MECC individual champion, Benjamin Weber (center) MECC by the Numbers 8,000+ students from 800 schools across 110+ countries participated in MECC 2024 - talk about a global spreadsheet showdown! The Las Vegas Finals welcomed 100+ students from 13 countries for the in-person championship. In 2022, MECC featured 2,730 students from 93 countries and 596 universities/colleges. For 2025, the total prize fund for MECC is $34,050 USD! Finals events include individual and team battles - recently, 64 individuals and 21 teams competed in semi-finals, with 12 individuals and 4 teams advancing to the grand finals. MECC events are streamed live, with tens of thousands watching online and millions of views after the event What Makes MECC Special? Epic team battles are a game-changer. “The team competition is a game changer. It’s so much more than just splitting up a case and solving separate parts. The best teams work together to build a solution together, help each other better understand the problem, and mitigate risks that come up in individual modeling. I think the team competition is the future of Excel Esports,” says David. And the puzzles? “Anything with recursive formulas - maps, capacity estimations (more financial modeling), how important Lambdas. There’s also a famous ‘Lana Banana’ case that may at first seem impossible to solve, until you realize there’s a backwards recursion method to solve it, which is so elegant and beautiful. That was a really great case (but at the pro level),” David recalls. Real-World Impact MECC isn’t just fun - it’s a launchpad for careers. “Yes, multiple students who have secured internships and jobs through our sponsors and many more who use MECC as talking point in interviews,” David notes. Professors are integrating MECC into coursework, and badges earned in competition help students stand out in interviews. MVPs Powering the Community David Brown and other MVPs (plus non-MVPs!) jump in to coach, judge, and energize the Excel community. Their support makes MECC special and helps students reach new heights. As David says:“There is an amazing Excel community – MVPs (and non-MVPs) so willing to help and get involved.” Coaching & Mentoring: MVPs like David Brown, Diarmuid Early and Jon Acampora coach student teams, share strategies, and help competitors level up their skills. Their mentorship and expert advice are invaluable for preparation and competition. Judging & Event Leadership: MVPs serve as judges at MECC finals, using their deep Excel expertise to evaluate solutions and provide feedback. Their involvement elevates the finals and reinforces the MVP program’s role in shaping the future of Excel education and esports. For example, Oz du Soleil and Giles Male’s presence as commentators elevates the finals by increasing visibility for Excel as a career skill and reinforcing the MVP’s role in shaping the future of Excel education and esports. Community Engagement: MVPs energize the Excel community by organizing panels, Ask Me Anything (AMA) sessions, and onboarding initiatives, creating a vibrant, supportive learning environment. Advocacy & Visibility: MVPs bring attention to MECC and Excel esports, inspiring new participants and building awareness of the power of Excel in modern careers. Shaping the Future: MVPs are at the forefront of new trends, integrating AI and Copilot into competitions, and their feedback helps shape the direction of MECC for future generations. Excel Esports: What’s Next? AI and Copilot are entering the mix. “Right now, just can use AI to ask general questions, kind of like advanced googling. It’ll be interesting to see how this develops,” David predicts. “I think it would be really neat for competitors to have to be knowledgeable enough about the AI and what it does well to know what parts of problems to give it and what parts to handle themselves.” David predicts dedicated AI-assisted and AI-free brackets, where knowing how to leverage AI becomes a skill in itself. Want to Feel Like an Excel Pro? Even if you never step on the MECC stage, David’s top tip is to master keyboard shortcuts in Excel! “Keyboarding – navigating the grid with the keyboard (and your desktop – Alt-Tab is a huge tool that still shocks students) and use shortcuts – you’ll speed up your workflow and you’ll start to feel like an Excel Esports athlete while you work – who doesn’t want to feel like a pro?” Ready to Join the Fun? Visit the Microsoft Excel Collegiate Challenge website for details, upcoming events, and ways to get involved. Check out highlights and tutorials on the Microsoft Excel Collegiate Challenge YouTube Channel for jaw-dropping moments and expert walkthroughs. Follow the MECC Championships on their Livestream: December 02, 2026 - MECC Semi-Finals on YouTube December 03, 2026 - MECC Finals on YouTube While only students can compete in MECC, professors and Excel enthusiasts can get involved as coaches, judges, or mentors to support the event and its participants. Ready to get involved? Start your MECC journey - Students can sign up today to complete assignments for certificates, practice extra challenges, and compete online, while educators can join as College Ambassadors to help innovate student learning.144Views0likes0CommentsBringing 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.4KViews0likes0CommentsIntroduction 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.41KViews3likes4CommentsHow 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?1.9KViews0likes2CommentsMerge 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!2.3KViews0likes0CommentsCombinaison 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.495Views0likes0CommentsExcel - 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 advise2.3KViews0likes3CommentsExcel - 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 Frustrated1.6KViews0likes2CommentsExcel 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