Excel table or PivotTable?
In Excel there are tables and PivotTables.
Refine results
Product
Audience
Publish date
-
-
Add a table of contents to your workbook – it’s easy, I promise!
Sometimes workbooks can be very large and hard to navigate. -
Can’t find the Chart Wizard? No worries
Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010.
-
Create a bulleted list in a cell
Today’s blog post is brought to you by Gary Willoughby. -
Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 1
This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. -
Free Excel templates save time for busy parents, students, and teachers
This week’s post is written by Amy Miller. -
Crabby’s Monday tip: Change where the cursor moves after entering data in Excel
I tell you, I learn new things—sometimes even elementary things, that even typing monkeys already know—about Office programs every day and today I’m offering the newest one.
-
True or false, IF provides the answer
Today’s post is brought to you by Frederique Klitgaard. -
You Asked: What the heck is Scroll Lock
This week’s post is written by Amy Miller. -
Word of the week: Close (the header or footer, and get back to your document)
We get a lot of comments from people who have added a header or a footer and can’t get back to the body of their document.
-
Solutions to Three Common Problems when Using VLOOKUP()
This article assumes a basic familiarity with the VLOOKUP() function, one of the easiest ways to lookup up a key value in one worksheet or block of data and return a related piece of information from a second worksheet or block of data. -
Running a SQL Stored Procedure from Excel (No VBA)
In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure.