Home

Resources and Community

40 Conversations

Latest Activity

Custom List Message Item

First I like to thank the community for attending MDIS 2017. It has been a great sucess and it was amazing to see MDIS sold out again (and double the amount of attendees from last time). The last 3 days have been amazing. We, the Excel team, are so greatf

... Read More
998 Views
2 Replies

Thanks for setting this up Olaf!

Dear team

Find attach pic i want to typw in one cell multiple number and its ahow automatically on another sheet on diffrent cells
Note that numbwr are not in series
66 Views
3 Replies

Open Visual Basic Editor

 

Insert New Module

 

Paste the VBA Code given below.

 

Hope you like.

 

Sub Macro1()
'
' Macro1 Macro
'

'

Dim a, b, c, d, i As Integer

    Range("H1"
... Read More

I am preparing a VBA enabled sheet. Soon you will get.

First I like to thank the community for attending MDIS 2017. It has been a great sucess and it was amazing to see MDIS sold out again (and double the amount of attendees from last time). The last 3 days have been amazing. We, the Excel team, are so greatf

... Read More
998 Views
2 Replies

Thanks for setting this up Olaf!

Microsoft Office add-ins allow you to make your solution a native part of Office on every platform across desktop, web, and mobile applications. Learn how to build an Office add-in, the new features we’ve recently launched and our future roadmap. This ses

... Read More
40 Views
0 Reply

You can use web services as data sources in Power Query/Excel and Power BI but to do so you need write some M code. In this session, you'll learn how to use the M Web. Contents() function to call web services to make GET and POST requests, how to handle a

... Read More
44 Views
0 Reply

Come learn about advances in Excel that help you bring more trust to your business critical work for those solutions that span across multiple spreadsheets and versions. Protect those spreadsheets with sensitive data and trust the workbook you're working

... Read More
45 Views
0 Reply

Your guide to the changes to the online and on-premise offering and capabilities for both.

 

Read More
32 Views
0 Reply

Learn how to develop your own customized forecasting models using advanced techniques in Excel based on real scenarios. You will learn about the new forecast function in Excel 2016, how to leverage Azure Machine Learning within Excel, as well as other adv

... Read More
79 Views
0 Reply

The Power BI, Excel, PowerApps, and Flow teams are excited to once again present the BI Power Hour. In this entertaining session, we will dazzle you with new demos that expose the lighter side of business intelligence and show off the flexibility and powe

... Read More
42 Views
0 Reply

Business leaders face the challenge of achieving unprecedented levels of productivity in their organizations, yet lack the inputs to understand the true behaviors that drive efficiency and engagement. That reality is changing. Microsoft is sitting on a go

... Read More
32 Views
0 Reply

Learn how Power Pivot simplifies data analysis. Topics include: multiple tables and relationships, editable linked tables, DAX formulas, custom calendars, and measure concepts, with a focus on demonstrating each of these capabilities.

 

Read More
50 Views
0 Reply

Parameters are one of the most useful features in Power Query/Excel and Power BI, and in this session you'll find out how you can use them to make your queries easier to maintain and more user-friendly. In addition you'll also learn how you can use parame

... Read More
32 Views
0 Reply

Power BI Desktop and Excel offer connectivity to a wide range of data sources, along with a market-leading Data Preparation environment, based on the Power Query technology. In this session, we will go over these capabilities, including several demos, to

... Read More
32 Views
0 Reply

Join this session for an informative introduction to the latest visualization capabilities in Excel 2016. Learn how the result can be visualized and shared.

 

Read More
68 Views
0 Reply

In this demo-rich session, you will learn how to use Excel's unique strength in Power BI to boost your business analytics and insights. Learn how to easily collect existing organizational data from Excel files into Power BI, create visually rich reports t

... Read More
278 Views
0 Reply

Hundreds of millions of users regularly perform data analysis in Excel. Over the last few years, Excel has modernized every step in the data analysis journey using technology shared with Power BI: you can build powerful data import logic, and advanced dat

... Read More
132 Views
0 Reply