thank you, went into a staffing agency for medical administrative assistant and they had me do an excel test and I bombed it. thank you for making it easier for me. I went back and got the position.
@latikamartin2368
6 жыл бұрын
Good job
@ThePurpleElephantt
6 жыл бұрын
How long was it and what did it consist of?
@bmassey1288
5 жыл бұрын
Congrats. That's what I'm preparing for
@Ss870920
4 жыл бұрын
Mam any job for me i am spreadsheet data entery/lead generation specialist and internet researcher.
@DIVALittleWing408
8 жыл бұрын
Thank you! I appreciate you taking time to teach those of us who lack excel knowledge.
@Theresabrown1805
4 жыл бұрын
I am so glad I found this I am just starting to learn Excel and I find it so interesting I really like Excel these tutorials will really help in my job search. I never realized there was so much you could do with Excel and never thought there would ever be tutorials on KZitem I am so glad there is. So much better than trying to find books and learning from them this way I feel you learn so much more and gain so much knowledge.
@anacarolapers
4 жыл бұрын
Thank you for sharing. I know how to use excel and word of Microsoft but to be honest I was asked what commands I need to use to do the same work. Today companies make this crazy test and they are odd to me as Adm Assitant I know how to work but I am not IT. I wish they can change their way
@jaquig3976
9 жыл бұрын
Thank you for being entertaining with your voice and showing the buttons you are pressing on the keyboard! Out of ALL the videos i watched, you were the most entertaining :)
@christinamitchell9622
9 жыл бұрын
On the task #5 the G-10 they seem to be referring to seems to be the row under the G-10 in the A12 cell. It would explain wanting a total for all the numbers in each cell. My guess anyhow. I'm hoping to pass a similar test in the am, so thank you for this,
@rottyangel770
7 жыл бұрын
You are a really good teacher! You go a bit fast, but you really make it easy to understand for novices like me. Do you do any other videos on Excel or Word? Or even Quickbooks? Please let me know if you have a chance. And I mean this guy, not somebody else, I really like him.
@adeleamra
8 жыл бұрын
Thank you. I have one of these tests tomorrow and I'm hoping it's this easy. Fingers crossed.
@Anchor5777
7 жыл бұрын
Thank You. I have to do an assessment test for Word and Excel by Thursday and I want to pass it.
@Chastonicity
5 жыл бұрын
Excellent clear explanation even with the error from the test by the test maker.
@SirValiantIII
6 жыл бұрын
Came here expecting a more advanced video, but I was impressed by your teaching style and wanted to say this is a great video and would've been perfect for me in earlier stages of my excel career :)
@RachelleBeyer
7 жыл бұрын
This is too funny - same thing happened to me! "We love your resume and cover letter; can you come in for an EXCEL COMPETENCY TEST?!" AAHHHHH! WHAT?! Lol.
@franciscolorenza
6 жыл бұрын
Jane Beyer that was me this week. 😭
@ThePurpleElephantt
6 жыл бұрын
lorenza Francisco how did it go? What did it consist of?
@jdunlap8339
5 жыл бұрын
OMG! ME TOO!!!!
@anacarolapers
4 жыл бұрын
My friend who did great oversees and is American came back to America and for a crazy test, she failed.
@Ss870920
4 жыл бұрын
Mam any job for me i am spreadsheet data entery/lead generation specialist and internet researcher.
@angelicaceccon
5 жыл бұрын
Hi there! Thanks for this video, it was very helpful. The instruction 5, that you said was confusing, it was actually talking about A13 (G-10 is the name of the product in row A, line 13) create a total below that line, which you did right, but just skipped a line. It got me confused as well to start off with but then I noticed the name inside that cell and it all made sense! Hope this helps! Xx
@pantinaprovina42
9 жыл бұрын
Thank you for making this video. I watched it right before taking a basic excel 2010 test a recruiter sent me and it was all very similar stuff.
@wgpearcelb
9 жыл бұрын
Wow!! AMAZING! Great applicable video to people learning excel in general or studying for an exam!
@sherrihollon1365
6 жыл бұрын
i need help i know how to do basic simple formulas but i need to make a formula that automatically calculates total price for any amount of units placed in c12 my formula needs to be in c13 but... the units are not in just number the unit column says 1 to 10 and colomun beside says 20 then 11 to 19 next column 18 so if i type the nimber 5 in c12 i need it to give me the price im not sure how to do this please help
@ronaldtipton6035
8 жыл бұрын
Wow, this is way easier than any other Excel test I've seen on the internet. The whole thing would have taken me 90 seconds tops. Probably not a good test to determine if you know anything beyond basic Excel knowledge.
@SaucyWench7
5 жыл бұрын
How many people were yelling at him about not finding the G10 in the spreadsheet?
@paigefricker3972
5 жыл бұрын
Oh I so was!
@555_Lady_JB
5 жыл бұрын
Haha.
@AmieMimiNg
5 жыл бұрын
OMG I was 😂😹 and now I see this comment, it's even funnier.
@dickJohnsonpeter
5 жыл бұрын
It was dumb to name the product "G-10" though.
@RCbeastly
5 жыл бұрын
Not really - there is a floor lamp model G-10. The dumb part was the ambiguous wording - they should have specified Product G-10.
@Nuron666
5 жыл бұрын
schoolofbookkeeping - I was wondering if you could tell me how to set a row of cells to 1 particular Font and size. For example font calibri and size 11. So if I copy some texts with different fonts and sizes and paste it to these cells. It automatically sets the texts to calibri font and size 11.
@portia_eportia
8 жыл бұрын
You have one of the best video on excel....very clear and right to the point....Thank you so much.....
@nickolefrazier1311
7 жыл бұрын
How To's and InterestingThings whats the points. test tomor. still confused. help??
@jackbmeere5367
5 жыл бұрын
Question 5 refers to "G10" which is actually in position A12 on the spreadsheet, "Create a row under G10 and label it as Total" although, I do agree with you it's a badly set question. Also, I noticed you missed Question 6 which asks you to "Calculate the total revenue for each quarter" I sure hope you didn't miss out on questions in the real Excel Test.
@PeterAdiengSS
9 жыл бұрын
Great basic accounting short cuts keys , i have learn different ways of doo-hickey too .. great job .. Its easy for me now .
@mkaysartfuljourney1239
5 жыл бұрын
Under product on cell a12 there is G10. That's the G10 they were referring to, right.?
@demontbowden7394
6 жыл бұрын
At 3:41 when you click and drag the cells that you want average, do you hit enter afterwards or tab? Thanks.
@Message167
5 жыл бұрын
You just saved my entire life, existence and soul.
@Ss870920
4 жыл бұрын
Mam any job for me i am spreadsheet data entery/lead generation specialist and internet researcher.
@araceliscarbonell587
5 жыл бұрын
It is not clear to see the course visually, but thank you for this insight
@jayjohnson165
5 жыл бұрын
Just took a basic knowledge excel 2010 test tonight for work. Failed. Not allowed to use any keyboard short-cuts, functions have to be manually entered(cant use the function button), and every question it asks if you are sure of your answer.
@wilowb01
5 жыл бұрын
Thisbis great. Thabk yi but why "1.2" to add the 20% increase? How does that work? I LOVE excel bit am not a mathmetician...at all!!!
@sallysrock8488
9 жыл бұрын
If you want to pass the test, don't use any shortcut keys. Use the menu on top.
@chrismcquade4424
9 жыл бұрын
+Sallysrock I disagree. Usually a strong candidate can navigate Excel using only the keyboard with no mouse.
@Hydebehindthemask
9 жыл бұрын
+Chris Mcquade While technically true, a lot of places don't want you using the short cuts. It seems silly to me, but I know of a few people who have been told this when they've done testing for excel and other programs.
@JenOween
6 жыл бұрын
I can confirm this. Microsoft testing does NOT reward you for shortcuts. They want you to do it their way, not whichever way is fastest. They want the actual text book method. Using shortcuts will end up in a failing grade for any MS certification.
@JenOween
6 жыл бұрын
You can disagree all you want. The title of this is how to pass an Excel test. If this is an actual, official Microsoft certification exam, shortcuts will only get you a failing grade. They want a test candidate to follow the text book method. While practical us is obviously different, but for true testing purposes, text book method is all that matters.
@dickJohnsonpeter
5 жыл бұрын
@@JenOween The shortcut are programmed into the software for a reason. If Microsoft didn't want you using them they wouldn't exist. That's just a fact.
@rickardohowell7242
7 жыл бұрын
Create a row under G-10... In A-12 there is the item (G-10) in which I think you are asked to create the total column
@latanyahambrick455
10 жыл бұрын
Hey, this video was very helpful, but I did not understand how you got the value (814*10*.5) for the 20% increase. How did you get the 814?
@nerdenterprises
10 жыл бұрын
I don't know where you see 814. Or 10, or 5. I took a number based on a cell reference and multiplied by 1.2 to get the final result including a 20% increase.
@nerdenterprises
10 жыл бұрын
I don't know where you see 814. Or 10, or 5. I took a number based on a cell reference and multiplied by 1.2 to get the final result including a 20% increase.
@bobasdfsdf
10 жыл бұрын
It's "B" 14, the cell reference for quarter 1's total revenue.
@katiewalsh9589
7 жыл бұрын
Never thought I'd be yelling at a youtube video of someone making an excel spreadsheet but here i am...
@1985hoola
6 жыл бұрын
Same
@Fortnite-xf5dj
6 жыл бұрын
Katie Walsh same lol
@Uarehere
7 жыл бұрын
This is the easiest Excel test I've ever seen. I thought bookkeepers knew Excel really well!
@Danirausis
9 жыл бұрын
Just a hint, at 3:52 you use CTRL + V, etc... when you could use the fill handle. It would be quicker. By the way, thanks for the video.
@danaguyer8863
6 жыл бұрын
I believe G-10 was not the cell information but the product name to create a total under the last product name. thanks. Great video
@l.crayton3999
6 жыл бұрын
Thanks for the upload but most excel tests don't allow use of quick key combos
@megf5124
9 жыл бұрын
thanks so much! you make it seem very easy. the only thing that was confusing was the end, but I'm not that good with numbers, so that's me...lol. I'm going to go try to memorize all the shortcuts before my test tomorrow lol *eek*
@kimberlysmith3379
6 жыл бұрын
Can we go into more detail about “doohickies”?
@kmcl11
10 жыл бұрын
Thank goodness for this side of youtube.very helpful tips.
@74Systemsdotcom
10 жыл бұрын
Glad it helped!
@phungdung8047
9 жыл бұрын
alt+ (The short cut for Total row). Thanks.
@KaoruMina
7 жыл бұрын
hahaha I got same confusion on the "G10" part and I was looking for the cell reference ! I'm glad that was an instruction mistake because I was thinking I was the wrong one.
@TheFallibleFiend
9 жыл бұрын
G-10 refers to the item in the product column, not to a cell.
@fitfrederick5411
10 жыл бұрын
You made me laugh! Horray! On a day like today that is definitely a reason to smile. It's how you talked during #5. I can't wait to get my MSO cert and train. Training is FUN!
@74Systemsdotcom
10 жыл бұрын
Glad you got a laugh (and hopefully learned something too)!
@IAmEverythang
6 жыл бұрын
good video, appreciate quick tips, very easy and to the point
@thesalsalady173
6 жыл бұрын
I just took a test for a bilingual secretary job, I did pass the Spanish part with high score but failed the excel test, lol learned my lesson. Learning excel is such a piece of cake, try learning another language in a couple of weeks!!
@starrynight8007
6 жыл бұрын
+Curious Cat 77 - NOT FAIR -- LEARN ENGLISHHHHHHHHHHHHHHHHHHHHHHHH
@thebesttechnical3608
5 жыл бұрын
Very useful information nice video
@adonica1
6 жыл бұрын
Sorry, but I'm a little rusty with my math. How do you convert the 20% into 1.2? Just in case my question on the test is a different % increase. I would like to be reminded of the formula. I know that it may be a stupid question, please forgive me.
@ThePurpleElephantt
6 жыл бұрын
Adonica Blevins Hi, did you take the test? How did it go? What did it consist of?
@laurensrule421
6 жыл бұрын
.2 is 20% but you want to add the number you started with to the 20% so you put a 1 in front of the decimal... 120% or 1 + 20%... hope that helps
@lisad174
5 жыл бұрын
No need to apologize for what you don't know. Think about that. It's okay. It really is. We all have huge gaps. It depends on who is asking the question and how arrogant they are.
@jettar.2398
6 жыл бұрын
THANK YOU! You made look sooo easy ☺️ specially the way to talk. 🙏🏻👏🏻
@terriessterling4209
6 жыл бұрын
Good morning Thank you, I'm a stay at home mom for now, But I needed to learn Microsoft office, so thank you for teaching abilities
@sassybooper6185
6 жыл бұрын
Hi thank you for all these information don't mind all the negative comments, if they are such experts on excel what are they doing watching this kind of tutorial.....LOL nobody is perfect!!!!.. I learn some tips & tricks I didn't know how to do, sorry I didn't need this kind of tutorial until now, I'm old school since Lotus 1,2,3....HAHA!!!! Nobody knows what's that. Thank you for your time.
@oachilis
6 жыл бұрын
I got a question cuz for me i failed my exam with a 69.7 only 1 more question to pass but the reason why i failed is when i skipped 2 question and submitted it and the question IDK which is "use shape to add vertical scroll" and i was in insert then shape for 30 minute trying to find vertical scroll and i couldn't any helps? and the 2nd following question would say input the text that give me into vertical scroll i forgot what it was and i skipped it which i coulda passed bruh i am still tryna figure how to do it cuz tomorrow imma retake the exam
@Scott-kc5fg
9 жыл бұрын
It wasn't asking for column G row 10 but the last product which it didn't make clear.
@RevJoe98
10 жыл бұрын
When I type in =, and then go to B14, I then press the * sign, and then 1.2 (=B14*1.2), after that I hit enter, and it says #VALUE! But I'm mimicking him on his steps. What am I doing wrong?
@74Systemsdotcom
10 жыл бұрын
Check what is in Cell B14. Sounds like you may have a null value in there which can happen if you select a cell, hit a space bar and then hit enter. Make sure you have a numeric value properly formatted as a number (not text) in B14.
@RevJoe98
10 жыл бұрын
schoolofbookkeeping.com Got it! When I copied what was in my cell I noticed that there was a space, sure enough! I am totally new at excel, but need to learn it for possible jobs. Thank you for your help, and super quick reply! It was driving me up the wall! I feel more comfortable able taking a test on it for a job now! Again, thanks!
@Aliakbar-wq3jl
2 жыл бұрын
20% increase revenue per quarter = how it will come 1.2 . Just i wants to know about that. How it's coming 1.2 can you help me on this
@clarissaforte6048
9 жыл бұрын
Thanks for the video it is very helpful to me. Just last week I was ask to take the excel test for replacement and this is very refreshing. Again thanks!
@TheMargarita67
10 жыл бұрын
hey did you do the second part of this?
@Alfernaful
5 жыл бұрын
Does anyone know if this is what basic Staff Assistant |||” excel testing consists of? It will be my first exam 😊 thanks guys!
@monarch.war2024
7 жыл бұрын
Create a row under G-10 means ...the cell value of A12 is G-10..so you need to label the row as Total I guess..
@rokonerthikana
9 жыл бұрын
how much time am i suppose to get for this type of task
@videosrus99
6 жыл бұрын
5 minutes should be more than adequate to provide the answers plus 5 minutes to carefully read the questions first.
@Tempest13
5 жыл бұрын
Where did you get 1.2
@KellyKels23
5 жыл бұрын
I have to take 2, intermediate and advanced and I know i'm going to fail it because i'm horrible at excel and have never had to use it to do more than copy and paste. I could answer all of these questions except for the last one. Dreading this.
@rottyangel770
6 жыл бұрын
Thank you very much for this. BTW for people wondering, the doo hickey he refers to is the dialog box arrow, I think, lol.
@Ari_speaks
6 жыл бұрын
you are hilarious thanks for making excel fun
@doing4
5 жыл бұрын
This is super helpful. However, G10 conundrum needs to be clarified :))
@FootyShorts510
3 жыл бұрын
Damn I missed the webinar by 6 years lol
@kolafashoyin7270
5 жыл бұрын
They meant the content G-10 which is cell A12 to create the row
@martavavautube
6 жыл бұрын
is this an elementary excel test?
@brightside1431
6 жыл бұрын
but how can i calculate the percentage increased on Q1-Q2?
@taniaqureshi9867
8 жыл бұрын
Great shortcuts!
@brianspiller9075
5 жыл бұрын
"Angry rabbit" I was wanting to create a Pivot Table with Conditional formatting, with Slicers and accompanying Pivot Chart.
@worktogheter
9 жыл бұрын
love it at 4.22
@willagreen3043
8 жыл бұрын
This teacher guy just wants you to know how smart he is. A good teacher knows what you need to know.
@Zoim
6 жыл бұрын
can you please explain the 1.2 for the calculation of 20% increase ? i didnt get it :) thanks :)
@videosrus99
6 жыл бұрын
Are you serious? If you are, then a 20% increase equals 120% of the original figure (100% + 20%). So, multiply the original figure by 120% then divide by 100. [120/100 = 1.20 or 1.2].
@Zoim
6 жыл бұрын
ok now i get it. thanks
@ridealongwithnicolle1581
5 жыл бұрын
Thanks for sharing. Was really helpful
@klaymonkey9073
6 жыл бұрын
We need to custom hot key functions in Excel. Then we could use an MMO mouse.
@rbetan1160
9 жыл бұрын
a bit confusing instructions indeed. But I think they mean G-10 meaning the last product code on their product list. So your row of TOTAL would be in row 13 from Column A through F. I would not have used this nomenclature as product codes when these are also the same as references to columns and rows in excel. But maybe they did that on purpose ;-]
@LightworkBeacon
4 жыл бұрын
Don't they want a row added directly to the chart below G10 product? Also, The 'doo-hickey' is a LAUNCH BUTTON.
@lakeisharunnels8151
6 жыл бұрын
Thank you extremely helpful I have a test hope this works!!!!
@wendylatham2166
5 жыл бұрын
Lakeisha Runnels did it work?
@raquelal2066
6 жыл бұрын
I have applied for a Benefits role and they are asking me to go for an excel competency test, I don't get it!!! why are they asking me to take a test if the position is not for a clerical role?? probably they have somebody else already to be hired for this position.
@beattx2662
7 жыл бұрын
that was great thank you so much for posting this
@RaymondJerome
5 жыл бұрын
you fail. for 5. select all A5-F12 and press one single icon on your strip to make a new row that is the totals of each of those columns. essentially 2 actions, a single select and a single click
@thobekamabaso9963
6 жыл бұрын
thank you so much for doing this for us
@suzannelewis3772
6 жыл бұрын
Love this!
@Berghiker
5 жыл бұрын
Just what I'm looking for.
@BlackTearsAHH
9 жыл бұрын
Thank you so much! This was very helpful!
@videosrus99
6 жыл бұрын
I no longer take Excel recruitment tests as many questions are ambiguous and do not allow the use of shortcut keys, which prove knowledge of the program. Not only that, but some of the tests use old Excel programs which have been updated several times. Why would I want to be tested on Excel 2003 when we are on version 2016? Next, I suppose I'll be required to be tested on DOS 3.1 instead of Windows 10. It is an easy out for the recruiters and it tells me that the recruitments company is no good for me as they are not progressive and dynamic enough to find me the right job.
@wisdomworldtiger9227
8 жыл бұрын
very value video! l like it, sorry I download this video, now I save add to my favorites
@Grace-up5em
6 жыл бұрын
I just calculated 24,797 × 1.20 on my cell phone calculator and I got these numbers $29,756.40. How come there's a difference in the number of cents on Excel? On his Excel spreadsheet, his calculation result is $ 29,756.68 (how come it has .68 cents). I also realized, if you multiply $24,797 by .20 it equals just the 20% = $ 4,959.40 Then you can just add both figures together: $24,797 + $ 4,959.40 = $29,756.40 I just don't know why the cents are .68 on Excel instead of .40 .
@RiversBliss
5 жыл бұрын
Long overdue but: He forgot to put on precision in Excel settings.
@sampsonraysimon
8 жыл бұрын
Thanks! I appreciate this!
@stijnvk30
9 жыл бұрын
Great video! helped me out alot actually :)
@hmharris823
5 жыл бұрын
FUN!!
@aidarankin3862
3 жыл бұрын
Awesome
@shaunie06031
6 жыл бұрын
This is better than Idiot Test. The request was to create a row under G-10. He didn't realize that cell A12 says G-10, which is where they are asking the testee to place a row.
@KINGKING10109
5 жыл бұрын
G-10 is relating to the product name, not the cell reference lol
@rabiaibrahimisah468
4 жыл бұрын
Thank you
@coniholden4409
9 жыл бұрын
Thank you, nice video!
@trevohshelton8986
8 жыл бұрын
Thank you for sharing.
@Peace.
6 жыл бұрын
Really useful
@mariomujica3339
5 жыл бұрын
Thank you so much
@pieeeenat4
7 жыл бұрын
they meant in the column "PRODUCT" it has a G-10 it's the very last row :P
Пікірлер: 224