Analytics & AI for Modern Excel
Today was Day 2 of Wordcamp. Read about Day 1 here.Wordcamps are impressive. People from all walks of life with various skill sets and experience levels come together to share how to use an …
Continue Reading about Making Your Site a Center: #WCDayton Day 2 →
Analysts are constantly comparing actuals to budget. Because humans are better at processing colors than numbers, it's often a good idea to add some conditional formatting to your variances. A common …
Continue Reading about Display Negative Percentages Red in Excel →
We just finished Day 1 of Wordcamp Dayton. If you're not familiar with Wordcamp, think of it as the TEDx of Wordpress. They're independently organized events featuring talks on all things Wordpress, …
Continue Reading about Feel the Slow Burn: #WCDayton Day One →
In business, you're often fitting square pegs into round holes. Shipments of merchandise come in different quantities than you can display them.Join the MOD( ) squad!This Excel function will …
This week was a milestone. I've been in the full-time workplace for four years!Where I've ComeArmed with a bachelor's degree from a fantastic liberal arts school and a master's in finance from a …
Weighted averages aren't intuitive, but they come up in business all the time. Fortunately, Excel has a quick function for calculation weighted averages. If you're a student, you may be more familiar …
