10 Excel Tricks you did not yet know
Published Dec 13 2016 04:17 PM 6,725 Views
Former Employee

 

Flash FillFlash Fill

Flash Fill your data

Ever needed to clean up some data that you copied and pasted into Excel? Flash Fill will help you quickly parse, extract or cleanup your data.  For example, if you need to split first and last name or pull out the email address.

Learn More

 

 

 

 

 

Quick AnalysisQuick AnalysisAnalyze data with Quick Analysis

Not sure what the best way is to use your data? Simply select the data and click on the Quick Analysis icon to analyze your data instantly. It will give you some nice examples of what you can do with your data.

Learn More

 

 

 

 

 

ForecastForecastForecast based on a historical time series

Forecasting functions can be used to predict future values based on historical data. These functions use advanced machine learning algorithms, such as Exponential Triple Smoothing.

Learn More

 

 

 

 

 

Group DataGroup DataDate aware Pivot Tables and Pivot Charts

Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times into quarters and months.

Learn More

 

 

 

 

 

New ChartsNew ChartsNew charts for organizational and financial analysis

Lots of new charts have been added to Excel, like TreeMap, WaterFall, Maps, Sunburts, Funnel …

Learn More

 

 

 

 

 

 

TEXTJOINTEXTJOINNew formulas in Excel

Now you can use new formulas like TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS

Learn More

 

 

 

 

 

 

 

Get DataGet DataGather all your web data with ease

Connect to a web data source using Power Query

Learn More

 

 

 

 

 

 

 

Data ModelData ModelBuild relationships across your data

One of the most powerful features in Excel, built-in data mash-up and analysis features. Create a data model using Power Pivot.

Learn More

 

 

 

 

 

 

 

 

 

Web ServiceWeb ServiceLive web data using Web Services Function

Use data from a web service on the Internet or Intranet in your formulas.

Learn More

 

 

 

 

 

 

 

TellMeTellMeYou're an expert with Tell Me

Find everything you like to do within Excel directly from the new Tell Me feature.

Learn More

 

2 Comments
Version history
Last update:
‎Dec 13 2016 04:23 PM
Updated by: