Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- Download Files: people.highlin...
In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class:
1. (04:24) Download Files
2. (00:33) Prerequisites for class
3. (01:04) Excel Professional 2016
4. (01:50) Install Com Add-in Power Pivot
5. (02:54) Examples of Effective and Efficient Solutions in Excel
6. (09:20) What Excel Does: 1) Make Calculations & 2) Data Analysis
7. (11:25) Structure of Excel: Cells, Worksheets, Sheet Tabs and Workbooks
8. (13:00) Keyboard Shortcuts are efficient because they help you to accomplish tasks quickly
9. (15:06) Data Analysis and Business Intelligence terms
10. (16:31) What is Raw Data?
11. (17:16) Excel Proper Data Sets
12. (20:18) Terminology: Cleaning, Transforming, Importing Data Data
13. (22:40) Data Types and Default Alignment in Excel
14. (29:05) Excel Table feature
15. (34:45) Number Formatting is a Façade
16. (39:13) Date Number Formatting and Date Math (Date Formulas)
17. (43:51) Time Number Formatting and Time Math (Time Formulas)
18. (46:35) Percentage Number Formatting
19. (53:10) Custom Number Formatting
20. (01:03:00) Style Formatting allows you to present information in an effect way
21. (01:10:00) Cell Styles
22. (01:13:45) Page Setup allows you to print information in an effect way
23. (01:19:24) Summary
24. (01:20:25) Homework Problems
Highline Excel 2016 Professional Class taught by Michael excelisfun Girvin
Prerequisite class: • Office 2013 Videos: Wi...
![[Full Episode] The Restaurant War Thailand ศึกพ่อค้าซ่าแม่ค้าแซ่บ Episode 2 | 29 ก.ย. 67](http://i.ytimg.com/vi/r3lfLNH6Ke4/mqdefault.jpg)
Do you know sir I am from India and I am in the field of data analysis and I am watching your videos even before I started doing the job just want to say in India we greet our teacher by touching their feet and you have earned that respect in my heart thank you so much for that golden knowledge not everyone has the money to buy an expensive course and those who want to learn this is the best place to gain a good amount of knowledge
@@excelisfun Its Nikhil Sir not " Kikhil"
Just finished your basics course, The advanced course now begins. Wish me luck.............. Videos are a fantastic help, thank you!
You're going to love this!!!!
I'm finally starting the advanced series. I enjoyed your basic series tremendously and cannot wait to dig in to this one. For everyone that has a strong base in excel but wants to watch this video series to take their skills to the next level: this is the place to be. And most importantly thank you Mr Girvin. You can be sure I will leave a comment on every video I watch during this series, as well as dropping the thumbs up.
I am so glad that you have finished the Excel Basics and are now on to Advanced Excel!!!! Thank you for your support, Pieter!!!!
You helped me through my internship! THANKS!
You sir are changing countless lives for the better with your tutorials. Thank you so much.
You are welcome, francis Chu!!!! Thank you foe the support with your comment, Thumbs Up and Sub : )
I wish all teachers put in efforts that you did. Honestly simply the best training ever. We really really appreciate the efforts and the simplicity you chose. You have a long time student here! God Bless!
You are welcome! Thank you for your Sub and Thumbs Up on each video that you watch : )
Hello, Mike Hope you are safe there. After completing the basics playlist I'm here to learn from your advanced playlist. I watched the entire video I was very good with a quick revision of almost all the topics which I learned in basics.
Btw stay safe and how is the COVID situation in your country?
Amazing Summarize of almost 70% of Basic Videos Playlist! WOW you're really amazing and professional!! As I've said before , thank you can never be enough for you..
you are the freakin BOSS BROTHER
Glad the video helps! Thanks fro your Sub and Thumbs Up on each video : )
Best Excel training/teacher ever.... Thanks so much!
Thank you for the course I have been searching for course like this. I have just finished this video and Am going to finish them all. Thanks very much again 🔥
You are welcome, Mbih!!!!
Have fun with the whole class - and thanks for those thumbs up on each vid and comments when you feel like it : )
Hi Mike, thanks for uploading both the free basic and advanced course. I would like to know please if completing the basic course will be enough to take MOS exam. I have already a basic Excel knowledge and in case I would want to take the MS Excel Expert exam instead, will your free advanced course cover all the knowledge required in the Expert exam?
Peter Fraga: No download. 1:04 minute mark says which versions Microsoft makes you buy.
Hi Guys, if you like the Excel is Fun videos please make a donation to the channel. Email for the PayPal account is mgirvin@highline.edu
Michael has been making GREAT Excel videos for many many many years. Most of the stuff I know about Excel, I learned from him. I am sure he will appreciate a donation, no matter how small. Give something back to the person who makes you an Excel Pro. Thank You. (Disclaimer: this message come from me personally Michael did not ask me to post this)
Thank you very much for sharing your expertise. The BUSN218 tutorials are the VERY BEST resource for anyone wanting to master Excel. Learning excel can be very frustrating, but the tools (video tutorials, excel spreadsheets with detailed notes and multiple homework exercises, and the PDFs with extensively detailed notes) that you provide make learning excel fun. Excel Is Fun. Thank you. Thank you. Thank you
You are welcome, welcome, welcome! Thanks for the Sub and Thumbs Up on each video : )
I am outside US and some weird stuff is going on in me Excel. think local country settings and language are not compatible with US settings and short cuts.
Thank You Teacher . Can you suggest some books related to data analysis that one must read for in depth knowledge in this field.
Perfectly good teaching. Works also with MSO Excel 2013; one does not need to upgrade, if cannot for some reason. Thank you, Mike!
You are welcome! There will be some differences later in the class, but mostly it is the same! Thanks for your support, M. SZ. with your comments, Thumbs Up and Sub : )
It's been a while since I watched one of your videos and I forgot how great they are! You have a gift my friend. You rock! Thank you for putting out such detailed and informative videos.
You are welcome, Jonathan!!!
Dear Excelisfun, First of all i would like to say Thanks for all the work you have done for Excel training through your channel in You tube.The way you teach is amazing.all the videos quality is very good. Thanks a lot...
You are welcome!
Excellent Coaching...
Please upload Excel VBA macros tutorials also...
May Almighty bless you..
I just finished your excel basics playlist and now i will start this video tomorrow. By the time quarantine is over I am hoping to have watched 4 of your learning playlists about Excel. Thank you SO much, Mr. Girvin. I believe this will be pivotal in helping me find an internship next year.
I am so happy to help you pivot with these free learning playlist, g g !!!!
I just want to say I have learned so much from watching your videos. But there is one thing I hope you adapt into your examples.
I think that most people that use excel at work are working with huge data sets, possibly with years of data. If the data is exported it is usually in a Table format with named headers. Your easy to follow and very well explained lessons usually has a very small data set and to select a small data set it is efficient to use the keyboard short cuts from the top of a list just under the columns header name and cntl + shift + down arrow to the bottom of the data list and this especially works on a large data list. But I have found it even more effective to just type the columns reference such as (=SUM(A:A) even with a header it will give the correct answer. This even works well in the lookup functions. Less typing and quicker formula entries.
+Luke Williams , A couple things: I have many videos that demonstrate large data sets, for example the Business Analytic series and others. Also, I intentionally do not use A:A and other complete column or row references; although most times it is not a problem, in some cases it can cause slow calculation because so many cells are involved and in other cases it can cause incorrect answers when data is added below the data set and for array formulas you flat out are not allowed to use full column references. I am aware that it is a standard practice in the working world to use whole column references like A:A, but I fundamentally disagree with it. Further, Since keyboards to highlight the range and jump back to the Active Cell are relatively quick, selecting the correct range is just a small bit slower than clicking the Excel column header. I hope that articulates my position well.
Amazing video! Loved it from the beginning to the end!! Can't wait to progress and learn new tricks.....You really made me love Excel! Thank you so much!
You are welcome, Martina!!!!
So helpful! Thanks :)
You are welcome, Ishita!!!!
What TH-cam channel do you subscribe to, to learn your stuff ?
no one is like you sir great and guru of all excel world..
I am very happy to see you made it through all 25 basic videos and are on to advanced : )
I've used Excel in my career for the last 15 years, but it's only after watching the Basics course that I realised I had only been scratching the surface with how productive and efficient this software could be. I am looking forward to this Advanced Course with relish. Michael, you're a fantastic teacher and your knowledge and enthusiasm for the subject clearly shine through in each video I've watched. I've already started applying some of what I've learnt at work and it is helping me tremendously. Thank you very much for posting these videos for free, this is a public service! This material should be taught at schools to prepare kids for the working world and give them a headstart in life. Greetings from the UK.
I am so happy to hear that the classes that I post are helping you tremendously. I agree 100%, that Excel calculations and Excel Data Analysis should be taught in K-12 and above. You can help me further this public service, jaysteam, with a quick comments and thumbs ups on each video that you learn from, and of course your Sub : ) See you in the next video!
Hi,Thanks for educating us tremendously with Excel. I am a strong fan of MS Excel but am also interested in MS Access. If you have a platform to learn that also, kindly direct me.Thanks,Chris
+Christian Ilorah Maybe try: th-cam.com/users/LearnAccessByCrystalfeatured
Hi Michael. I notice you encourage Alt+= for AutoSum and you're right. As a trainer myself I show it to dozens of participants per month. Can I add a small improvement to that shortcut? While below a column of numbers instead of Alt+= then Enter I show to press Alt then hit = twice. So its Alt+== which I learned that from double clicking the AutoSum button in the toolbar (Ribbon). So I wondered if hitting = twice would be like double-clicking. Et voilà. My little 5cents worth.
Cheers - Down Under
I'm an absolute beginner with a job lined up about a week out. Is this a good place to start?
this is a better place to start: th-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
If if you need data analysis in Excel: th-cam.com/play/PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT.html
@@excelisfunThank you so much! I arrived there on my own earlier after looking around some more so I got through Basics 1 already and I'm blown away by how well you lay out the information, it's really easy to understand and absorb! Thank you for what you do
@@juliomares7784 You are welcome so much! And yes, I can tell you, most jobs out there require Excel and since most employees are basically clueless about Excel (even though they say they know Excel because they have tracked inventory in Excel or used the SUM function), if you can go into a job knowing Excel well, Bam! you have a great chance of getting the job. Remember: I do charge a thumbs up on each video for the "free" lesson lol
Good evening friends....I cannot download the exercise files , can you help me? the link doesn't work thank you
The college servers are down. They are trying to bring the servers back up, but it has been difficult. The servers will be back up, but we are not sure when.
Hello, can you show me how to split the number and text from one cell. ex. 134564Stacysmithpatient. Thanks
Hi, I cannot find the proper keystrokes
to paste data from one cell to another using ONLY keystrokes...
For instance, I want to paste the number
35 in cell A7 to cell CB7, without using the mouse.
I want the number 35 to appear in cell CB7
without the screen moving to that part of the spreadsheet but instead the
pointer staying on cell A7.
Can you tell me how to do this in Excel
2010 using only keystrokes? Thanks bob
Perfect introduction ...if we do small things with perfection big things will happen automatically and that's all I learnt from you❤️
I absolutely love this:
if we do small things with perfection big things will happen automatically
You said it so perfectly, shubham : ) : ) : )
@@excelisfun many thanks
Hi, the links to all videos are not working (Apache/2.2.22 (Ubuntu) Server at people.highline.edu Port 80) is there any reason ?
I'm watching the "Basics" course and starting the "Advanced" course now after finishing every video in "Basics" except video 25. My boss directed me to learn "the basics" of Excel that I would be ready to keep up in a class given for me and my coworkers. Now, my coworkers are asking me to teach them. I feel that "Excel Basics" did way more than teach me just the basics. I could probably handle a lot of things that even experienced office drones might think twice about. I'm going to continue to keep watching. Out of all the possible faults you could have in life, learning Excel to an absurd degree is not one of them!
I just ordered a free month trial of Microsoft Office 365. Is that all I need? You mention this is Excel 2016 "professional". Is there a specific version I should have gotten?
I'm not getting that table formula Nomenclature... Just getting that normal range like B8:B22 ☹️
Help me out
Sounds like your settings are not set: File, Options, Formulas, Working with formulas, check the box for "use table names in formulas".
Hi I have a question I have Office 365 home/business can't seem to fin the Power Pivot add-in. Is there shomere I can download it?
Hey Brother,
would sincerely appreciate and like to request to share that how can we lock our raw data and final data from being edited when the Excel reports needs to be in Sharing folders in Company. You have to let everybody open it for obvious purposes, but there is always a thing someone might destroy or edit it.
Appreciate your videos. Thnx if you can help.
Help sir I have office 2016 home and student version so which one I buy office 365 or 2019 version
Office 365. It is the only version that gets updates. Excel 2019 is a dead version with none of the cool new features.
Thank you for your awesome content! I applied for a role with a great deal of Excel experience required. While I've been using Excel for years, it was in a limited capacity. Your videos gave me some practical skills to apply to a test I was required to take, as well as give me some insights into the deeper complexities of Excel that helped in the interview. I am most grateful for your assistance in helping me land the position. Cheers! I will be sure to stay tuned for more help and advice. You helped me land a great role so thank you once again!
+Pete Sayers You are welcome! I am glad that the videos help you! :)
Great info I still have a problem with my keyboard function on my macbook air. How can i customise it to execute the same functions as your spreadsheets I have the 2011 version. Pls help
I have excel 2019. But the "Alt + =" shortcut does not work! It used to work in my work laptop. But not in my home PC. Is there some setting I should tweak? Please help!
Thanks a lot! Love your videos! 💕
This is awesome! But I have a problem opening the teaching materials. Every time I try to open it, I fail as lack of space. I can create and open my other excel files. I don't know what to do.
I'm running Excel on a MAC and it doesn't support PowerPovit but does have a Solver Add-in. Would that work or do I need to use the windows version?
+Jeffrey Schwartz Yes, Mac Excel is very different. No Data Model, for example.
I tried using the keyboards Alt + = but I get a Windows chime and doesn't do anything. Anyone know why? :(
Watched. Refreshment tour. Thank you very much again.
Awesome Videos Man. God is watching how you are helping the world. Treat on the way. Kudos!
It is my duty to try and make the world a better place in the best way that i can . Thanks for helping me to do this with your comments and Thumbs up, rahul, and of course your Sub : )
excelisfun, I want to Thank you for taking out time to explain excel in a great way as this. i also have a challenge and hope you respond to it. Pls Busn218-Video02.xlsm in H(w)3 sheet upon calculation my answer is still showing zero. what do I do please?
The downloaded Excel workbook does not match the video. The topics are completely different.
Thank you Sir , very informative ,God bless you more
You are welcome, Thembekile : )
Hi, can I learn in this course without going through the pre-requisite? I would be fine if I missed only a little information
Yes, you should be able to do it.
Well described and awesome learning thing ... Hats off sir ❤️
Glad to help!!!
At 9.08, where is the BACKSPACE key?
Your videos are amazing thank you so much BTW it seems like the workbook wont download for this video i was able to download most of the other workbooks but not this one
I learn so many features and function from your videos. It is amazing . I didn't find any video showing how to remove infinite row and column or stop generating further row or column after last cell of the data. Is there any thing to remove or delete ?
so sir what is the exact difference between 0.00 and #.## if they both are delevering the same answer
0.0000 = Significant and insignificant digits
27.11 becomes 27.1100
43 becomes 43.0000
#.#### = Significant digits Only
27.11 becomes 27.11
43 becomes 43.
Excellent. Supportive to learn much more about excel. Much appreciate
Many thanks ExcellsFun, Best of Best
Many you are welcomes, Kevin : )
Hello all, I'm an MS Excel addict and have no intention for rehabilitation (ha ha). Despite being on disability I love to learn more with Excel since I got a newer computer and using MS Office 2016. Will purchase it through my online college I believe for $70.00 or so and it will be worth every dime. I love your video as it goes through the nitty gritty parts of Excel many, like myself, might not know but will.
I am glad that you like the videos! Thanks for all the Thumbs Up!
Does anyone know why wouldn't the Pivot table refresh & update the changes?
thx
Thank you for your videos mister excel. Your videos helped me.
how can i install power- pivot on my Excel 2016 for Mac?
Outstanding. These Excel videos are superb and comprehensive. I've downloaded all of them to improve my Excel skills.
Glad they help!!! Thank you for the support with your comment, Thumbs Up and Sub : )
ExcelIsFun How can we customize our shortkeys? Because in my Excel, Ctr+Home does not select A1 cell. I have to press Ctrl+Arrows multiple times. :(
I am not sure... : (
A Gem! Love it. Thank you!!!!
Youa re welcome for the Gem, Vanessa!!! Thank you for your support of these free resources with your comments, Thumbs Ups and a Sub : )
Jacked for this. Been using excel my entire career (almost 20 years) but am now getting ready to go out on my own in the consulting world. As a CPA, I want to take my excel skills to the next level to provide value-added services for my clients. Super jacked to get started!
This series should help a lot! Thanks for the Thumbs Up on each vid : )
48:56 Bwoop Bwoop. Thats the sound of da Police. Ya'll are Welcome.
You have a big gift and a big heart. Thank you so much for the videos, I am studying diligently! Every time I watch your videos, I pray that God bless you, so I think you will blessed all days of your life. I am enjoying the end of my year with excelis fun. Have a wonderful new year with hope, peace and joyful heart!! Please, keep teaching us excel next year.
You are welcome for the videos! I will keep the videos coming : )
Bill, i know it is entirely different story
but i am in bad need for a degree, can i have one online with High-line, i am in egypt.
Your videos are the requisites to be a good analyst.
I found this link on reddit. I have a basic understanding of excel. I have the summer off from college and i figured why not learn something new. Im going to start with excel basics. Are the videos kind of a walk through and if so are there examples i could download?
My Excel Basics are really advanced. My advanced and much more detailed than basics. Both classes have videos, Excel files to follow along (including practice problems - homework), and pdf notes:
Basics: th-cam.com/users/playlist?app=desktop&list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
Advanced: th-cam.com/play/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw.html
Even better, see a 2 mon video of all my classes: th-cam.com/video/l1-1aVgFth4/w-d-xo.html
@@excelisfun thanks for all the help.
Superb information. Thank you.
You are welcome, Albert! Thanks for your support with your comment, Thumbs Up and Sub : )
Peerless! No one like you, Mike. I get so excited when I see "ExcellIsFun just uploaded a video" in my inbox. I'm like a kid in the toy store. Can't wait to work through this new series.
+Rod Leaverton Thank you for the kind words! Hey, candy is great! When I make the videos and I am piecing together the story to tell, I am also like a kid in the candy store piecing together all the yummy chunks of candy into a story of fun Excel!
is it necessary to watch the prerequisite playlist??
No, if you have some Excel experience, this series in fine for you.
Seriously comprehensive content. So many excellent tips and tricks. Thank you!!!
You are welcome, Liz! Glad it can help! Thanks for your support with your comment, Thumbs Up and Sub : )
Excel is Fun and Mr. Excel are the best ever this is the truth
Thank you for your kind words! Thanks for your Sub and Thumbs Up on each video : )
Thanks for the support and keeping the videos latest and new, need to learn now everyday!
I really appreciate the effort, excellent job
You are welcome, Ahmed! I am glad that it is EXCELlent for you ; )
Awesome! Great teacher. I'm out of words! Really thankful for this.
Glad you like it ! Your words were great ; )
This is the very best excel training you could get, with excellent support material that you can download. Kuddo!
Glad you like it! Thanks for the comment, and your thumbs Up on the videos!
Hi,
I am looking to refresh and learn excel formulas. What videos do you recommend?
This guy is AWESOME!!! Just in the first 10 minutes, I knew this was the guy to learn from...
Wow! Where was this 30 years ago when I first started using excel? To get mastery, you gotta learn from a master and Michael Girvin is the master! Thank you Michael!!
Not so much a mster, but more just a guy having fun with Excel and wanting to share! Glad you like the video!
Regards, Passions and Prayers for such a Nice, Courageous and Kind act of teaching amazingly.
You are welcome, Bivv93!!!! Thanks for the kind words, and thanks for your support with your comments, Thumbs Ups and Sub : )
Good stuff! Great review with a few new things sprinkled in.
Excellent topics. The revision to page setup was needed. CNFs are fantastic!
Glad you like it all, Yashvardhan! Thanks for the support with your comment, Thumbs Up and Sub : )
Thank you very much sir for your wonderful and generous knowledge sharing. I have really learned a lot just from this one video. I'm gonna follow through with the rest of the videos
You are welcome! Thank you for your comment and Sub and Thumbs Up on each video that you watch : )
Hi. I love your lessons. It's easy to follow. I'm an excel beginner, and I try to learn a thing thing daily! Thank you and Keep it going!
You are welcome!
I haven't used excel before.
Can I learn these tutorials with having to go through the pre-requisite???
It would be best to use Basics Series of videos firts:
th-cam.com/play/PL3FBEE51974F03CCF.html
Thanks for the Sub and Thumbs Up on each video : )
Hello Sir, many thanks for such an amazing and helpful video. Two years ago I learned basic data analysis (sorting, formatting, pivot tables, etc. They helped me a lot in my job as an accountant and I just can't imagine doing my work without utilizing these extremely helpful tools. I am back to your data analysis video for a refresher yet again.
Awesome! You have boomeranged back for more Excel Education. Glad to help you, Raheel!!! Thanks for your support on each video that you learn from with a comment and thumbs up, and of course your Sub : )
Next monday is my first day with excel 2016. Can't wait for your next lesson. Tks lot Mike
+Pedro Cabral da Camara You are welcome!
Thank you is just not enough to express my gratitude to this SUPER teacher
What is enough, is for you to show support on each video with a Thumbs Up, a comment and Sub to the channel : ) That is plenty of support. And, I am glad that the videos help, Nour : )
On 57:57 when you do "h" it shows hours. However, "m" would show month (1), not minutes. Correct?
yES, BUT IF YOU USE A COLON, M MEANS MINUTE
Is Ctrl + ; Like the today function? Does the date change everyday?
Yes, but TODAY is dynamic, which is what you want sometimes, but the keyboard is hard coding the value in, which is what you want for recording historical transactions : )
Great Excel Training. I thought I knew Excel...
Yes, Kelly, and the cool thing is that this is only video #1 in this 25 Video Class that I teach for free here at TH-cam. Keep watching and please sub and thumbs ups : )
Can you also do a review of Microsoft Power BI? and how that compares to using Excel.
+YC I will not do that in this series. I will have one or two examples later in the class. Just an introduction so that the people in the class know that it exists.
ExcelIsFun
Thanks. Hope you can do a series on that in the future. I think it is Power BI is an interesting tool. That and tableau have been making some buzz online. Business Intelligence has been making a comeback with Data Science and Data Visualisation on the rise
I agree: Power BI Desktop is THE buzz in the Data Analysis world!!!
Excellent video with very useful tips and information
Glad it was EXCELlent for you, darren! Thanks for the support with your comment, Thumbs Up and Sub : )