Do you belong to LinkedIn ? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information? ...( read more )
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...
A couple of weeks ago, as part of our Watch History Reimagined series, we posted a video to show you how Excel might've helped the team at NASA work through some of the tensest moments in American history. Some of you asked us how we created certain visualizations that appear in the video. In today's...
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...
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 )
So many Office customers ask about "pivot table" that we've gathered the best answers in this blog post. Most likely, you are looking for information about how to create a PivotTable report that can help summarize and analyze your data. Or you already have your data in a PivotTable report...
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...
This blog post is brought to you by Rob Collie CTO at PivotStream. Former co-founder of the PowerPivot team and Lead PM for Excel at Microsoft, broad-spectrum geek and cruncher of sports stats. Hello Excel Pros! I’d like to start by saying this: You are my kind of people. I’ve met hundreds...
Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more information, visit www.datapigtechnologies.com . So summer is for practically over and I'm back to blogging topics that can actually help people...