VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » Knowledge, science, education » Technology for Teachers and Students
Beginner's Guide to Excel Functions and Formulas

Beginner's Guide to Excel Functions and Formulas

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Learn or review the basic Excel functions that everyone needs to know: SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA Nathaniel: It would be highly useful to see a tutorial on calculating discounts by percentage in Excel. You are the best instructor I've encountered for Excel. However, I scored only a barely passing grade at 70% on an Excel eval today for a prospective employer. They claimed that it was going to cover only basic features. I studied your vids up through Advanced; however, I encountered questions not represented in your vids and we're CLEARLY advanced. Just thought I'd put in my two cents.
Date: 2022-04-08

Comments and reviews: 9


If you would have made this an Excel table, you wouldn-t have to freeze the pane to keep first line in sight. Then, the header line would occupy the column headers (A, B, C, D,...) when scrolling down. One of the many wonders of using Excel tables. Also MIN, MAX, AVERAGE are also directly available as sub item of the Sigma button you clicked for SUM.
reply

Hello, if you could help me out with this. I am trying to make a formula, i am a begginer. So what i need is for exampl: I have 2 coloms 1: Apple,Orange,Carrot 2: XX,XXXX,XXXXX. I would like it to be : If you choose apple then it must be 2-XX, if choose carrot it must be XXXX-4xs.
reply

Hello, may you please do an automated duty roster video. I like how you explain and zoom in.
I haven't found any video on how to make an -automated duty roaster- that explains it like you.
Hopefully you find this comment.
Thank you in advance.
Stay blessed.

reply

I-m hooked , excel is about to go from my Achilles heel to my strength .. question i was making a sum and all the numbers went to 2 decimal places ( no decimals before ) how do I change this to who,e numbers please ,, keep up the good work -
reply

I just want to thank you for providing practical steps for learning Excel. I paid for courses and couldn-t understand. I learned and understood four of videos in less than 2 hrs. Much gratitude. Great intuitive teacher!
reply

I've been using Excel for well over 20 years. I item I've never been able to solve. My default font color is Red. I change it to black, and the next time I open Excel, it is Red again. Advice please.
reply

Great content! I am also creating MS Excel tutorials. MS Excel is such a powerful tool that almost 90% of businesses nowadays use. Happy Excel - ing---
reply

For years I had major anxiety over using Excel. Thanks to your method of teaching, I have lost my fear and have learned so much from your videos. Thank you!
reply

please do another excel functions video on sum average, max , min etc this was great but I would like to know more about this
reply
Add a review, comment






Other channel videos