Can anyone help me on Spreadsheets ( data validation)
Clarekaye
Registered Posts: 307
I am using Osborne books and have come to a bit I am stuck on,
I need to format a cell so I can have a drop down box with the months in (Jan, Feb etc)
How do I do it :crying: tried so many different ways, I dont use excel to this level on a daily basis
I need to format a cell so I can have a drop down box with the months in (Jan, Feb etc)
How do I do it :crying: tried so many different ways, I dont use excel to this level on a daily basis
0
Comments
-
I am using Osborne books and have come to a bit I am stuck on,
I need to format a cell so I can have a drop down box with the months in (Jan, Feb etc)
How do I do it :crying: tried so many different ways, I dont use excel to this level on a daily basis
Hello,
Here is a handy link for the specific task you require... http://www.contextures.com/xlDataVal01.html#Dropdown
It contains a step by step guide for dropdown boxes or you can follow the video.AAT
Level 2 - 2011
Level 3 - 2012
Level 4 - 2013
ACCA
F4 - Corporate Law - Dec 2015 (passed)
F5 - Performance Management - Dec 2014 (passed)
F6 - Taxation - Dec 2013 (passed)
F7 - Financial Reporting - Jun 2014 (passed)
F8 - Audit & Assurance - Dec 2015 (passed)
F9 - Financial Management - Jun 2015 (passed)0 -
Awesome thanks I will look when I get home tonight,
Have you done Spreadsheets, or anyone else done it, how long did it take you to study for it?0 -
Awesome thanks I will look when I get home tonight,
Have you done Spreadsheets, or anyone else done it, how long did it take you to study for it?
Yes, i have completed the Spreadsheets unit. I revised for a week, a few hours a night. I was already an advanced Excel user so I was quite familiar with most of the functions.AAT
Level 2 - 2011
Level 3 - 2012
Level 4 - 2013
ACCA
F4 - Corporate Law - Dec 2015 (passed)
F5 - Performance Management - Dec 2014 (passed)
F6 - Taxation - Dec 2013 (passed)
F7 - Financial Reporting - Jun 2014 (passed)
F8 - Audit & Assurance - Dec 2015 (passed)
F9 - Financial Management - Jun 2015 (passed)0 -
Has anyone tried the learning zone on aat, for example scenario 2, its confusing the hell out of me.
Trying to vlookup between sheets?? Will I get asked this in the exam, I havent been taught it.
:huh:0 -
If it is on the syllabus and indeed on the learning zone, I would suggest that it is examinable and would therefore urge you to practice this function alongside the others which you need to learn.~ An investment in knowledge always pays the best interest ~Benjamin Franklin0
-
Any ideas how you make the lookups go across sheets?
I did the lookup the pasted it across but its just showing ref!
I hate this stupid section and due to my exam venue being idiots I am stressing cos I dont have alot of time0 -
Oh I found it by accident Fab :thumbup1:
Scenario 5 video!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 156 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership