Formula Forensics 022. Sum the Odd Numbers between 1 and 100
How can we Add Up the Odd numbers between 1 and 100 ?
Highlight Employees by Performance Rating – Conditional Formatting Challenge
So who is up for an Excel challenge?
Shelly, who is an HR Manager sent this distress call last week,
“I have a group of employees- lets say 100 employees. Each employee has a performance rating attached to them. I want to divide the group by 5%, 15%, 65%, 10%, 5% based on their performance rating.”
And that is our challenge today. Read on & help Shelly.
Formula Forensic No. 021 – Find the 4th Slash !
No, Not that Slash !
How do I find the 4th Slash in a text string?
Today at Formula Forensics we take a look at 4 different methods.
Interactive Sales Chart using MS Excel [video]
Finally, I got some time to sit down and do what I love most – write a blog post to make you awesome in Excel. After a whirlwind trip to Sydney, I am back in India to spend few days with my kids & wife before rushing to Australia to run 2nd leg of my training programs (in Perth, Melbourne & Brisbane). I did 2 sessions in Sydney – one for KPMG and other for public and both went very well. We got lots of positive feedback and people really loved it. I am saving the details for another post, but today lets talk about Interactive Sales Chart using Excel.
Take a look at the Interactive Sales Chart
First, take a look at interactive sales chart. Today, you will learn how to build this using Excel.
Formula Forensic 020. Bhavik’s Monthly Workingdays Formula
Bhavik’s has presented us with a neat formula to determine how many working days are in a month.
This functionality has a wide range of uses in accounting, payroll, staff scheduling, accommodation planning & reporting and general scheduling activities.
Today in Formula Forensics we pull Bhavik’s Formula apart and see what is going on inside and the offer some extensions to increase the functionality of his formula.
An IF Formula Challenge for you
If I were to hire an data analyst, I would simply ask them to write a complex IF formula in Excel. If they can write it, the interview progresses, else, they are out. In other words,
=IF(person_can_write_big_fat_IF_formula=TRUE, proceed_with_interview, say_thanks_and_call_next_person)
If you are able to write IF formulas for any situation, then you are bound to be awesome in Excel.
So, to test how well you know your IFs & Boolean functions, let me give you a small challenge.
Formula Forensic No 019. Converting uneven Text Strings to Time
I have imported some data that comes in as a number that I need to convert to h:mm. The data string will be either 1,3,4,5,6 integers long and looks like this…
Help