Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup October 21, 2019 100 By Stanley Isaacs CategoryArticles BlogTagsAbsolute Cell References in Excel Basic Excel Busn 216 Cell References in Formulas Complete Lesson in Excel Excel Excel 2016 Excel Basics Excel Formula Basics Excel Tutorial excelisfun Formatting Formulas Free Excel 2016 Tutorial Highline College Introduction to Excel Learn Excel Learn Excel for Free Learn Excel Online Learn Microsoft Excel Michael Girvin Mike Girvin Number Formatting Page Setup Printing in Excel Relative Cell References 100 Comments jisan the utuber says: January 12, 2019 at 11:36 am Watching this video was fun 👌Thank you very much 🔥 Reply iam sic says: January 14, 2019 at 8:19 am thank you so much iv learned a lot from you sir. Reply Marli Lira says: January 15, 2019 at 7:30 pm Thank you. I love the video. Its a good refresher Reply TP303 says: January 16, 2019 at 7:31 pm Very helpful video, you're a very strong teacher. Thanks man! Reply Tyrone Johnson says: January 18, 2019 at 1:56 am Thanks for not talking too fast in the video like a lot of other ppl do in these. Very excellent dmonstration and explanation. Reply Beatrice Norman says: January 18, 2019 at 7:16 pm It's impossible to dislike this guy! Thank you so much for all that you do! Reply Emi Sarangae says: January 19, 2019 at 8:19 am I hope you see my comment, do you have tutorials for people working with excel on macbook? Just got a macbook and realised the keyboard functions are different Reply Никита Корниенко says: January 19, 2019 at 4:20 pm why there is no sound? Reply NJHeart2Heart says: January 26, 2019 at 12:23 am LOL!! Love your videos.. refer to them all the time when I get stuck. Figured it would be fun to go back to basics and see if I can catch some new tips that I didn't know previously.. and that's when I connected the Cross-Hair "Cross Hare" vs. Angry Rabbit cursor!! FUNNY! now I know the RREST of the STORY! LOL Reply John Mills says: January 26, 2019 at 6:29 pm I love your videos! I am actually learning how to use Excel instead of watching boring videos where I just get sleepy watching. GREAT WORK! Thank You. Reply Anderson 40th says: January 27, 2019 at 2:10 am You rock, man! I just finished my first video in your Excel Basics 1 and have learned SO MUCH! Thank you, thank you, thank you! Been in a deep depression and your teaching has showed me I can learn something, move forward, and live a productive life. Can't wait to tackle the next video. You're changing the world! Reply Jason Brookes says: January 27, 2019 at 10:59 pm Brilliant Reply Alameen M.A says: January 28, 2019 at 7:30 pm First of all thanks for this great effort ,this is so helpfull ,you are really great ,even the teacher need to learn from you becuase you have nice method to teach, مشكور ياغالي 谢谢你的合作。 Reply Alla Karas says: January 30, 2019 at 4:08 am Thank you for empowering those who are striving to learn, but cant afford to attend school, college, university !!!! Reply Jackie cadiz says: February 1, 2019 at 4:38 am the best tutorial that i ever watch, very clear and easy to understand, thanks sir! god bless you. Reply Glenn Goffason says: February 2, 2019 at 3:25 pm I am so refreshed by your video. In fact it's a bomb in the world of Excel. Reply Lisa T says: February 9, 2019 at 10:11 pm This is awesome! I understand so much more than I did reading my class material! Thank you!!!!👍🏻👍🏻 Reply Ben Hatfield says: February 12, 2019 at 12:53 pm Angry Rabbit !!! Reply NTEBELE AGREEMENT says: February 12, 2019 at 2:55 pm that was wonderful, i'll be looking forward for more of your videos Sir, you're the best, thank u Reply Vout Phea says: February 18, 2019 at 4:35 am hi ! pls subcribe me too Reply Samantha Saunders says: February 19, 2019 at 4:25 am You are awesome! I had a quick question. Do you have to do control enter b4 formatting a cell? If it's just highlighted shouldn't it still work if you click on the percentage button for example? Reply kaiqin guo says: February 19, 2019 at 5:17 am Thank you so much. I really appreciate what you did for us.God bless you! Reply Imbert Daniel says: February 21, 2019 at 4:29 am on my laptop selecting f2 to edit and f4 to lock the cell does not work. Reply Adam Silfvander says: February 28, 2019 at 5:49 pm Nouww Reply spidytube1 says: March 1, 2019 at 8:14 am can anyone tell me how to remove blanks from pivot table please, because it is duplicating my Grand total Reply Pushpendra singh says: March 7, 2019 at 2:52 am Thank you very much Reply Hithesh Harikrishnan says: March 7, 2019 at 6:24 pm Thank you so much for sharing your knowledge sir. Please don't worry about the number of subscribers sir ultimately it's the quality of content that matters. Keep doing what you're doing sir, God bless you sir 🙂 Respect your hardwork and effort sir 👍 Your student from India ☺ Reply Mohammad Osman says: March 23, 2019 at 8:25 am How to convert Two Excel dates into exact no of months (in decimal)e.g Start Date is 22-03-2017 to End Date 28-02-2018It is almost 12 months but if we look exact then 11.3226 month (11 months and 10 days)how we calculate through excel formula when data is more then 2000 line item Reply Trust Valentino says: March 27, 2019 at 6:04 am Did you say the first of 25?! Videos??? Sir, I'm taking a test in a day or two. I don't think I will get through all them by then. Just trying to pass an employment assessment 😫 Reply Ali Hassan says: March 27, 2019 at 5:40 pm Awesome! You're the best ^_^Kindly tell me when I'm stretching the dates by using angry rabbit, it's changing the year not the date. what to do? Reply morganREVIEWS says: March 27, 2019 at 5:43 pm OMG thank you so much for creating this incredible resource. Reply adam sisovic says: April 2, 2019 at 1:52 pm THank you. Finally normal explanation! Wish you the best! Reply zachery bryant says: April 7, 2019 at 7:26 pm WOW. 30 and returning to school. Trying to test out of a class and they gave me a heads up about it being excel heavy… Been a minute and this was amazing. Subbed and liked. Thank you for your time Reply Sudip adhikari says: April 10, 2019 at 1:16 pm Do we really need to press 'ctrl+enter' to apply and copy a formula?Doesn't it do the same thing without pressing 'ctrl' key? 🤔 🙄 confused! Reply ابو أحمد المطرفي says: April 12, 2019 at 7:57 am Thank you Reply Abishek Kumar says: April 19, 2019 at 5:09 am Masterpiece. You have the excelled the Excel Reply Ocean Tsai says: April 20, 2019 at 2:52 am Dear Sir. Would you mind helping me create a prepaid schedule for multiple vendors? At the end of each month, I need to reconcile the balance sheet total prepaid to a schedule. Thank you very much for your help. Reply Paul Trigger says: April 20, 2019 at 3:36 am There are tips buried in here that even experienced excel users can pick up Reply Crystal Andra Rose says: April 25, 2019 at 8:56 am I have been worried for my poor excel knowledge.I searched excel lessons but I couldn't understand them.After watching your lessons I gain confidence.Thank you vey much for your explanations in details. Reply Leyla Wanner says: April 30, 2019 at 10:16 am Michael, today I passed my MOS Excel 2016 Exam and I want to express my deepest thanks as I built the knowledge based on your tutorials. You are an amazing teacher! Thank you! Reply jesse g. says: May 6, 2019 at 11:00 pm oh. excel really is fun. Reply Semih Yıldırım says: May 9, 2019 at 8:25 pm Coming here years after learning Excel watching these amazing videos. You sir are a legend. Reply Rakesh Zaveri says: May 17, 2019 at 6:56 am I seem to be having a problem with the average function as i am getting a warning ""The formula in this cell refers to a range that has additional numbers adjacent to it." What am i doing wrong?? Can someone please help? Reply Sean says: May 19, 2019 at 1:48 am Do you have to do ctrl + enter before clicking and dragging to copy down a formula? I thought the clicking and dragging automatically copies the forumla? (I'm a beginner so I'm genuinely not sure) Reply Stanley Losh says: May 25, 2019 at 10:12 pm Awesome! I too at first thought you were talking like you would to a two year old but soon realized that it was very helpful. The thumbs down must have been from people too full of them selves to realize that their Excel experience is that of a two year old. I will follow you to the last row and column. Reply Mohd Hakimi says: May 25, 2019 at 11:11 pm You are amazing sir. I like learning excel through your video. Thanks. Reply omokhowa says: May 26, 2019 at 1:07 am Thank you, sir, for the living knowledge espoused here today. Reply daries says: May 29, 2019 at 4:39 am You fella are in another level, is not easy to find resourses of this quality in spanish, thank you very much. Gracias. Reply Ifeoluwa Bada says: June 11, 2019 at 5:32 pm The students name's got me. Hhahah! Adbi? Reply Lori Favela says: June 13, 2019 at 12:31 am these are the very very basics. I like this one Reply chris sukkel says: June 13, 2019 at 7:32 am Great Very Clear Thank you Reply Denise Franco says: June 15, 2019 at 11:02 pm Thank you so much for these tutorials. Do you have any for Word and PowerPoint? Reply Deborah says: June 16, 2019 at 2:14 am very good explanation , thank you Reply Akhil Vijayan says: June 21, 2019 at 7:46 pm Thank you soo much for the videos sir.. Reply Jason Lee says: June 24, 2019 at 5:50 am This video is very helpful! Reply ahmed ali says: June 25, 2019 at 11:55 am many thx for your support and valuable efforts . Reply ELMORENOTEXXX MUSIC says: June 25, 2019 at 4:01 pm excelentes aportes Reply Leon Quadros says: June 25, 2019 at 7:22 pm Mahn I've been looking for such tutorials for a very long time and there's a whole playlist here! Feels like I found some treasure. Cannot thank you enough 🙂 Reply Dymah Shah says: June 25, 2019 at 10:07 pm Amazing content! In just one video i learnt so much about Excel. Your videos are comprehensive as well as user friendly. Keep up the good work sir! Reply Birendra Prasad Sah says: June 26, 2019 at 5:31 pm Awesome Reply John Borg says: July 15, 2019 at 12:45 pm I don't know if it should be at this stage or later videos, if you want to change the sheet name you use a keyboard shortcut…..Alt + O + H + R and it will shoot you down to the sheet name. No Mouse!! 🙂 Reply kamran khan says: July 15, 2019 at 4:50 pm Simply Gold.. not less Reply Maddirala king says: July 18, 2019 at 12:41 pm Sir, plz provide the PDF notes link Reply Sandeep Kothari says: July 19, 2019 at 1:45 am Great course Mike! Reply Đạt Nguyễn says: July 21, 2019 at 4:00 pm Ctrl+enterCtrl+*alt+= Reply Shadab Monjur says: July 22, 2019 at 2:26 pm Watch the video on 1.25x speed, better Reply Davids Jennifer Odochi says: July 24, 2019 at 2:07 pm Thank you so much sir. this tutorial has been helpful to me me and i am very grateful. Reply Ana Doruelo says: July 26, 2019 at 3:54 am TYSM SIR! Reply Avijit Tube says: August 6, 2019 at 4:40 pm Your Video is that much good i can not need an computer teacher..basically when i practice in computer i thought that computer is boring.. but after watching your video i found an interest in Microsoft Excel. .. which i never fell before… Your video is not boring… It has a fun to learn Excel.. I am very much lucky … Reply Abubakar Halima says: August 7, 2019 at 2:11 pm 🙏🏻🙏🏻🙏🏻🙏🏻😘😘😘😘😘😍😍😍😍😍🙏🏻🙏🏻🙏🏻😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍 Reply Badette Niyo says: August 7, 2019 at 11:41 pm Thank you for making a difference. Reply African Fitness Legend says: August 8, 2019 at 11:46 pm lol i can't believe i got this for free. Reply j M says: August 11, 2019 at 11:56 am great👍 Reply Sebastian Kong says: August 13, 2019 at 4:25 am I work in the actuarial field but this video humbled me. I still have a lot to learn and will "start from the beginning" by watching the rest of the Beginner Excel series. I also really appreciate the fact that you provide general notes so that I only need to write occasionally. I will definitely purchase an item or two from the store as a sign of appreciation. Reply TRUSTin WWJD says: August 14, 2019 at 9:32 am Whoa,,,, thanks so much for sharing & teaching over the YT,,,,GOD bless for your all good works,,,, Reply dan daly says: August 25, 2019 at 9:40 pm glad i subscribed, excellent teachings, i need to become proficient Reply Yohanan Levi says: September 2, 2019 at 4:24 pm Excellent 👊 Reply TheTekelp says: September 2, 2019 at 7:19 pm Total fan of ExcelIsfun. Thank you so much. Reply Ahmed Ezz says: September 7, 2019 at 10:18 pm You have no idea how you're amazing Reply Gavin Khaleel says: September 8, 2019 at 3:54 pm Hi Micheal I have a questions I hope you can help with. I have an attendance time card in excel for a group of employees. I want to create on workbook where each employee can enter their attendance and a summary sheet to gather all their time so I can submit to payroll. I know how to create and map all of that but I am looking for a way to have each employee tab data to be 'blacked out' from others who may accidentally click on another employee tab. All my sheets are locked to protect formula and formatting…help Reply faiza tumbas says: September 10, 2019 at 6:01 am Amazing videos, excellent teaching, thank you so much for sharing. Reply starstella123 says: September 15, 2019 at 10:02 pm Your voice reminds me of Ross Geller lol Reply ORNL says: September 18, 2019 at 11:46 pm Great introduction! I've used excel for so many years and have already learned a few cool tips that are sure to improve my efficiency in excel. Reply Patrick Small says: September 19, 2019 at 4:23 am Sir you are AMAZING! Excellent teacher. I cannot say how much you have helped me before my job interview tomorrow. Thank you very much. I will be back. Reply Fart Knocker says: September 28, 2019 at 5:33 am EXCEL IS BETTER THAN PORN Reply tamilarasan govindaraj says: September 30, 2019 at 1:21 am Great Effort i master in my Pivot table because of your videos, am become big fan of your page & the way you move from topic to topic, did you upload videos on MS Word also… Reply Synthea Agashi says: October 1, 2019 at 5:42 am Thank Reply himy nameis says: October 2, 2019 at 12:18 pm You've explained so easily!!👍 Thank you sir keep doing this great job, by helping people to get excel professionally! Well done🤘 Reply Maria Saravia says: October 3, 2019 at 4:29 am Me encanta sus clases, quedo maravillada con ganas de aprender cada vez más. Un millón de gracias Mr. Girvin. Reply sandeep singh says: October 3, 2019 at 7:44 am great jobyou made it interesting Reply Isobel Li says: October 5, 2019 at 11:43 am AMAZING! Reply Anibal Hernandez says: October 5, 2019 at 7:02 pm This is totally awesome! THANK YOU VERY MUCH Reply aditya kumar says: October 5, 2019 at 9:53 pm HI, thank you for the amazing video! Do you have videos for MS Word as well? Reply khaalid abdirashiid says: October 8, 2019 at 8:16 pm I appreciate you hard work and dedication you did all students around the world Reply Nilstrieb says: October 9, 2019 at 9:23 am That was an EPIC introduction! Reply Gwen Paul says: October 10, 2019 at 8:12 pm Bless you, bless you, bless you!!! I have been retired for a few years and re-entered the workplace only to find I am waaaaay out of touch with technology. Though your tone initially came off as condescending, I quickly learned it was exactly what I needed. I will be continuing to expand my knowledge of Excel thru your videos and your videos only!!! I didn't get sleepy … paused frequently to take copious notes … viewed the video on my laptop while performing the exercises on my desktop. You were so easy to follow. Your video has been priceless for me!!! Continue the great work Sir!!! Reply Joshua Umoh says: October 12, 2019 at 4:36 pm Superb tutorial! Kudos!! Reply Nahim Mohammad Nakib says: October 18, 2019 at 4:54 pm Outstanding works Reply fatou a sanyang says: October 18, 2019 at 5:19 pm thank you sir Reply Hazem Ali says: October 19, 2019 at 2:59 pm always great Mr Reply Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Save my name, email, and website in this browser for the next time I comment.