This offer has expired.
Please see the Contextures Recommends page for Excel training recommendations.
Category: Excel Archive
Tips and tutorials for older versions of Excel
Excel Dashboard Course Giveaway Winners
Last week we had a giveaway, with the grand prize of Excel TV’s online course – Excel Dashboard Pro. To enter, you had to add a comment to the blog post, with the hashtag that you might use, if you needed help with a dashboard. There were prizes for runners up too, and you can see all the winners below.
Excel Dashboard Course Giveaway
Are you an Excel Dashboard pro? If not, here’s a great opportunity to improve your skills. I’m having a giveaway, and a terrific new Excel dashboard course is the top prize. There are runner up prizes too, and a free video series.
Free Excel Dashboard Tools
Mike Alexander, from the Bacon Bits Excel blog, has just released a major update to his Dashboard Tools add-in. And the great news is that you can get a free copy for the next few days! Mike is making this available until May 7th, at midnight (Central Time Zone).
Contextures Cyber Monday Sale 2014
Happy Cyber Monday! I hope you didn’t spend all you money at the Black Friday sales, and have a little left over for today’s shopping spree.
To celebrate Cyber Monday, the busiest online shopping day of the year in the USA, you can buy a couple of my Excel products, at 50% off today only. The details, and links to the product pages, are below.
NOTE: Unfortunately, the shopping cart will only discount one item per order — if you want both items, please order them separately.
Contextures Black Friday Sale 2014
Happy Black Friday! If you celebrated Thanksgiving yesterday, I hope you enjoyed time with your friends and family, and are ready to do some shopping today.
To celebrate Black Friday, the busiest shopping day of the year in the USA, you can buy my popular ebook kit – Excel UserForms for Data Entry – at 50% off today. So, instead of the regular price of $30 US, you can get the kit for only $15 US. The price will be reduced automatically – you don’t need to enter a coupon code.
[Update: This product is no longer available]
The special price ends tonight (Nov. 28, 2014) at midnight, Toronto time (Eastern time zone).
Click here to see the details, and grab a copy of this awesome kit.
Excel Chart Utility Giveaway
On Thursday, June 12th, Jon Peltier is releasing the Advanced version of his Excel Chart Utility. If you make charts in Excel, keep reading, to see what the chart utility does, and how you can win a copy of your own.
Continue reading “Excel Chart Utility Giveaway”
Update to the Excel UserForm Course
Over the holidays, I added a new bonus file to my Excel UserForm course, and if you’ve previously purchased the course, you’ll receive the update automatically.
[Update: This course is no longer available]
The new file shows how to add Search boxes at the top of the form. Then, click a button to show a list of all the matching records in the database worksheet. Click on an item in the list, and its details appear in the text boxes below.
The sample uses transaction data, but you could adapt it for other types of records.
See the Course Details
Click here to see the course details, and watch the Search Boxes demo video: Excel UserForm Course
NOTE: The course price is going up on January 15th, so if you’re thinking about buying the course, don’t wait too long!
_________________
Ungroup Dates in Excel Filter Drop Down
By default, when you turn on an AutoFilter, dates are grouped in the drop down list. In the screen shot below, the dates have been rolled up to the years, 2013 and 2014. Here’s how you can ungroup dates in Excel filter drop down lists, in the active workbook.
Cyber Monday Sale Pivot Table Tool
It’s Cyber Monday, and we’re all supposed to spend the day shopping online, so I’m having a sale on my Pivot Table add-in – PivotPower Premium.
You can get it today for 30% off, and the sale ends at midnight (Eastern time) tonight, Dec. 2nd. You don’t need to enter a discount code – the priced will be reduced automatically when you add it to the shopping cart.
See the Key Features
You can see three of the time-saving features in this short video.
- save and apply your favourite pivot table settings
- clear old items from a pivot table
- change all the data fields to the Sum function.
Time-Saving Features
The add-in is easy to install, and it creates a new tab on the Excel Ribbon. You can see some of the other tools in the screen shots below. For example:
- Click to set Currency or Number format
- Print a list of pivot tables or cache information
- Turn Autofit on or off
Get the Discount
To see all the details, and buy the add-in at 30% off, please visit this page on my Contextures website: – PivotPower Premium.
The sale lasts until midnight December 2nd, 2013, Eastern Standard time. No discount code is required – the price will be automatically reduced in the shopping cart.
_____________________