Kapalı

seeking an Excel tutor to walk me through problems below...

Hello- I'm seeking an Excel tutor- who can you recommend w/ bandwidth? Over the years I've built up a bunch of specific questions in the following areas which are intriguing me:

1: Arrays, LOOKUPs, and IFs

2: Excel 'forms'

3: Charts repopulate based on dropdown selections

4: 'Dashboards'

5: other misc topics

I understand solutions for some of these have been published already (e.g. on Excel MVP or Microsoft discussion boards) but I'd still like someone to walk me through. I can't pay US$40 or $80 or some large amount per hour, but perhaps you know of someone willing to work with me at a lower rate?

Does this sound of interest to you? If so please advise which areas you'd be comfortable tutoring on and what your earliest start date would be.

With thanks, Chris

Area #1: In Excel counting, how do you...

a) In the sample data set below, what formula/array will return the count of large red circles? (Example data set, where commas represents cell delimiters, answer should be 2 because large red circle appears twice)

IdNumber,Color,Size,Shape

1,Red,Large,Circle

2,Blue,Small,Triangle

3,Red,Medium,Square

4,Red,Large,Circle

5,Red,Medium,Triange

6,Blue,Small,Circle

b) How do you count and sum on values selected from dropdowns? (i.e. are they stored in cells just as if they were typed in, not selected from a listbox?)

c) How to set up a 'stacked' bar graph of data in (a) based on one attribute (e.g. where there'd be 2 mixed bars, one for red and one for blue)?

d) How to set up a stacked/mixed bar graph based on a different attribute? (e.g. where there'd be 3 bars: one for all the circles, one for all the triangles, one for all the squares)

e) How to choose between using arrays, LOOKUPs, and IFs?

Area #2: How can you make Excel act like MS Access (when you don't want to use a database program instead...)?

a) e.g. how to add text entry & dropdown tabs to a sheet (called, say, DataInputSheet) with a 'submit' button triggering those values to be added as a new row to another sheet (called, say, DataStorageSheet).

b) preventing cell data on a row from being accidentally altered ('fat fingered') if a certain value appears (e.g. if the value 'Closed' is selected as a dropdown value from a column called 'Status')

c) if you don't have a MS Access 'report' to generate, can you have an MS Word doc that displays a(n embedded) MS Excel table of values in the middle of it, which reads an external xls file and gets the latest values from that xls each time the doc is opened?

d) can you have an MS Word doc that contains an Excel grid in the middle of it, where data can be entered/updated such that it will recalculate on the fly and otherwise act like a 'live' xls in the middle of a doc... though there is no external xls source being read from? (i.e. the Excel table & cell contents are all contained within the doc as an Excel object)

Area #3: How to set up charts where both x-axis and y-axis values can be dynamically selected from dropdowns?

(I have a working example of this, but I can't figure out exactly how it works... there is a term in advanced Excel for this type of functionality... you can see it in the example graph I have... perhaps you could look that up & give a tutorial on how it works)

Area #4. How in Excel to build a 'dashboard'?

(a) Is this solution in the public domain? If so, can we please walk through it? I believe there already must be working xls examples of this, or at least instructions published as to how to make them.

(b) This should include 'speedometers' etc. if possible.

I.e. using data set from #1 above, create a 'dashboard' that will read a user-defined threshold values for when to turn a bar yellow (say, if more than 3 large red circles exist on DataStorageSheet) and when to turn it red (say, if more than 5 are found.)

I.e. 'progressively' shade bars, so that say the first 2 blocks of the bar counting Large Red Circles are green (bec 2 is below the warning threshold), then the 3rd and 4th blocks are yellow, then 5th and above are red?

Most ideal of all, the contents of the dashboard would be customizable based on user-defined choices, i.e. on a Customization tab the user could check/uncheck which quadrants to appear in the dashboard... I know this may be very very advanced functionality typically provided in VB or with third-party controls, but if possible it'd be great to have it in pure Excel/VBA...

Beceriler: .NET, Excel, Microsoft Exchange, OSCommerce, Twitter

Daha fazlasını görün: excel dropdown set value, tutor figure know, excel tutor, working arrays net, working solutions data entry, use type graph, graph use data, what graph, work values, we excel, net using arrays, net arrays tutorial, net array example, net array, vb dashboard, vba tutor, using array net, tutorial solution, tutorial problems, tutorial graph, tutorial data entry, sum solutions, square d, solution tutorial, solution problems

İşveren Hakkında:
( 0 değerlendirme ) Karachi, Pakistan

Proje NO: #701317

23 freelancer bu iş için ortalamada 44$ teklif veriyor

spalmer1

Dear Anasqazi, Thank you for posting on Freelancer. Kind Regards,

in 2 gün içinde50$ USD
(1 Değerlendirme)
2.5
rajprithivim

Dear Sir, I am Prithivirajan from chennai. I am very interest for working with your project. So, Please give the details of project. I am waiting for your reply sir. Regards, M. Prithivirajan Cell : +91-96 Daha fazlası

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
sardarhere

Hi, If you’re looking for a great work within time, I’m of course the person you want to hire. I can get this done for you in specify amount of time. I understand you’re looking for someone to seeking an Excel tutor Daha fazlası

in 25 gün içinde120$ USD
(0 Değerlendirme)
0.0
push0823

you will get the solutions of your queries in a file, with each & every step explained, it's all your's.

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0
princejijk

I can solve your problems, as I'm very much familiar with Excel's functionalities.

in 10 gün içinde99$ USD
(0 Değerlendirme)
0.0
harish07

See my profile. I have more than 4 year exp in vba and excel. I had created N number using VBA. Try me, I will make sure that you know micro details of VBA. I have a good communication skills.

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
koustuv333

I am working as a DATA analyst in Dell International.I do conduct excel classes.I am interested in this not only for money but its the learning which excites me more.you can even negotiate on the pay a bit more.we can Daha fazlası

in 10 gün içinde30$ USD
(0 Değerlendirme)
0.0
SChohan

Hi, I can help in all areas. I am an advanced excel user who has also tutored in the past. All problems can be achieved.

in 3 gün içinde40$ USD
(0 Değerlendirme)
0.0
hassankhalid33

sir pleas =================

in 2 gün içinde32$ USD
(0 Değerlendirme)
0.0
polashshah123

i m expart

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
alexeiPF

I'm ready to explain you the things you are interested about. Also I can show samples of these techniques usage. I'm fond of Excel and its possibilities although I'm not a programmer, but I use Excel a lot in my work Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
vamsiksmile

I have worked on excel and VBA for excel for a period of 5 years till date. I am currently into software training for the company I work as an employee. I have worked on complex spreadsheet solutions ranging from ch Daha fazlası

in 5 gün içinde40$ USD
(0 Değerlendirme)
0.0
MariusRO

Hi, I have strong Excel and Excel VBA experience, including ADO, DAO, Email, pivot tables, dynamic charts, Excel-Access connection, etc. Also I am fmiliar and have strong experience with most of Office Applications V Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
PriyankaRandive

I wll try my best to answer your questions

in 30 gün içinde100$ USD
(0 Değerlendirme)
0.0
selimhossen

Dear sir, please see my PMB

in 30 gün içinde30$ USD
(0 Değerlendirme)
0.0
beeta17

i consider myself best for the task

in 30 gün içinde50$ USD
(0 Değerlendirme)
0.0
pravinrin

Dear Chris, Solution for Area #1: a) Assuming the data is copied in a cell range A1:D7. One of the formulas to find the count of large red circles is =SUM(IF(B2:B7="Red",IF(C2:C7="Large",IF(D2:D7="Circle",1,0),0) Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
cneeta

Hi, I am a software engineer taking a break to raise my kid. I am very keen on working with you on this project. I am equally excited about the work, any reasonable amount is fine with me, I am more interested in the w Daha fazlası

in 7 gün içinde30$ USD
(0 Değerlendirme)
0.0
polash206

i m very expart

in 5 gün içinde40$ USD
(0 Değerlendirme)
0.0
ashwini9977

Ready to execute your project. Let me know if you are interested in our bid. Thanks.

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0