Roosterfosho
New Member
- Joined
- Mar 18, 2013
- Messages
- 5
Hey guys quick question here, I'm familiar with vlookup and hlookup, but with this accounting course I'm currently in it's a huge table and that kind of overwhelms me.
The question is :1. Using the provided data and income statement template use the "vlookup" function in Excel to create a forecast to actual comparison for the current quarter to the preceding quarter and the current quarter compared to the prior year same quarter (Tip: number to the columns on the 'IS Data' tab for quick reference). Make sure the check figure at the bottom of the schedule is equal to zero.
The question is :1. Using the provided data and income statement template use the "vlookup" function in Excel to create a forecast to actual comparison for the current quarter to the preceding quarter and the current quarter compared to the prior year same quarter (Tip: number to the columns on the 'IS Data' tab for quick reference). Make sure the check figure at the bottom of the schedule is equal to zero.
Car Co. |