Free 2014 Calendar, daily planner templates [download]
Here is a New year gift to all our readers – free 2014 Excel Calendar & daily planner Template.
This calender has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
Formula Forensics No. 34. Extract words from a cell, where they occur in a list of words.
Use Excel to extract matching words from a list of words from a cell containing a sentence into individual cells in the order they exist
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 3.)
Welcome back to yet another gripping episode of “When good formulas go GREAT”. We’re working up the singles charts to the number one hit “Formula Challenge 001 – Return everything in string after first block of numbers” By way of a quick refresher, this formula challenge calls for a formula to return a substring from […]
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)
This new series introduces a new author to Chandoo.org, Jeff.
Jeff will pose a number of Excel based Formula Challenges and then explain how some of the solutions work in a manner similar to the Formula Forensics series.
In this first post of the series we look at how to extract a string from the right of a block of Numbers in a larger string.
2013 Calendar – Excel Template [Downloads]
Here is a New year gift to all our readers – free 2013 Excel Calendar Template.
This calender has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data
There are many web pages devoted to Excel Charts and there are many web pages devoted to Creating Dynamic Ranges, but a lot of these suffer when the data is poorly organised or non-contiguous.
Today we look at a Technique for Creating Dynamic Charts with Non-Contiguous Data.