Are you marginally Excel savvy?

[naomi 343]

If yes..if you wanted someone to prove to you they know their way around some core Excel basics, what would you have them demonstrate?

 

If no,

[titans&bucs&bearsohmy! 2,745]

Ability to use simple formulas for one. Add, average, that sort of thing.

[wiffleball 4,640]

WYSIWYG?

[RaiderHaters Revenge 3,584]

Ability to use simple formulas for one. Add, average, that sort of thing.

 

this ask them to do some basic summations and subtractions, maybe a more complex Fx horizontal and vertical

 

make sure they know how to use numbers verse dates verse values

[Brad GLuckman 518]

Vlookup. Pretty basic but valuable.

[shotsup 832]

Create pivot tables

[MTSkiBum 1,594]

Vlookup, pivot tables, and sumif are the basic skills I use the most.

[Big Blue 06 195]

Vlookup. Pretty basic but valuable.

First thing I thought of. I use that and Concantenate very frequently. Also, a bit simpler: Text to Column and Sort. Easier functions but valuable as well.

[mighty_thor 115]

Give them data for a simple bidded project like building a shed.

Give them different contractors bids. Joe bid $100 square feet for walls $200 sf for a roof, $50 sf for concrete foundation. Bill bid ....

Give them the data for the shed. Roof will be 90 sf, walls 200 sf....

Then have them put all the data in a spreadsheet that calculates the total price of each bid and have them sort the contractors by lowest total price. Then give them a number that represents your budget and have them calculate the percent above or below your budget of each bid. have them calculate the average bid price. Have them calculate the percent of cost of each item as compared to the total cost for each contractor (i.e. Joe's walls cost x percent of his total cost).

[DankNuggs 305]

are you trying to show database type proficiency or mathematical? posters have covered both fairly well.

[peenie 1,690]

Make them complete an Excel test.

There are some skills assessment tests available online for free.

Never taken one though.

[KSB2424 3,083]

Vlookup, pivot tables, and sumif are the basic skills I use the most.

This.

[RLLD 3,455]

Ask them how to assign an absolute value to a variable.

[posty 2,296]

A complex IF statement...

 

Summing up columns from multiple sheets...

 

SUMIF...

 

VLOOKUP...

 

Maybe have them create a macro?

 

Have them create a multiplication table?

[peenie 1,690]

...I guess I don't really know how to use Excel, geesh. Vlookup?

(ctrl+F)

[KSB2424 3,083]

...I guess I don't really know how to use Excel, geesh. Vlookup?

(ctrl+F)

 

Just google or even better youtube it. You can learn pretty much anything for free on the internet.

 

Filtering

Sorting

Charts and Graphs

V and H Lookups

Pivot Tables

SumIF's

Formulas in a cell like adding-subtracting-multiplying-dividing multiple cells

Concatenation

Freeze and unfreeze panes

text to columns and other formatting

Macros (I personally don't use this but want too)

 

 

Stuff like that is all you need to do 99% of most anything.

[nobody 2,040]

...I guess I don't really know how to use Excel, geesh. Vlookup?

(ctrl+F)

 

 

90% of the stuff in this thread isn't core excel basics.

 

Naomi is probably interviewing for some assistant position where they need her to create excel sheets for meeting signups and maintain directories and stuff like that.

 

Without the context of why she's asking the question, it's hard to say what skills you would need, but this stuff is for fairly advanced data manipulation.

[Mookz 1,287]

Not really but I do asbestos I can.

[MTSkiBum 1,594]

beginner: Able to create a timecard, attendance llist, or something similar

 

intermediate:

vlookup/hlookup

pivot table,

if/sumif/iferror

 

advanced:

multiple functions in an equation,

array functions, these are the functions that have {} and are created using control-tab-enter

simple macros, ie create a button that copy/pastes or navigates to a different spot

 

expert:

import/export data to an online sql server database or Microsoft access

able to automatically refresh powerpoint presentations from excel

custom ribbon bars

vba programmer, ie able to turn an excel document into an application

etc

[titans&bucs&bearsohmy! 2,745]

My first job out of school I was assigned to go through a massive spreadsheet and add , TN into each address field.

 

My boss thought it has to be done one at a time. He told me I had two days. I did it in three minutes and screwed around online for a day and a half, and then got kudos for finishing so quickly.

[naomi 343]

Not really but I do asbestos I can.

 

[naomi 343]

Good posts in here, thanks geeks I have a lot of self-teaching to do.

[peenie 1,690]

...I can make a regression curve.

[Djgb13 2,338]

I used to be. But I don't use it and haven't used it in years so I've forgotten a lot about it

[parrot 789]

...I can make a regression curve.

 

I'll bet you can.

 

Yeah, I don't even know what that means.