-
It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! Can't remember all those Excel keyboard shortcuts? Now you don't have to! There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them...
-
In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with...
Posted to
The Excel Team Blog
by
Excel Blog
on
Tue, Jun 28 2011
Filed under:
Filed under: Charting, Conditional Formatting, PivotTables, Data Validation, Formatting & Printing, Solver, Excel 2010, Sparklines, Slicers, Beginner, functions, Excel Web Apps, PowerPivot, macros, Excel, training, Basics, Web Apps, SmartArt, print
-
We recently discovered this music video by youarentbenjamin on YouTube titled "PivotTables Make Everything Just Right." The video gives some serious love to PivotTables . Props for the creativity, and here's hoping they got an A+ for their group project! ...( read more ) Read More...
-
In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use...
-
In this blog article, we’ll step through using PowerPivot for Excel 2010 for building a rich application in Excel. Note: following screenshots describe the SQL Server 2008 R2 August Community Technology Preview (CTP) functionality for a feature codenamed Gemini. As recently announced , Gemini will be...
-
Today we have a guest author from the SQL Server Analysis Services team, Ashvini Sharma, to tell us about the PowerPivot (née Gemini) feature that you may have heard about recently. PowerPivot is the recently announced name of technologies this blog previously referred to by its codename, Gemini. This...
-
Thanks to Diego Oppenheimer for putting together this post. In today’s post I will be covering a couple of smaller PivotTable features that we incorporated in Excel 2010. Most of these features have been longstanding customer requests or pain points that we felt could be addressed in this release. This...
-
Thanks to Diego Oppenheimer for putting together this post. When thinking of Excel as an OLAP analytical tool the first thing that usually comes to mind is the ability to quickly and easily analyze data from an OLAP data source. With the introduction of PivotTable What-If Analysis in Excel 2010 you can...
-
Thanks to Diego Oppenheimer for putting together this post. When working with PivotTables, you often come across scenarios where you want to work with the same set of items from the data over and over again. For example, you might be a regional manager and you want to create a set of reports about the...
-
Exploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily enables you to find what you need, filter and repeat for a faster more efficient way of navigating those enormous data sets. Filtering...
-
On the topic of “teasers”, one of the things we’ll be talking about in the coming weeks is project Gemini. I won’t get into the details just yet (otherwise it wouldn’t be a teaser), other than to say it’s a powerful data analysis feature, it’s an add-in to Excel (i.e. not a built-in Excel feature), and...