Sankey Charts, Tornado Charts, Word Clouds are coming to Excel along with many other Power BI Custom Visuals. Take a spin through these three chart types.
To learn more about custom visuals:
How to get a unique combination of all values in Excel columns B & D? Normally, use Advanced Filter or, Remove Duplicates. But today, how to use UNIQUE and CHOOSE to solve the problem.
Table of Contents:
(0:35) Advanced Filter for Unique Combinations
The icons for Rows & Columns in the Pivot Table Field List are backwards. They've been backwards for quite some time. Unless, it is actually a garden hose, spraying data across the top of the report… Thanks to Nicole in Appleton for that memory aid!
Office 365 customers will soon be seeing a new Data Types gallery in the Data tab in Excel. Convert stock symbols to a Stock Data Type. You can easily return price, CEO, Volume, and other statistics....
Mark a cell as a geography data type in Excel and you can use formulas to return fields such as: State, County, Population, Latitude, Longitude, or Mayor. This feature is new in Office 365.
The article for today's video is here: https://www.mrexcel.com/e...
Can you set up Excel Data Validation so that the choices in a second drop-down menu are dependent on the choice in the first menu? For example, if you choose Bagels, the answers might be Raisin, Tomato, or Everything. If you choose Pancakes, then the answ...
One of the 7 new dynamic array functions is RANDARRAY. In today's episode, I re-visit the model that I built for Excel Hash. That model used 200K cells with VLOOKUP, RAND, and NORM.INV. In today's video, replacing the formulas with a single formula. Recal...
In today's video: replacing a pivot table with three dynamic array formulas.
(0:13) The official name for the new arrays are Dynamic Arrays, not Modern Arrays
(0:23) I've written a 60-page e-book documenting 30 ways to use them. For more information: htt...
New Excel Features announced at Ignite 2018 include the Picture Transparency feature. If you have a photo in your Excel spreadsheet and want to see what is behind the picture, it is now easy using the new setting in Office 365....
This covers the Excel SEQUENCE and RANDARRAY modern array functions.
=SEQUENCE(Rows, Columns, StartAt, Step By)
Do these Excel function because people can't figure out how to have the Fill Handle make 1 drag to 1, 2, 3?
No! The SE...
The next Excel modern array function introduced at Ignite 2018 is the FILTER function. Use =FILTER(array, Include, [value_if_empty]). This is one of the new functions that is entered in a single cell, but the results spill into adjacent ranges....
This part 2 on a series on Modern Arrays in Excel. These formulas were announced at Ignite on September 24, 2018.
This video covers SORT and SORTBY.
Topics in the video:
Sort Excel data with a formula
Use SORT to sort a range
Use SORTBY to sort one colum...
BREAKING NEWS: Just moments ago at the Ignite Conference in Orlando, Microsoft unveiled a new calculation engine for Excel. A single formula can now spill into adjacent cells, essentially returning an array of values without anyone ever pressing Ctrl+Shif...
Build 1810 of Excel introduces Threaded Comments and they are cool. You can now have a conversation about each cell in Excel. Threaded comments will show date, time, author, and the comment.
Jump to these sections:
Jon Peltier and Excel.Uservoice (0:14)
Will Asteroid Bennu strike the Earth in the 2182-2198 time frame? Using Microsoft Excel to model Bennu's path 10 million times. Even after OSIRIS-REx, we might learn that we are at greater risk than we think now.
This is my entry in Oz do Soleil's #ExcelH...
Build a new tab in the ribbon with your favorite commands
Use lots of Groups with less than 6 icons each
Make sure your tab is above Home so it is default
Thanks to Ronnie W in Frisco for these tips,
To download this workbook: https://www.mrexcel.com/do...
New in Office 365: The ability to format individual cells in a pivot table and have the formatting stick. Added to Office 365, Version 9029.2xxxx or later
Right-click the cell and Format Cell or simply apply the formatting.
The cell formatting will stick,...
How to move focus to an Excel slicer using only the keyboard?
Can you use the keyboard in Excel to activate a slicer? Yes!
Alt, H, FD, O to enter Select Objects mode
Tab twice to get to first object
Once a slicer is selected, you can move the slicer with ...
Geography and Stocks are the first types of Linked Data Types in Excel
This feature is exclusive to Office 365 since it requires downloading online data
Type some cities, select the cities, mark as Geography
Hover over icon to see data card
Easy checkmarks in Excel from Jack Whipple
Rather than use P in Wingdings 2 font, you can use Icon Sets
1 = Green Checkmark: Done
0 = Empty Circle: Still to Do
-1 = Yellow Dash: Not required this year, but keep it on the list for next year
To start, Home,...
Ctrl+Wheel Mouse will increase the size of the grid in Excel
But it does not increase the size of the dialog boxes
When I am presenting in a big room with a screen that is too small, the magnifier helps
Press Windows key and Plus Sign
Three types of magni...
Susan in Melbourne wants to create a pivot table that shows text in the values area.
Typically, this can not be done. But it is possible with the DAX formula language.
Format as Table using Ctrl+T
Insert, Pivot Table, Add This Data to the Data Model