ACT NOW
Write a review
Terms & Conditions

Write a Review & Win Career Coaching
Complete one or more product and/or service provider reviews for a chance to win sessions with renowned executive career coach Cindy Kraft.

WHY JOIN?

Expert Advice and Guidance
Exclusive Tips and Tools
Latest News and Info
Networking with Peers
Noise-Free and Professional
It's all FREE

Learn more..

Terms & Conditions

Excel questions and tips

Go to Group home page
You must register or login in order to post into this group, see full comments, or download resources on Proformative.
Group Type: Open
Posts in this group are public

About the Expert

John Kogan

CEO & CFO

Events

Feb-07 - San Francisco
How CFOs are Driving Growth

Feb-08 - Webinar
Unlocking the Value of Dynamic Financial Planning

Feb-09 - Webinar
Financial Consolidations and Reporting Optimization across the Enterprise

Feb-14 - Webinar
T&E Expenses: Leveraging Technology to Establish Visibility and Control

Browse Our Library of White Papers

Browse our extensive library of free white papers focusing on the latest financial, technology and business issues.

Learn more here!

Subscribe to our newsletter

Most Popular Group Content


Best design of a spreadsheet for layering of four different projects into one projection timeline
Headcount forecast in Excel
What's your greatest challenge with Excel?
21 best Excel shortcuts — all in one place
Favorite keyboard moves: cover a lot of territory in a spreadsheet quickly w/o using the mouse

Excel questions and tips

Excel

Excel is one of the most powerful tools at the disposal of businesspeople today. It is also one of the most widely used. Most people only use a small fraction of its capabilities. This group exists to help you get the most out of the tool and increase your productivity and effectiveness.

What's your greatest challenge with Excel?

Posted Thu, 12/15/2011 - 11:05pm by Charley Kyd (Founder)

Excel blogs are filled with specific questions about using Excel. So I thought it might be useful to back up and ask a more general question: What types of spreadsheet tasks are causing particular problems at your company, and why?

3 Comments

see details...

Headcount forecast in Excel

Posted Wed, 08/03/2011 - 1:31pm by Jerry Goldberg (Principal)

I have a headcount forecasting worksheet in workbook an ex-employee left behind that has some holes in it. I need a formula in Excel that populates a headcount grid by querying the cells for each employee's start date, and also a formula for allowing for percentage raises . Any brilliant Excel modellers have ideas?

9 Comments

see details...

Help using Excel to find semi-structured data in a database

Posted Thu, 05/05/2011 - 10:21am by Dan Ryan (CFO)

Hey folks. I have a database of names and companies and i am trying to normalize the list against a reference list of companies (the Fortune 500). The data looks like the following: John Doe Abbott Labs Jane Doe Abbott Laboratories Jeff Doe Abbott Medical Devices

5 Comments

see details...

Best design of a spreadsheet for layering of four different projects into one projection timeline

Posted Mon, 07/12/2010 - 4:40pm by Shane Connolly (Acctg/Finance Profession)

I am in the process of building an Excel spreadsheet to project cash flow for four distinct projects that will make up one cash flow projection. The product to be delivered for each project is the same, but the number of units of product delivered to each project each week and the total number of units delivered to each project will differ.

1 Comment

see details...

Favorite keyboard moves: cover a lot of territory in a spreadsheet quickly w/o using the mouse

Posted Mon, 01/25/2010 - 11:32am by John Kogan (CEO/CFO)

I don't like using the mouse. I guess that makes me a PC guy (as opposed to a Mac guy). I find it more efficient to keep my fingers on the keyboard at all possible times. My favorite keyboard shortcuts for moving around a spreadsheet involve moving using the control + arrow keys to zip from end-to-end in a contiguous set of cells.