How to Visualize Age/Sex Patterns with Population Pyramids
Check out this use case in Excel of a state public health agency that wanted to depict how many males and females were diagnosed with a disease and the age at which they were diagnosed. In other words, there were just two simple variables: age and sex. Read more about it.New book by Alberto Ferrari and Marco Russo
Just found what announced few months ago Analyzing Data with Power BI and Power Pivot for Excel (Business Skills) is finally published. So far had no chance to read it all, but on the first glance it will be another must book for everyone who works with DAX, as famous “The Definitive Guide to DAX”. Anyway, if you know these authors there is no need in advert, just their names.How one artist brought her vision to life using Excel spreadsheets
Landscape architect by day, Microsoft Excel artist by night. Australia native Emma Stevens isn’t your average artist. She uses spreadsheets to create skyline imagery out of text. Inspired by the Melbourne skyline, Stevens began to create her artwork in a spreadsheet by building an image of the city with words through a spreadsheet app. She added an image of the Melbourne skyline to the background of a spreadsheet, typed the word “Melbourne” in the cell rows, and divided the columns to define each building. Using column breaks and letter shading, Stevens gave each building depth. From a distance, the image looks like the Melbourne skyline, but up close it becomes clear that the name of the city makes up the structure of the entire image. Learn more about it in the Microsoft 365 blog.Little list of some cool Excel websites
Wanted to share a list of intresting links I have collected over time. I will try and keep the list updated. Hope it is usefull. Social https://www.facebook.com/exceltricks https://www.facebook.com/ExcelEasy https://www.facebook.com/microsoftexcel https://www.facebook.com/exceltricks.de https://vine.co/office https://www.instagram.com/office/ https://twitter.com/ExcelEasy https://twitter.com/msexcel https://twitter.com/MrExcel https://twitter.com/r1c1 https://twitter.com/excelisfun https://twitter.com/TomUrtis https://twitter.com/powerpivotpro https://twitter.com/ddalgleish https://www.tumblr.com/search/excel Forums http://www.excelforum.com http://www.mrexcel.com/forum/ http://stackoverflow.com/tags/excel/topusers http://www.excelguru.ca/forums/forum.php https://www.reddit.com/r/excel/ http://www.msofficeforums.com/excel/ http://chandoo.org/forum/ http://www.thecodecage.com http://www.vbaexpress.com/forum/forum.php http://superuser.com/questions/tagged/microsoft-excel http://answers.microsoft.com/en-us/office/forum/excel LinkedIn Excel and VBA Users Financial Modelling in Excel Excel Developers Excel Blackbelts 黒帯 MS Excel and VBA macros Excel Enthusiasts MS Excel and VBA macros Excel Trainer Excel Gurus Video https://www.youtube.com/user/ExcelIsFun https://www.youtube.com/user/officevideos https://www.youtube.com/c/billjelen Others http://www.ozgrid.com http://www.allexperts.com/el/excel http://paper.exceldailynews.com/ Microsoft https://blogs.office.com/excel/ http://excel.uservoice.comAnnouncing the general availability of the Microsoft Excel API to expand the power of Office 365
Today, we are pleased to announce the general availability of the Microsoft Excel REST API for Office 365 Nowdevelopers can use Excel to power custom apps. Excel is an indispensable productivity tool; users across all industries and roles embrace it. It is used for everything from simple task tracking and data management, to complex calculations and professional reporting. With our new interface, Excel for Office 365 can extend the value of your data, calculations, reporting and dashboards. The Excel REST API release is a continuation of our journey to make Office an open platform for developers. The Office developer framework uses modern web development standards, so developers can build smarter apps that operate as part of Office on mobile, web and desktop platforms. The new Excel interface is exposed through the Microsoft Graph to access to intelligence and insights from the Microsoft cloud. See the blogs post here.
