Finding Friday the 13th using Excel (and learning cool formulas along way)
Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.
Announcing Online VBA Classes from Chandoo.org, Please Join Today
Friends & Readers of Chandoo.org,
I am so happy to tell you that our VBA Classes are now open for your consideration. Click here to know more & join us.
What is this VBA Class?
VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.
The aim of VBA Classes is to make a beginner an expert in VBA.
Read on to understand the benefits of this program & how to sign-up.
Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]
Here is a quick Excel tip to kick start your week.
Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.
(1) Select all the cells where you want to enter the same data.
(2) Type the data
(3) Press CTRL+Enter
(4) Done!
See the animation aside to understand how this works.
Quick Update about VBA Classes & Discount Expiry!
I have 2 quick announcements & 1 Excel tip for you.
Announcements
- Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
- 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.
Read on for a bonus Excel tip as well.
How Companies Can Manage Spreadsheet Risk [Part 2 of 4]
In the second installment on Excel Spreadsheet Risk Management, Myles takes a look at How companies can manage spreadsheet risk?.
He tells us, how we can set a formal governance framework to reduce or mitigate spreadsheet risk. Go ahead and read. And please tell us how your company manages spreadsheet risk in comments.
Free Picture Calendar Template – Download and make a personalized calendar today!
Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel!
Using this you can print a 12 month calendar with your own photos. Its fun to use, easy to set up and looks great. Read more to understand how this works & download the template.