Home

Resources and Community

49 Conversations

Latest Activity

Custom List Message Item

Pk9AYk1-796x398.jpg

 

 

 

1. Inserting comment into any cell

While preparing the spreadsheet, you may feel the need to add some special comments to the value so that it is easy to understand when you open it later.
In order to use this feature, you just have to right click on the
... Read More
9 Views
0 Reply

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

 

 

 

Read More
4,398 Views
8 Replies

hi

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.

I wonder if anyone can help me with the following, i have a summary supplier sheet with rows of supplier information, then i have 7or 8 other supplier sheets e.g. Supplier a, supplier b, supplier c etc.    i want to link the various supplier rows of data

... Read More
30 Views
1 Reply
Generally speaking it is easier to have the information for all supliers on one sheet and use a separate summary sheet to summarize.

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
2,757 Views
14 Replies

Congratulations for a job well done, it is a really good tool for Excel beginners.

Deseo: 1) saber cómo puedo insertar el número de página en un una celda de un libro de excell, pero que no sea en el encabezado, si no en un celda cualquiera. 2) como pue... Read More
Bonjour à tous et à toute, je travaille sur Win10 (64bits) et dans mon excel 2013 qaund je fais clic droit et je choisis controles supplementaires, rien se produit. du co... Read More

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? 

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
285 Views
5 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

Hi Randal - why don't you ask Google for this?

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

V.K.,

 

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

 

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

 

Read More
265 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
88 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

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

57 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
171 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
131 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
2,851 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
86 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
160 Views
0 Reply

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

 

Read More
70 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
218 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
101 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
70 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
184 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
93 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
266 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
979 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
275 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
307 Views
0 Reply