Home

Resources and Community

52 Conversations

Latest Activity

Custom List Message Item

What I've done is created a question by question quiz that should tell you if you're correct and then automatically go to the next randomly generated question.
Essentially the idea is that when (eg) Q1 appears in E4 then E5 shows that particular question w

... Read More
27 Views
0 Reply

Here is the latest news about Excel from Microsoft Ignite 2017. Checkout the video and see everything that is new in Excel. 

 

 

 

Read More
7,547 Views
0 Reply

excel 2016    i open 3 files  excel  with 1 excel   and then i open new excel   open 3 files 

 

but when i choose switch windows  i see 6 files in 1 excel.

 

how to set see only 3 file in 1 excel and see 3 file in other excel

 

old excel can use  alt+tab  to se

... Read More
29 Views
0 Reply

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
157 Views
1 Reply

First published by Morris Edwards at http://successvalues.com/excel-formulas-university-students/

 

Am i correct?

Read More

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

 

 

 

Read More
7,185 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
68 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
3,495 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
332 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
94 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
301 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
100 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.

63 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
201 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
143 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
3,413 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
111 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
248 Views
0 Reply

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

 

Read More
77 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
275 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
123 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
90 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
214 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
112 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
309 Views
0 Reply