Questions tagged [excel-2016]

The Excel-2016 tag is used for referencing the spreadsheet component of the Microsoft Office 2016 suite released 22 Sep 2015. The version independent Tag is "excel". If it is about VBA code or an Excel formula or worksheet function, then tag it vba & excel or excel-formula or worksheet-function respectively.

Excel 2016 is the spreadsheet component of the Office 2016 suite released on 22 Sep 2015. It incorporates what was previously the Power Query add-in, additional charting options and Power BI Desktop. details here

From Wikipedia Included in the Microsoft Office 2016 package, along with a lot of new tools included in this release:

  • Power Query integration
  • Read-only mode for Excel
  • Keyboard access for Pivot Tables and Slicers in Excel
  • New Chart Types (Sunburst, Waterfall, Pareto Charts, 3D Data Map etc.)
  • Quick data linking in Visio
  • Excel forecasting functions
  • Support for multi-selection of Slicer items using touch
  • Time grouping and Pivot Chart Drill Down
  • Excel data cards
  • The 'Tell Me' box to search inbuilt functions and operations

For Apple Macintosh Excel 15.0 forms part of the "Office 2016" suite.

Office 2016 for Mac brings the Mac version much closer to parity with its Windows cousin, harmonising many of the reporting and high-level developer functions, while bringing the ribbon and styling into line with its PC counterpart.

For a poignant article on this see Walt Mossberg's article Office for Mac Is Finally a 'First-Class Citizen'.

Links:

1509 questions
-1
votes
2 answers

MS-Excel automatic increase number if text not same

As shown above picture i need put number on column B that automatic increase if text on column A not same so the the result would be Can I do that with ms-excel?
ichadhr
  • 629
  • 6
  • 18
-1
votes
2 answers

How do I input values in the Excel model without doing it manually?

I have the feeling that my previous question is being misunderstood. Therefore, I will do this as follows. What I would like is the following: In this picture you see that the input is 4 in cell B1. This B1 cell is used as an input for a…
Snowflake
  • 2,869
  • 3
  • 22
  • 44
-1
votes
1 answer

How to edit excel table by converting row values to column values

I have above table containing latitude and longitude values, But latitudes are in column & longitudes are in row, I want both in column wise and with their corresponding values
-1
votes
2 answers

VLOOKUP, INDEX, or LOOKUP? Which one to use and how?

I would like to use a function to reference my INPUT against the appropriate values from the left-hand columns and return the appropriate OUTPUT using the values in the right-hand columns. In the screenshot, I'm using the INPUT of "1200" in cell…
-1
votes
1 answer

Exporting Google Sheets to Excel 2016

I'm making a console application in .NET framework that uploads a .XLSX file to Google Drive (converting it to Google Sheets format in that process) and also downloads the Google Sheets to .XLSX format. Basically I'm trying to sync a local drive…
nvkrj
  • 1,002
  • 1
  • 7
  • 17
-1
votes
1 answer

Excel formula to link specific cells from one row to another and calculate mean/standard dev/mode

Basically, I am looking for a function that allows me to determine the standard deviation, mean, and mode for one TA's marks for a specific assignment. Each row specifies which TA is grading, and so I need a function that will choose all of TA 'A's…
Gaby 222
  • 3
  • 1
-1
votes
1 answer

How to add custom add-ins in Excel 2016 without browsing it?

In Excel 2011 I used to paste my custom Add-In in 'Applications>Microsoft Office 2011>Office>Add-Ins' location. I don't want to browser it from 'Tools' menu item. So kindly help me on this. I am kind of stuck with this. I need a similar location in…
-1
votes
2 answers

How to color cells in Excel

How do I color my negative data red and color my postive data green in Excel 2016? I have more than 300,000 data in 12 spreadsheets So I can't do it manually.
k.dkhk
  • 481
  • 1
  • 11
  • 24
-1
votes
1 answer

Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

I hope this is a quick and easy question for Excel pros out there. I'm using the default "Retirement Planner" spreadsheet in MS Excel 2013. I want to make some modifications to the existing formulas, but every time I click on a cell, the formula…
-1
votes
1 answer

Using ExportAsFixedFormat is being sent to printer instead on Excel 2016

I'm trying to make a macro that exports only a specific area to PDF. I have multiple sheets in my workbook, but I can't use SaveAs with xlSelection because that parameter is bugged and it exports the entire workbook to a PDF. Here is the code that I…
Alfredo C
  • 1
  • 2
-2
votes
0 answers

How to get the Google Drive web share link for an Excel file

I currently use Excel 2016 on both Mac and PC... and I to know how to get the web share Link of a specific file whose folder is known where it is located within a Google Drive account. From what I have consulted on the web, some Google API can be…
-2
votes
3 answers

How to Combine two Lists In Excel

I want to combine two lists into one, for example if we have List A: Item 1 Item 2 (empty) Item 3 List B: Item 4 (empty) Item 5 Item 6 from above two lists, want to combine them without any empty spaces such as: Merged List should be: Item…
John
  • 1
  • 1
-2
votes
1 answer

Linking two different Excel tables and auto-populate one when populate another

I have two diferent excel formatted tables one near another. First table (green headers) is a table where I have to add some chemical formulas in Column A and Column B will be SUM of all compounds that I will add from second table (yellow headers),…
MmVv
  • 553
  • 6
  • 22
-2
votes
1 answer

Macros for copying data from a workbook with multiple sheet to another workbook with multiple sheet

How to VBA code if I want to copy data from one excel workbook which has data in 3 different sheets to be copied to different excel workbook with 3 sheets? I have 2 excel workbook named as W1 and W2, each excel workbook consists of 3 sheets named as…
-2
votes
1 answer

Excel selecting all data from column b between 2 rows found in column a

How can i select all data in between 2 rows from other columns. Please see attached photo. Sample excel photo: Note that ending row criteria is dynamic row. the number of data to be selected is not constant. I just want to select a all data from…