Confirmed - Excel Campus

Confirmed

You have been removed from the notification list on the dashboard course and free webinars.  Please contact me if you clicked this link in error and would like to continue receiving these notifications.

 

Checkout the latest blog posts

Convert Text to Dates with Flash Fill – Data Cleansing Challenge

Bottom line: Learn how to convert dates stored as text to date values in Excel using Flash Fill.  There are many possible solutions to this problem, so please leave a comment below explaining the technique that you would use.Skill level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-co [...]

Continue reading»

3 Ways to Remove Duplicates to Create a List of Unique Values in Excel

Bottom line: In this article and video I explain 3 ways to remove duplicates to create a list of unique values. We look at the Remove Duplicates feature and a macro that makes the process much faster.  I also added a video on how to use the Advanced Filter to list unique values.Skill level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; heig [...]

Continue reading»

How to Get Excel for Mac Pre-Release Versions – Office Insiders Program

Microsoft just released a new update to Excel 2016 for Mac with two BIG new features: PivotCharts and a new VB Editor.[...]

Continue reading»

Pivot Charts for Excel 2016 for Mac

Bottom line: Pivot Charts are now available on Excel 2016 for Mac (Office 365).Skill level: Beginner.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; left: 0; width: 100%; height: 100%; }Watch on YouTube [...]

Continue reading»