10 Excel Tricks you did not yet know
This post is originally published on Excel Blog articles
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.
Analyze 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.
Forecast 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.
Date 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.
New charts for organizational and financial analysis
Lots of new charts have been added to Excel, like TreeMap, WaterFall, Maps, Sunburts, Funnel …
New formulas in Excel
Now you can use new formulas like TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS
Gather all your web data with ease
Connect to a web data source using Power Query
Build 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.
Live web data using Web Services Function
Use data from a web service on the Internet or Intranet in your formulas.
You're an expert with Tell Me
Find everything you like to do within Excel directly from the new Tell Me feature.