cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Excel Blog
Copied!
Home
Options
31.1K

Announcing Office Scripts (Preview)

weylove on 01-07-2020 08:18 AM
13.1K

Sheet View is generally available

Avani_Reddy on 11-25-2019 04:15 PM
Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to s...
11.4K

Create data-driven Visio diagrams directly in Excel

Shashank Gandhi on 11-04-2019 07:46 AM
We are excited to announce a new way to create impactful Visio diagrams from your data directly in Excel with the public...
21.6K

Excel Announcements @ Ignite 2019

Jee Soo Han on 11-04-2019 06:00 AM
Here's a look at the Excel announcements that will be shown throughout the week at Ignite 2019.
1,894

Modern Excel at Microsoft Ignite 2019

cuong on 10-31-2019 08:54 PM
Microsoft Ignite is next week, and our Excel team will be on-site with many exciting stories to share. If you’re attendi...
9,456

Fuzzy Matching in Power Query for Microsoft Excel

JohnMacDougall on 10-08-2019 01:07 PM
Power Query in Microsoft Excel can help match data even when there isn't an obvious common pattern.
12.6K

Get & Transform (Power Query) in Excel for Mac - Phase 1

Guy Hunkin on 10-02-2019 02:13 PM
You can now refresh Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files, and author queries with VBA.
4,808

Conditional Number Formatting

Liam Bastick on 09-17-2019 08:56 AM
How to get smarter with number formatting using conditional formatting in tandem.
618K

Announcing XLOOKUP

Joe McDaid on 08-28-2019 09:00 AM
We are excited to announce XLOOKUP, the successor to the iconic VLOOKUP and HLOOKUP functions.
42K

Fantasy Football Cheat Sheet & Draft Template for 2019

Sam Radakovitz on 08-22-2019 09:00 AM
Now that the NFL preseason is off and running, fantasy leagues are starting up! Get the edge with our player analysis sh...
4,053

Excel for Artists: A Size Calculator - by Ingeborg Hawighorst, Excel MVP

Ingeborg Hawighorst on 08-19-2019 01:31 PM
Excel can be a handy tool for artists when comparing and visualizing the size of artwork. This easy-to-use Excel Size Ca...
2,344

Creating an Objective Forecast - by Liam Bastick, Excel MVP

cuong on 07-30-2019 06:51 PM
"For many, it’s that time of year again when budgets need to be dusted down and re-vamped. Those in finance spend sleepl...
12.7K

How We Built the Women’s Soccer Prediction Spreadsheet in Excel

David Monroy on 06-03-2019 08:11 AM
Check our prediction model for the upcoming Women's Soccer Championship!
13.8K

Insert Data from Picture generally available on the iPhone Excel app

MS Excel Team on 05-29-2019 09:00 AM
Today, we are excited to bring Insert Data from Picture to iPhone users, now supporting 21 languages for both versions o...
8,806

Insert PivotChart is available in Excel for the web

Itai Goldstein on 05-19-2019 03:52 AM
We listened to your feedback and provided the ability to visualize the data in PivotTables through PivotCharts.
2,044

Live now, full session catalog for Microsoft Business Applications Summit 2019

cuong on 04-24-2019 01:17 PM
Time to get excited – the full session catalog for Microsoft Business Applications Summit is here.
2,222

Microsoft Business Applications Summit 2019 - Session Catalog Preview

Theresa Estrada on 03-27-2019 05:05 PM
The first look at the session catalog is live! Check it out to see what’s in store for this year’s event and start getti...
22.7K

How We Built the College Basketball Prediction Spreadsheet in Excel

David Monroy on 03-17-2019 09:01 PM
We love sports in the Excel team (Soccer, Football, all sports), and now is the time to dive into basketball, just in ti...
25.2K

Excel Dynamic Array Improvements

Joe McDaid on 02-19-2019 11:27 PM
Since announcing dynamic arrays, we’ve received an overwhelmingly positive response from the community. Being a fundamen...
1,967

Microsoft Business Applications Summit is back - join us June 10-11 in Atlanta!

Theresa Estrada on 01-25-2019 02:18 PM
Join the Excel team for sessions at the Microsoft Business Applications Summit, as well as a full Pre-Day with @MrExcel!...
4,259

Excel ModelOff 2018 competition encourages a new generation of users

MS Excel Team on 12-05-2018 12:00 PM
The Microsoft Excel user community never ceases to amaze us. Excel users are so passionate about the solution and love e...
2,823

Excel's United States Senate Map

Michael Molyneaux on 11-06-2018 02:54 PM
  Using Dynamic Arrays and Map Chart, model who will win the US Senate. 
13.8K

Excel for Mac - customize your keyboard shortcuts

Steve Kraynak on 10-22-2018 11:33 AM
Update to the latest version of Excel for Mac to customize your keyboard shortcuts
3,873

Excel @ Ignite 2018

MS Excel Team on 10-15-2018 01:05 PM
For anyone looking to review content or catch up on-demand, here you can find everything we covered at Microsoft Ignite!...
47.5K

Excel performance improvements now take seconds running Lookup-type functions

Prash Shirolkar on 09-25-2018 06:00 AM
This is our second wave of Excel O365 performance improvements after our first Sept ’17 one, to reinforce our commitment...
93.4K

Preview of Dynamic Arrays in Excel

Joe McDaid on 09-25-2018 06:00 AM
With dynamic arrays, you can write a single formula and get an array of values returned. One formula, many values. This ...
5,308

Microsoft Ignite 2018 Excel Sessions

MS Excel Team on 09-18-2018 10:06 AM
Microsoft Ignite is quickly approaching! But which Excel sessions should you attend?
3,557

Excel Table Talk Episode 7: New Data Types

Blake T Walsh on 09-14-2018 11:54 AM
John sits with me to explain rich data types - video embedded in the post. John sits with me to walk us through some of ...
8,405

🏈 Fantasy Football Draft materials brought to you by Excel! 🏈

Blake T Walsh on 08-23-2018 03:30 PM
🏈 Now that it is August, the NFL preseason is in motion. Now is the time to be analyzing how your favorite players are ...
33.4K

Excel Table Talk Episode 6: Improvements to Excel for Mac

Blake T Walsh on 08-15-2018 12:11 PM
Thumbnail for the Excel for Mac Table Talk videoSteve sits with me to show off some of our latest improvements to Excel ...
Latest Comments
Sergei Baklan
in Preview of Dynamic Arrays in Excel on 01-24-2020
@Christine Green , of course Microsoft knows better, but that's my vision: - DA only now (in Jan) appeared on monthly channel. Not sure it's 100% covered, but close to that base on feedback. - if nothing critical next will be Semi-annual Targeted updated in March Thus Semi-annual will be updated onl...
0 Likes
Christine Green
in Preview of Dynamic Arrays in Excel on 01-24-2020
Most users in my tenant are on the semi-annual channel. I thought semi-annual channel was updated in January. Would these features be expected by end of month? Thanks!
0 Likes
AlexJerabek
in Announcing Office Scripts (Preview) on 01-23-2020
@PerryPicker Office Scripts are providing an automation experience for Excel on the web, not replacing VBA macros. VBA remains the best solution for automating tasks in Excel for desktop. We hope to eventually grow the capabilities of the Office Scripts platform to match what VBA currently offers.
1 Likes
AlexJerabek
in Announcing Office Scripts (Preview) on 01-23-2020
@AshaKantaSharma Office Scripts for Excel on the web is currently deployed, but not yet available to all tenants. We are gradually rolling out the feature to everyone with Office 365 E3 and E5 licenses over the course of several weeks. As long as your admin has enabled the feature, you'll have acces...
1 Likes
dax-crx
in Get & Transform (Power Query) in Excel for Mac - Phase 1 on 01-23-2020
Tried to refresh Power Query, but got an error on my Mac: "[DataSource.Error] Permission denied Permission denied" The query supposed to download JSON data using Web.Contents function (https://docs.microsoft.com/en-us/powerquery-m/web-contents). Everything works fine on Windows. Excel for Mac, versi...
0 Likes