by admin | Mar 1, 2018 | Case Studies - How To
Recently I got asked by a colleague to help her identify compare two lists of providers in Excel. In one list there was a list of providers available in May. In the other she had a list of providers available in January. She wanted to identify what providers were in...
by admin | Oct 11, 2017 | Random
[ordered_list style=”lower-roman”] Table it! If you have large data sets, convert them to a table. This means that if you scroll down to the bottom, the headings will remain visible at the top Hide! :Hide the columns/rows you don’t need. Top row visible:...
by admin | Aug 15, 2017 | Random
September can be described as the new January and it’s often a time when people decide to start something new or get stuck into something they have been thinking about learning. Dare I suggest that could be your Excel skills ?In this blog post I am offering...
by admin | Jul 24, 2017 | Case Studies - How To
In a class recently the subject of age calculation came up, which reminds me of when my son was young and would ask me how old I was. “19”, I would say succinctly. He was at the age when he was learning basic maths. “So what would make you 12 when...
by admin | Jul 4, 2017 | Tracking Training Records in Excel
A common issue for many organisations is tracking time-in-lieu i.e. someone has a certain number of days/hours holidays(vacations) allocated but they can increase that by doing overtime and then taking time off – “in-lieu”. While some organisations...
