Home

Resources and Community

46 Conversations

Latest Activity

Custom List Message Item

If you’re new to Excel, or even if you have some experience with it, you can walk through our most requested features in this tour. With real-world examples and helpful visuals, you’ll be able to sum, fill, sort, filter, and pivot like a pro. Download the template now. 

... Read More
399 Views
10 Replies

This is amazing! My mom could even learn Excel with this interactive spreadsheet. Thank you. (Well, OK, realistically my 84-year-old mother has no idea what a spreadsheet

... Read More

useful info but it didnt answer what i was looking for, how do i transfer data from a 2017 workbook to a 2018 workbook? 

This is really helpfull! Thank you for sharing the link!

Have a great day!

Kind regards,

Renate

Good Morning,

 

I looked throught your document but unfortunately it didn't help me. In fact, i have a very big database and I would like to delete the rows in which some c

... Read More

Perhaps to keep on the top with the title "Please check this before ask the question"...

 

Hello readers!

Microsoft Excel changes the data on one's spreadsheet permanently after one creates a scenario and shows it. How can the spreadsheet not be changed permanently after showing a scenario?

I am currently using Microsoft Excel 2010 to learn Excel

... Read More
46 Views
4 Replies

V.K.,

 

maybe your spreadsheet uses RAND() or RANDBETWEEN() in formulas.

 

If you’re new to Excel, or even if you have some experience with it, you can walk through our most requested features in this tour. With real-world examples and helpful visuals, you’ll be able to sum, fill, sort, filter, and pivot like a pro. Download the template now. 

... Read More
399 Views
10 Replies

This is amazing! My mom could even learn Excel with this interactive spreadsheet. Thank you. (Well, OK, realistically my 84-year-old mother has no idea what a spreadsheet

... Read More

useful info but it didnt answer what i was looking for, how do i transfer data from a 2017 workbook to a 2018 workbook? 

This is really helpfull! Thank you for sharing the link!

Have a great day!

Kind regards,

Renate

Good Morning,

 

I looked throught your document but unfortunately it didn't help me. In fact, i have a very big database and I would like to delete the rows in which some c

... Read More

Perhaps to keep on the top with the title "Please check this before ask the question"...

 

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
198 Views
4 Replies

Hi Olaf.

Enjoyed the Video. Thank you for sharing it.

 

Can you recomend so called "full blown courses on DAX" as referenced by Mr. Dickerman ?

 

Do you knwo who is teaching D

... Read More

Next month I will talk to Marilyn Haris about Charting in Excel. 

 

Read More
238 Views
0 Reply

I've been using a SUMIF and COUNTIF function to count the number of times months occur. My reference formula is this:

 

=COUNTIF('PNL'!$F2:$F189,"Sep 2018")+COUNTIF('Misc'!$F2:$F189,"Sep 2018")

 

I made a typo on one of my sheets and wrote "Sept 2018". I noti

... Read More
55 Views
1 Reply

Hi

 


Perry Rakhra wrote:

In conculsion, the function above counts both "Sep 2018" and "Sept 2018". What's going on here?


Type Sep 2018 in a cell and Sept 2018 in another cell

... Read More

This month I talk to @Carlos Otero about Get & Transform (Power Query) and the Data Model (Power Pivot). 

 

 

 

Read More
2,717 Views
6 Replies
colum i depending on colum j
Good morning sir. i hope you will help me is this way: i would like to count criteria for exemple in colum j dependind on colun j, how can i do it
Congratulations Ingeborg! Great Show Olaf - much better than anything on TV.
Great Show. Looking forward to Episode 3.

Hi Olaf,

 

Do you in Microsoft consider the possibility to add Power Pivot to all versions of Excel? Taking into account

- you in any case has the engine inside the Excel;

-

... Read More

I need to print a page of different labels, not one at a time or all the same.

38 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
127 Views
1 Reply

Less discussed about the Excel topics, however quite useful in corporate environment

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
117 Views
5 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
1,342 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
56 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
117 Views
0 Reply

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

 

Read More
58 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
164 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
73 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
45 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
156 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
71 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
161 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
785 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
185 Views
0 Reply

If you're just starting to dig into the newer versions of Excel, this session will help you learn some nifty tricks and unlock the potential of powerful features. Come learn about Conditional Formatting, Charts, and PivotTables to get more done in less ti

... Read More
172 Views
0 Reply

Let me congratulate the following MVP"s. They really are what makes our community so strong and fibrant. If you like to learn more about our MVP program and what it takes to become one, see mvp.microsoft.com

 

During the first 3 months of 2017 we have add

... Read More
95 Views
1 Reply

 

Congratulation to all New MVP'S and renewel of MVP'S

This month I will talk about Excel with our guest Johnnie Thomas about what is new in Excel and feedback from the community.

Read More
3,262 Views
5 Replies

Good Morning

a "stupid" question:

where i can buy the sticker in the back of your laptop ?

Regards

Aloha! Thanks for the info, and cool feature of being able to set my PivotTable default. However, I am not an Office 365 user. I use MS Office Pro Plus 2016, and it appea... Read More

Hi Olaf,

 

I like it, good demonstration of your team efforts in improving Excel with the help of worldwide users’ community. By the way, that will be great if one day illu

... Read More