You've come across the term CAGR and want to know how to calculate it in Excel? This post gives you three different ways to do so in Microsoft Excel. But, first, let's understand what CAGR is.
3 ways to calculate CAGR in Microsoft Excel
Tag: Office
Excel Tutorial: INDEX MATCH primer
Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we'll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.
Excel Tutorial: VLOOKUP primer
Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we'll use VLOOKUP to find a value from the table. Firstly, let's create the above table in Excel.
Excel Tutorial: Introduction to VLOOKUP, INDEX and MATCH functions
Excel has several lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.
Share Collaborate Notes & Documents Online With Springnote
If you working on some project or presentation and what to share the work with your fellow buddy that very second for some corrects or proofreading, then what you do? Springnote is web 2.0 service which makes real-time collaboration on office documents and notes easy, here other users can comment, and add content as needed.
Schedule Office Shifts Online with FindMyShift
Working at the call center was one of the best experiences I have ever earned. Like any other company we also had issues and the one that annoyed me the most was the one with our scheduling. I don't think anyone appreciates the fact when your boss calls you at an unexpected time and tells to show up at the office in a different shift.
How to change the default color scheme of Word
By default Microsoft Word 2007 comes with a blue color scheme. However, Word 2007 also comes inbuilt with two separate themes, viz. Silver and Black.
Protect yourself with NOD32
I rarely write about or review paid software on this blog. There are several free anti-virus software available on the internet. And many of them do an excellent job.
ProduKey (Tool Tuesday)
So, you realize it is time to reinstall your operating system and all the other software that you require. And then you realize, "Now where did I put those serials!" This is where ProduKey comes to the rescue.
pptPlex (Software Saturday)
A normal Microsoft PowerPoint 2007 presentation flows in a linear fashion. You can break the normal flow using hyperlinks in the presentation. This works perfect in most presentations.