Former Employee

Excel 2016 includes a powerful new set of features based on Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

 

Today, we are pleased to announce four new data transformation and connectivity features that have been requested by many customers.

 

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

 

These updates include the following new or improved features:

  • Conditional Columns.
  • Column type indicator in Query Editor preview column headers.
  • Reorder Queries and Query Groups inside Query Editor via drag and drop gestures.
  • Query Management menu in Query Editor.

 

Read more on Office Blogs. 

 

 
 

Update! Announcing 12 new data transformation and connectivity features that have been requested by many customers.

 

These updates include the following new or improved data connectivity and transformation features:

  • New SAP HANA connector.
  • New SharePoint Folder connector.
  • New Online Services connectors category.
  • Improved DB2 connector, now leveraging the Microsoft driver for IBM DB2.
  • Improved Text/CSV connector, now exposing editable settings in the preview dialog.
  • Improved relational database connectors, now including Schema information as a part of the Navigation hierarchy.
  • Data Source Settings enhancements, including “Change Source” capability.
  • Advanced Filter Rows dialog mode within the Query Editor.
  • Inline Input controls for Function invocation within the Query Editor.
  • Support for reordering Query Steps within the Query Editor by using drag and drop gestures.
  • Date picker support for input Date values in Filter Rows and Conditional Columns dialogs.
  • New context menu entry to create new queries from the Queries pane within the Query Editor.

 

Read more on Office Blogs

ارجو المساعدة للضرووورة عند جمع الدرجات في الاكسل وهي اساسا عبارة عن خلايا منسوخة ولصقت بلصق الارتباط لايظهر المجموع 97.01 وهذا مهم جدا لنا ولكن يظهر الاكسل فقط 97 وهذا يسبب اشكالية كبيرة لدينا كيف نعالج المشكلة
www.000webhost.com