# Sumproduct.com how to use exel, tips & tricks excel

### Excel Virtually Global 2021 SumProduct are experts in

**Details: **Over two days from 12 Oct to 13 Oct 2021 GMT, the largest ever collection of the world’s best **Excel** experts – most recognised by Microsoft as their own staff or else coveted ‘MVPs’ or ‘Most Valuable Professionals’ – showed you how to really up your **Excel** game.

› Verified *4 days ago*

› Url: https://www.sumproduct.com/excel-virtually-global-2021 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Virtually Global SumProduct are experts in Excel

**Details: **Here lie all the available videos and files associated with July’s **Excel** Virtually Global event. If you were not an attendee, we would kindly ask you to make a fair donation to Médecins Sans Frontières or similar charity. In our own small way, on behalf of all the presenters, we are hoping to make this current world a little safer and a little healthier.

› Verified *9 days ago*

› Url: https://www.sumproduct.com/excel-virtually-global Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Virtually Global 2021

**Details: **Just a reminder, this almost-two-day virtual conference, for charity, presents 50+ **Excel**, Data Platform and PowerPoint MVPs, together with other acknowledged experts from Microsoft and / or around the globe to present, answer questions and demonstrate the future of **Excel** and how it will make your life easier, personally and professionally.

› Verified *4 days ago*

› Url: https://www.sumproduct.com/news/article/news/excel-virtually-global-2021-coming-soon Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel for the Web Workbook Link Support < Article < News

**Details: **If you click the ‘Enable Content’ button, **Excel** for the Web will retrieve the values from all the linked workbooks. To help you manage these links, Microsoft has added a new ‘Workbook Links’ task pane. This task pane may be accessed by pressing the ‘Workbook Links’ button on the Data tab .

› Verified *9 days ago*

› Url: https://www.sumproduct.com/news/article/excel-for-the-web-workbook-link-support Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The INDIRECT Function

**Details: **Welcome back to our regular A to Z of **Excel** Functions blog. Today we look at the INDIRECT function. The INDIRECT function. **Excel**’s INDIRECT function allows the creation of a formula by referring to the contents of a cell, rather than the cell reference itself. The INDIRECT(ref_text,[a1]) function syntax has two arguments:

› Verified *7 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-indirect-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The IFS Function

**Details: **In this situation, there is a function in **Excel** that can help. My old English teacher said you should never start or finish a sentence with the word “and”. AND is one of several **Excel** logic functions (others include NOT [already mentioned earlier, which takes the …

› Verified *2 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-ifs-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Pivotal PivotTables

**Details: ****Excel** 2007 has increased PivotTable flexibility significantly from earlier incarnations. However, as with many pre-**Excel** 2007 features, the location of various tools and options needs to be re-learned. This article provides a basic overview for both **Excel** 2003 (and earlier) users as well as **Excel** 2007 users.

› Verified *4 days ago*

› Url: https://www.sumproduct.com/thought/pivotal-pivottables Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Referencing Multi-Page Data from a Web Site with a …

**Details: **Let’s copy it and save it on to an **Excel** spread sheet to aid us in discovering any patterns. Right click the line of URL and select ‘Copy just URL’. After repeating the process, a couple of times, we spot a pattern. Fiddler is able to retrieve the URL and break it down into pages. This is great news, we can finally use this to work with

› Verified *6 days ago*

› Url: https://www.sumproduct.com/thought/referencing-multi-page-data-from-a-web-site-with-a-single-url Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### ALTernative Excel in an Instance < Thought SumProduct

**Details: **Now you may wreak havoc. To edit the registry: close all instances of **Excel**; open the Registry Editor (as explained in the backup step) go to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\**Excel**\Options (this is for **Excel** 2016; for **Excel** 2013, use HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\**Excel**\Options); click ‘Edit’ in the …

› Verified *7 days ago*

› Url: https://www.sumproduct.com/thought/alternative-excel-in-an-instance Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Power Query: Passing (Reference to) Excel Parameters

**Details: **The correct data is shown. I can update the parameter (by changing the cell or editing the named range) in my **Excel** worksheet and refresh the query to change the data that is selected. I try this by changing ‘Item_Parameter’ to point at the next item description.

› Verified *7 days ago*

› Url: https://www.sumproduct.com/blog/article/power-query-blogs/power-query-passing-reference-to-excel-parameters Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The FILTER Function

**Details: **Welcome back to our regular A to Z of **Excel** Functions blog. Today we look at the FILTER function.. The FILTER function. Still in what Microsoft refers as “Preview” mode, i.e. it’s not yet “Generally Available”, FILTER is one of seven functions heralding the new dawn of arrays – the Dynamic Array. Presently, you need to be part of what is called the “Office Insider” programme

› Verified *5 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-filter-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### File Style < Thought SumProduct are experts in Excel

**Details: ****Excel** has six format properties: Number, Alignment, Font, Border, Patterns and Protection. A style is simply a pre-defined set of these various formats. With a little forethought, these styles can be set up and applied to a worksheet cell or range very easily.

› Verified *5 days ago*

› Url: https://www.sumproduct.com/thought/file-style Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The GEOMEAN Function

**Details: **Welcome back to our regular A to Z of **Excel** Functions blog. Today we look at the GEOMEAN function.. The GEOMEAN function. In mathematics, the geometric mean is a mean or average, which indicates the central tendency or typical value of a set of numbers by using the product of their values (as opposed to the arithmetic mean which uses their sum).

› Verified *6 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-geomean-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Article < Blog

**Details: **In **Excel**’s data types gallery, you will be able to find data from featured tables in Power BI datasets. For example, you can feature data on Customers, Product and Suppliers: Additionally, by using Power BI’s certified and promoted datasets capabilities, you can enable members of your organisation to find and use relevant / refreshable data

› Verified *Just Now*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-arraytotext-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The DSUM Function

**Details: **The DSUM function has the following arguments:. database: this is required and represents the range of cells that makes up the list or database.A database is a list of related data in which rows of related information are records and columns of data are fields. The first row of the list contains labels for each column; field: indicates which column is used in the function.

› Verified *3 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-dsum-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The FINV Function

**Details: **Once this has been determined (using either of these **Excel** functions), the ANOVA test may now be completed , with the calculated F compared to the critical F, and if the former is greater than the latter, the null hypothesis (H 0) will be rejected. In summary, the FINV function returns the inverse of the (right-tailed) F probability distribution.

› Verified *3 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-finv-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Thought SumProduct are experts in Excel Training

**Details: ****Excel** 2019 Functions and Features - **Excel** 2019 has released new functions, charts, feature improvements, and more **EXCEL** TIPS; **Excel** 365 Functions and Features: February 2019 - **Excel** 365 has just received several performance improvements. **EXCEL** TIPS; File Style - How to make the most of **Excel**'s styles, in contrast to simple cell formats

› Verified *8 days ago*

› Url: https://www.sumproduct.com/thought?L=0 Go Now ^{}

› Get more: How to makeGo Now ^{}

### A to Z of Excel Functions: the FORECAST.ETS.SEASONALITY

**Details: **Welcome back to our regular A to Z of **Excel** Functions blog. Today we look at the FORECAST.ETS.SEASONALITY function.. The FORECAST.ETS.SEASONALITY function. A window function (also known as an apodization or tapering function) is a mathematical function that has a zero value outside of a chosen interval.

› Verified *1 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-forecastetsseasonality-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Comments and Notes Upgraded in Excel for the Web < Article

**Details: **There have been some recent updates to the threaded comments and notes experience in **Excel**. When what was known as “threaded comments” in **Excel** for Windows, **Excel** for Mac and **Excel** for the web was released back in January 2019, Microsoft originally decided to keep the legacy comments (the yellow sticky notes) in the Windows and Mac versions and rename them notes.

› Verified *8 days ago*

› Url: https://www.sumproduct.com/news/article/comments-and-notes-upgraded-in-excel-for-the-web Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The LOOKUP Function < Article < Blog SumProduct are

**Details: **The LOOKUP function vector form syntax has the following arguments:. lookup_value is the value that LOOKUP searches for in the first vector; lookup_vector is the range that contains only one row or one column; result_vector is optional – if ignored, lookup_vector is used – this is the where the result will come from and must contain the same number of cells as the lookup_vector.

› Verified *5 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-lookup-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Article < Blog

**Details: **if you select a field that has spaces in the name, **Excel** will automatically add brackets ([ ]) around the field name, e.g. =A2.[52 Week High] the FIELDVALUE function can also be used, but it is recommended only for creating conditional calculations based on linked data types. This last point is a nice lead into the other new item…

› Verified *3 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-fieldvalue-function?L=0 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Go Poisson < Thought SumProduct are experts in Excel

**Details: **Simulations Analysis in **Excel**. Similar to Simulation Stimulation, we’d like to use the simulations method to model the number of fish caught in a day.However, unlike NORM.INV, **Excel** does not provide a Poisson Inverse function which means that we had to write our own.. Let’s look at the logic of the Poisson function and create our own User-Defined Function in VBA (which we have called

› Verified *5 days ago*

› Url: https://www.sumproduct.com/thought/go-poisson Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The DCOUNTA Function

**Details: **The DCOUNTA function has the following arguments:. database: this is required and represents the range of cells that makes up the list or database.A database is a list of related data in which rows of related information are records and columns of data are fields. The first row of the list contains labels for each column; field: indicates which column is used in the function.

› Verified *6 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-dcounta-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### VBA Blog: Create text file from Excel table < Article

**Details: **Today, we are going to create a VBA script that will create a text file based on a specific table in the **Excel** workbook. This is useful to create text templates for a range of purposes, such as uploading data into databases and other systems that only accept text files. We would like to save the following table (Table1) in **Excel**:

› Verified *2 days ago*

› Url: https://www.sumproduct.com/blog/article/vba-blogs/vba-blog-create-text-file-from-excel-table Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Tables < Thought SumProduct are experts in Excel

**Details: **With the release of **Excel** 2007, the Table functionality was introduced, superseding **Excel** 2003′s ‘List’ feature, in effect adding functionality. This has nothing at all to do with Data Tables. Creating a Table in **Excel** 2007 and later versions is straightforward, and simply requires the user to select the data to be used in the Table:

› Verified *5 days ago*

› Url: https://www.sumproduct.com/thought/tables?L=0 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Article < Blog

**Details: **Personally, I find the number 46 very odd, but **Excel** doesn’t; ISREF(value): checks whether the value is a reference; ISTEXT(value): checks whether the value is text. As stated above, the ISFORMULA function checks whether the reference is to a cell that contains a formula. It …

› Verified *8 days ago*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-isformula-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Not Just Mary Can Have a Little LAMBDA / Excel Hits 500

**Details: **It mixes **Excel** cell referencing (cell C1, because you cannot refer to a value for a different record simply in an **Excel** Table), structured referencing ([@Sales]) and the N function, in order to treat the numerical value of text as zero [0] and therefore avoid #VALUE! errors when adding amounts together. It seems to work if values are added:

› Verified *3 days ago*

› Url: https://www.sumproduct.com/news/article/not-just-mary-can-have-a-little-lambda-excel-hits-500 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Wake Up Call for Excel..

**Details: **The official App Store listing cites: “Microsoft Office Mobile is the official Office companion optimized for your iPhone. You can access, view and edit your Microsoft Word, Microsoft **Excel** and Microsoft PowerPoint documents from virtually anywhere”. For Word …

› Verified *2 days ago*

› Url: https://www.sumproduct.com/news/article/wake-up-call-for-excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Volatile Functions: Talk Dirty to Me < Thought

**Details: **A volatile function is one that causes recalculation of the formula in the cell where it resides every time **Excel** recalculates. This occurs regardless of whether precedent cells / calculations have changed, or whether the formula also contains non-volatile functions. One test to check whether your workbook is volatile is close a file after saving and see if **Excel** prompts you to save it a

› Verified *Just Now*

› Url: https://www.sumproduct.com/thought/volatile-functions-talk-dirty-to-me Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Power Query: Returning to Referencing Ranges < Article

**Details: **Welcome to our Power Query blog. This week, I take another look at what I can do with **Excel**.CurrentWorkbook. In Power Query: Cell Referencing, I looked at how to reference a single cell in a worksheet.I’d like to return to the M function **Excel**.CurrentWorkbook to show how to reference more than one cell.. To begin with, the description of **Excel**.CurrentWorkbook in the Microsoft help pages

› Verified *1 days ago*

› Url: https://www.sumproduct.com/blog/article/power-query-blogs/power-query-returning-to-referencing-ranges Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### AGGREGATE < Thought SumProduct are experts in Excel

**Details: **Now, **Excel** appears to be looking for the other argument for LARGE() or else another reference. This is not correct. The screen tip does not update automatically. The syntax required is now just as it would if we had typed in the underlying function, i.e. =LARGE(Array,k).In this instance, this syntax always requires the fourth value to be k, the integer denoting the kth largest item in the list.

› Verified *8 days ago*

› Url: https://www.sumproduct.com/thought/aggregate?L=0 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Waterfall Charts

**Details: **A waterfall chart is a variation of an **Excel** column chart that provides a visual representation of what has made a key output vary between one period and the next, viz. Example Waterfall Chart In the above example, the two black columns represent the opening and closing balances for a key output in a particular period.

› Verified *1 days ago*

› Url: https://www.sumproduct.com/thought/waterfall-charts Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Power Query: Cell Referencing < Article < Blog

**Details: **This week, I take a look at how to reference a cell in an **Excel** workbook from Power Query. I will begin by creating a query from the item data below: On the ‘Data’ tab, in the ‘Get and Transform’ section, I choose to create a new query ‘From Table’.

› Verified *6 days ago*

› Url: https://www.sumproduct.com/blog/article/power-query-blogs/power-query-cell-referencing Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Power Query: Unique and Distinct < Article < Blog

**Details: **Welcome to our Power Query blog. This week, I look at how to find the unique or distinct values in a list of data. I have a list of data, and I want to find the values that occur once only.

› Verified *9 days ago*

› Url: https://www.sumproduct.com/blog/article/power-query-blogs/power-query-unique-and-distinct Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Article < Blog

**Details: **Welcome back to our regular A to Z of **Excel** Functions blog. Today we look at the CONCATENATE function.. The CONCATENATE function. IMPORTANT: In **Excel** 2016, **Excel** Mobile, and **Excel** Online, this function has been replaced with the CONCAT function (see the last functions blog).Although the CONCATENATE function is still available for backward compatibility, you should …

› Verified *Just Now*

› Url: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-concatenate-function Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Power Query: Querying Query Options < Article < Blog

**Details: **The default behaviour is “Background Data Load”, but now users can instead choose the “Fast Data Load” mode in the Options dialog. When loading a query using the “Fast Data Load” mode, your query will take less time to load, however, **Excel** may be unresponsive for long periods of time during the upload.

› Verified *2 days ago*

› Url: https://www.sumproduct.com/blog/article/power-query-blogs/power-query-querying-query-options Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### XLOOKUP and XMATCH: Two New X-Men for Excel < Thought

**Details: **[range_lookup] appears in square brackets, which means it is optional. It has two values: TRUE: this is the default setting if the argument is not specified. Here, VLOOKUP will seek an approximate match, looking for the largest value less than or equal to the value sought. There is a price to be paid though: the values in the first column (or row for HLOOKUP) must be in strict ascending order

› Verified *1 days ago*

› Url: https://www.sumproduct.com/thought/xlookup-and-xmatch-two-new-x-men-for-excel?L=0 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Microsoft Visio Data Visualizer Add-in for Excel < Article

**Details: **The **Excel** workbook must be saved in order to link to the Visio diagram, so let’s save the file and click Done. The chart can also be moved by clicking on the chart box and moving it to the desired location: Below is a closer look at the data table, where details have been altered to create our customised flowchart.

› Verified *8 days ago*

› Url: https://www.sumproduct.com/news/article/microsoft-visio-data-visualizer-add-in-for-excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Top Categories

### Recently Searched

› Embed outlook email in excel

› How to calculate ratio excel

› Adding minutes and seconds in excel

› Last name first initial formula excel

› Microsoft excel estimate template

› Microsoft excel office online free

› Create custom form in excel for windows

› Can i protect certain cells in excel

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel