December 2011
1 post
The Excel Comments - Tips page on the Contextures website has been updated. www.contextures.com/xlcomments02.html
November 2011
9 posts
Sorting Pivot Table Report Fields →
Quickly Minimize the Ribbon in Excel →
30 Excel Functions in 30 Days eBook Kit
Want to learn more about Excel functions, like VLOOKUP, MATCH, OFFSET and INDEX?
Contextures has published the 30 Excel Functions lesson guide and workbook, based on the popular 30 Excel Functions in 30 Days challenge, from the Contextures Blog.
If you missed the challenge, or want all of the content in an easy-to-use single reference file, you can get this...
Repeat Pivot Table Labels in Excel 2010 →
Excel VLOOKUP Troubleshooting →
Go To Specific Part of Excel Worksheet →
GetPivotData Formula Instead of Cell Link →
Calculate Thanksgiving Date in Excel →
Microsoft Office 365 Resources
If you’re looking for free training for Microsoft Office 365 and other products, there some great resources on the Microsoft website.
For example:
Microsoft Virtual Academy
Evaluation Download Center
TechNet Cloud Hub
Check out those materials, before you sign up for something expensive!
August 2011
1 post
Excel Filter for Blanks: Shark Week 2011 →
July 2011
16 posts
Excel Function Friday: Average Top 10 Scores →
Friday Fun: Pivot Table Comic →
Make It Easy to Ask Excel Questions →
Normalize Data for Excel Pivot Table →
How to Create Excel 2007 Pivot Table →
Untitled
Would your ancestors want to be in an Excel pie chart? That’s just one of the intriguing Excel related tweets that I found today. Today’s Excel Tweets 20110719
Today's Excel Tweets →
Who thought of creating pie charts to represent ancestors in a family tree? That’s just one of the gems that I discovered in today’s Excel related tweets.
Testing CodeColorer for Excel VBA Blog Posts →
Testing the CodeColorer WordPress plugin, to see how well it formats Excel VBA in the blog post, and in the comments.
Save Time When Saving Excel Files →
Excel CONVERT Function Made Easy →
How to Build an Excel Waterfall Chart →
Excel Pivot Table Tweets →
Excel Waterfall Chart for Pocket Price →
Excel Drop Down Multi-Select Update →
Create a Pocket Price Waterfall Chart in Excel →
In 2003, McKinsey & Company coined the term “Pocket Price” to describe the amount that you actually get from a customer, after the hidden costs and off-invoice discounts that might exist.
This article, and Excel tutorial video, show you how to create a pocket price waterfall chart.
June 2011
3 posts
Do Not Build This 3-D Chart in Excel →
Excel Power Utility Pack Sale Phase 2 →
Show UserForm When Excel File Opens →
May 2011
2 posts
Track Weight in Excel Spreadsheet - Metric Version →
Previous versions of the Excel Weight Tracker were based in pounds, and stones/pounds. In this latest version, you can enter your height in centimetres, and your weight in kilograms. The workbook calculates your current BMI and ideal weight range.
April 2011
15 posts
Clear Old Items in Pivot Table Drop Downs →
Include New items in Pivot Table Filter →
Troubleshoot Excel With Formula View →
Organizing Email in Outlook →
Add Pivot Table Subtotals for Inner Fields →
Fix Blank Excel Cells Copied From Database →
Automatically Add Sheet When Excel Opens →
30 Excel Functions in 30 Days: 03 – TRIM →
Track Goals and Activities in Excel →
1 tag
30 Excel Functions in 30 Days: 02 – AREAS →
Excel Function Friday: Track Driver Hours →
Track Goals and Activities in Excel
David Seah produces a compact calendar each year, in Excel format, that you can download from his website. It’s a vertical format, with a row for each week, and the month start dates highlighted. He also posts a monthly review of his goals and activites, under the heading of Groundhog Day Resolution Review. In his April review, he includes a downloadable Excel file, in which he tracks...
30 Excel Functions in 30 Days: 01 – EXACT →
2 tags
Get the URL from an Excel Hyperlink →
December 2010
4 posts
Excel Weekly Meal Planner With Recipe Selector →
Add List Box to Excel Worksheet →
Use Pivot Table Calculated Item →