Excel & Business Math 01: Introduction to Excel. Why We Use Excel for Math. First Formula.

In this video you have an introduction to Excel for this Business Math class and see our first two formulas.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.

Topics in Video:
1. (00:01) Introduction
2. (00:34) Class Web Site, Class Files & USB Drive to store files from class
3. (01:56) Download Excel & pdf Files. Look at different Browsers: Chrome, Internet Explorer, Mozilla
4. (03:05) Create Folder & Save Files using Save As & Windows Explorer
5. (05:49) Why we use Excel for Business Math
6. (09:46) Conventions for Class
7. (13:18) What does Excel do?
8. (14:35) Excel Workbook Layout
9. (17:38) Move Between Sheets
10. (19:00) Zoom in and out = Ctrl + Roll Wheel on Mouse
11. (20:00) Ribbon Tabs
12. (20:38) QAT – Quick Access Toolbar
13. (21:20) First Excel Formula: Total Sales
14. (31:33) Selecting a Range with the Selection Cursor
15. (31:40) Number Formatting as a Façade to display numbers in a different way that the Actual Number in the cell
16. (34:06) Second Excel Formula: Net Income. Also see how to copy a formula to the side (not down a column)
17. (35:32) Verify that Number Formatting is NOT misleading
18. (36:52) Review PDF Notes ()
19. (37:52) Summary

[shajupauljohn]

Mike, you are a true Excel Genius. Thanks a lot for all your videos. You are doing an EXCELLENT JOB by teaching everyone.

[LeilaGharani]

Thank you for a great introduction. All the resources you provide - including the detailed pdf is amazing!

[m.sz.]

I have just discovered these gems. Thank you!

[TheDirge]

Its amazing how many people who work in finance do not know these basics. Good job.

[QuentinDaniels]

Thank you for the videos, Mike! You do great job and we all appreciate your teaching.

[kmitu]

this is such a great free content, thank you so much!

[lorishaver]

Thank you Michael. Such a helpful video and notes.

[palakodetibangarurayudu]

Great beginning of another series of tutorials Sir, Thank you.

[rodleaverton]

Great work, Mike. Excited to see the new version of your Business Math course. Hope all is well, my friend. :-)

[marcelblais]

Real and excellent reference to beginner like me.

[OzduSoleilDATA]

Ah! That Window key. Well, ok!
Very thorough tutorial.

[barttitulaerexcelbart]

Thank you Mike for this great course. It is a very good update of your previous courses. Interesting to see all improvements. As for your remark for formatting, this is subjective of course. In my view: if you are in accounting use decimals, if you are in controlling and the numbers are above 1.000 always use round numbers. Also: always use the same formating in a column, so you can better compare the numbers. Keep the good work also in 2018!!

[ismailismaili]

welcome back with the new videos i was waiting for it i really missed your videos thank you so much for being always uploading videos we appreciated.

[SyedMuzammilMahasanShahi]

This is amazing. Thank you Mike for another EXCELlent video. keep it up man.

[mahadiullah]

YOU MAKE SENSATIONAL EXCEL VIDEO. I AM STUDYING ALL OF YOUR CLASS AVAILABLE IN YOUR WEBSITE.

[johnborg]

Thanks Mike. Looking forward for more :)

[simoiyahector-morales]

Hey sir thanks for the great videos all the time

[vketalk]

Great work. How can I join the graded course?

[mohamedchakroun]

A lot of fun a lot of khnowledge are coming so with business Math and Statistics :-)

[DIGITAL_COOKING]

hi mike, I just started learning this series and I think it's very useful
but I found on the net a book with the title "Principles of Finance with Excel by Simon Benninga".
on your experience do you think this serie fit the content of this book or can you guide me for series which is the same content as the book