LOL!!! Excel Tutorial for Beginners – Funny Jokes. Puns. Surprises

LOL!!! Excel Tutorial for Beginners –  Funny Jokes. Puns. Surprises


Hi there this is Vadim Mikhailenko and in this quick tutorial we’re going to look at the key features of Microsoft Excel If you’re just starting out or if you need an Excel refresher or you’re interviewing for a job that needs Excel skills this is the right tutorial for you. Coming up an online training for everyone to launch Microsoft Excel you find Excel an alphabetical list of applications in past a bar it’s under letter e and it launches Microsoft Excel another way to launch it and I’m gonna close it for now is to type excel and Cortana bar and it launches Microsoft Excel now is the good time to ping application you find Excel in the list of windows taskbar applications and you can pick pin to taskbar and what it allows you to do if I’m closing it for a second you see Excel still remains in taskbar and you can click on it and launch it and this is especially useful when this is one of the frequently used applications one thing I was gonna mention is that I created an outline of this video tutorial in the description of this video so if you’d like to jump to the specific topic that you’d like to get more coverage off or don’t wanna go through the entire tutorial you can definitely do that just let me get to the description find the time stamp which is a link and click on that link and you’ll be able to jump there where you need to be now let’s continue and have more fun to get up to speed in excel the fastest way is to start with Microsoft pre-built tutorials you can learn more about formulas pivot tables and just take a tour so let’s pick one of them maybe create formulas you see that there are multiple tabs and you can navigate through tabs and learn on the specific topic but for the purposes of this tutorial I’m going to go back and click new blank workbook and here we’ll start with creation of the brand new excel a document but before that we’re gonna look at the interface of Microsoft Excel Microsoft Excel has what’s called ribbon interface and as you can see you can navigate between different tabs and tabs represent different functions for the application for example Home tab tab consists of the most frequently used functions in there grouped into groups clipboard is one group font is another group alignment number styles cells and editing and if information doesn’t fit into the group then it was added into the dialog box in the upper in the lower right corner you can see the link to dialog box and they just click the font dialog box and you can see additional functions related to font that’s in that dialog box just wanted to mention before I forgot that if you interested to learn more about the subject make sure to click the subscribe button we have tons of things in the pipeline and I’m excited to share all of them with you as you can see cells themself represented by columns and rows in each cell is in the intersection of the column and row you can expand columns you can expand rows and you can just type information here in the cell and we can we’re gonna make it same height as the other rows here but was that let’s take a look at some key functions you can make it bold you can make it italic or bold and italic in this case you can undo this by chicken and one cool thing about Excel is tell me what you want to do for example you’re trying to find function and maybe make it bold it is one of the functions that you’re trying to find you can just type it here and tell me what you want to do it it finds it and it allows you to apply it based on the current circumstances of what you have an upper left corner there’s what’s called the quick access toolbar as well and here you have access to most frequently used functions for example save is one of them and let’s save the document and you have multiple options to save it you can say that locally or you can browse and choose maybe you want to save on onedrive and you can add a place these are the options microsoft offers onedrive this is their storage and there is some free options available or if you sign up some free limited storage or if you want a larger storage you have to pay and then SharePoint but I’m going to save by saving the document onto my hard drive and typically in Windows you click the documents and that’s where you would want to store most of your documents and I’m just going to say that this is the student budget document you can add or remove functions from the quick access toolbar for example if you want to add new button or Open button and you see they show up and same way I remove them by just unchecking them here another thing that might be useful in the lower right corner there is a zooming function you can zoom in or you can zoom out or you can go to the View tab and there is a zoom button and you can choose specific zoom or zoom 200% or zoom to selection those are the options available as you can see zooming to selections owed me into 400% so I’m gonna zoom how then you can drag and drop that slider to get back 200% since we started on financials let’s type in the monthly budget for the student will have two categories one category would be for income which would list wages and financial aid and another category would be for expenses this category would list housing utilities transportation food entertainment cell phone clothing tuition and books we’ll also add assumption category where we’re gonna list key assumptions of how we made particular estimate for this financial statement as you can see I kept in all the values now let me show you some cool things that you which you can do with the cells first of all it’s adjust a little bit because we have our assumption here a little bit longer so we can still adjust I just wanted to mention that all files are referenced in this video are available as downloads so make sure to check out the description of this video and download the file so you can follow along also if you interested to learn more about the concepts and need more deeper knowledge of Microsoft Excel check out the training courses that I recommend all the links are in the description of this video as well let’s add borders to do to do that we need to select all the cells here and select borders in the fund and which is gonna do regular borders here and you see this is how it showed up now let’s introduce you to formulas let’s add total formula so we have income and expenses to different categories and you see I’ve got tired typing expenses so I’ll show you a cool trick you can just copy value for expenses and drag it and then click paste and it pastes it into multiple cells the same value so if you have repeated value and I’ll show you why we have this value even here so we can do filtering and sorting this is they’re helpful for that but to expand it and had similar values that’s how you do it now let’s introduce you to formulas for example we want to have a total for income so we can just create the total and here we will just we can type it very tediously for example 1200 + and I’m gonna type another cell c3 + c4 and if you have multiple values are down below you can certainly do that and it will calculate it so the total value is 21 16 that’s 67 but I’m going to delete it by clicking delete button and instead I’m just gonna show you auto sum function when you click autosum Excel projects with those values and the top would be and you just need to hit enter and we end up was the same value same for expenses let’s calculate total expenses and to do that we’ll just do auto sum and Excel predicts that this would be cell c6 through C 14 and we’re just going to click enter and this is our total expenses now let’s do our make our table a little bit look low bit prettier to do that we’ll select the values and we’ll just make them bold I’m gonna also change the color the background color and you can pick any color that you like but you have to consider printing and how well it’s gonna be when you print it to look at this now you click print and you select the printer but see most of the time you’re gonna print black and white and that makes it a little bit challenging sometimes if you pick very dark color how the text is going to look on the very dark background we’re also gonna format the amount column to do that we will select it and we’ll assign the dollar sign and then it formats using dollars we’re also gonna make increase font a little bit for monthly budget and I’m gonna clarify this because this is monthly student budget and missus or Community College and you can also make it maybe bold and italic combining both or maybe even they had underlined if this is what you would like to do also you would want to highlight income maybe as a separate bold and underline and same for expense one thing I wanted to point out we introduced concept of range here was the formula we had the formula if we select the cell for example C 15 this atoll expenses it shows that cell is the sum of value C 60 C 6 through C 14 and C 6 through C 14 is the range and range could be just one column or it could be multiple column it could span from different alleys for example this would be range from a C 6 and the bottom range would be G 22 but this is not gonna be accurate because some formula can only take a numeric values but just to introduce concept of range it shows and highlights in Excel was the column so C 6 Colin C 14 and it could span across multiple columns in the description just click on the link and you will access the file and you can follow along I have also selected the training course that you can use to advance your skills in the subject I’ve carefully selected this course and the link is right here you can take advantage of discounted the price now let’s continue that more fun you can also format cells by using in place menu to do that you select the cell that you’re trying to format and do a right mouse click and it shows you the menu was action cut copy paste and a lot of others and you can also see specific functions related to cell formatting which mimic a lot of ribbon functions you can make it bold for example you can Center the values if you want to you can change the background color and have access to a lot of functions you can also do undo function which is my favorite function in any office application the way I’d like to do it is in the quick access menu so just do undo format cells and you can undo to any level wherever you feel you need to go back to or you can do redo redo basically takes you back if you think you used undo too much and you need to go back this is what redo comes handy and this is how it works now let’s look at Microsoft Excel data types as you can see I have text values likes expenses and transportation and I also have dollar amount accounting values like $100 Excel provides ability for you to choose two different types for the cells for example you can select the cell and choose from one of the available type and it spans from general which is by default when Excel doesn’t know what type you should assign and you can select number currency or accounting dates different types of dates and times percentage a fraction scientific and text another cool feature of Excel is ability to freeze the top row for example this is useful when you have a lot of data and I’m gonna simulate a lot of data by zooming in and we haven’t need to scroll you see sometimes I can see the header monster student budget for Community College and sometimes it’s being hidden to show it at all times what I can do I can select the top row click view and then click freeze panes and then click freeze top row and this allows me to freeze it and it always remains visible and no matter how I scroll I can always see this value I’m going to delete this header and freeze the top row for the cell this is much more useful way when you work with the tables and this is typically how you can always make the header for the table available now let’s go back and I’ll show you how to quickly filter the data in the Home tab let’s say that you want to categorize and see only income on the expenses in Excel you can select the top row and select the filter and the filter and you see it added the drop down boxes in each column and what you can do now you can say okay I only want to see instead of select all I don’t want to see expenses you click expenses in Excel filters out based on the value in the category column and only brings up expenses for example you can change it to income on the end it will bring up on the income and you can do it in any column where you want to be and you can select multiple values for filtering in multiple columns another cool thing I’d like to show you is that you can add additional sheets in Excel see in a bottom left corner there’s sheet 1 and you can name it for example you can say student budget you can add another sheet and that would be blank sheet another thing you can do is you can say move or copy and when you select the student budget you click create a copy and it will create a copy of student budget and you can now you have two student budgets and maybe this would be a family budget so what you can do you can take the values from student budget and reuse them for family budget which is a head start now let’s look at how you can add hyperlinks to Excel cells for example let’s say for transportations we make an assumption that this was over during two classes so what you can do you can select this cell and say insert and then you can say link and here you can just type HTTP uber.com and it will create a hyperlink which will reference you to go bring in if you create but if you create a PDF file from this this will become a valid link and it will be clickable another cool thing is that you can move with keyboard in between cells for example I’m using the arrow buttons arrow to the right arrow to the left you can also use up and down arrows and you can move in between and it’s especially useful when you enter the data for example you can say that this is should enter and this will take you back and then tab also takes you to the right it’s useful when you’re entering the data for example value and then you press tab and then shift tab will take you back and then same to navigating vertically you can say enter or you can do shift and turn which takes you back and forth horizontally and vertically now let’s see how we can merge the data for example we can merge multiple cells maybe to make it better visibility or for whatever other reasons we can select two cells to merge them and click format cells and then here we can go to alignment tab and we can select merge cells and now from two cells it became just one cell let’s maybe change and align it to the right as it was and let’s change the formatting to bold as well as it used to be can same thing let’s do for the total expenses cell now let’s look at how you can wrap the text sometimes there is a need especially if you don’t have enough room like for example in this scenario I just shortened on the width of column D and you see that some text expands over into another cell so what you can do here in this situation instead of shortening the text sometimes you’d like to keep all the text you select all the values in this column in your click wrap text button and it creates a multi-column just specifically to this particular cell as you can see the values in the category description and amount starting showed up at the bottom of each cell so what we can do we can align them to the top because the cells in the wrapped our cells they show up from the top to do that we need to select everything and there is a cool feature in Excel you just click here and maybe that’s going to be applicable for the entire spreadsheet put the entire sheet and then you choose different alignment options to the top you can align to the top and that’s what we want to do but in case you’re interested you can do middle alignment or you can do bottom alignment for the cells and see if now for multi-role cells which have text and multiple rows everything’s aligned to the top now let’s take a look at some key features of the document that you might be interested in if you click on the file tab you see the information about the document and what’s important for me here and hopefully would be important for you as well that’s things I’d like to emphasize are the properties you can add a title to the document had tags and categories and when it becomes useful is when you need to save it as PDF and or distribute either Excel or PDF online because Google index is based on those values there are more properties you if you click show all properties it shows a lot more and you can add company name hyperlink based subject categories and a lot of other information as needed it also shows you the author and last modified by for this particular Excel document which also might be useful make sure to subscribe and tell your friends about it so they will learn more skills in the area now let’s continue that more fun since we’re in this tab let’s take a look at the options for protecting the document there’s a whole button here on the top at the end it shows all the protective options you can encrypt the file with password you can protect current sheet only you can make it read-only and do a lot of other protection things using all options available another useful feature here is when you need to recover unsaved workbooks you click on this and if something happened to your computer maybe computer crash then you had unsaved documents this feature will help you go back and see what can be recovered and allow you to restore to some degree hopefully everything speaking about data loss I’d like to point out to another cool option which I love to change every time which is autosave if you go to options and then Excel options and then save it shows you save the document automatically every 10 minutes I’d like to change it to 1 minute so this way I know Excel takes care of my document and saves every minutes item lose too much in case my computer crashes or something L happen something else happens well let’s look how you can print preview the document before you send it to printer you click on the file and then print and it shows how your document is going to look here you choose the printer and you can choose different options how you would print you can also zoom in to see how the document is going to look like you see all this controls at the bottom right corner and you could display margins to see the margins for the page you can also share the document either as Excel workbook or as PDF I just looked the share button and if you click the PDF for example it will create email message was PDF attached or if you share file share Excel workbook it will create a new email message in Outlook and attach excel file which allows you to send documents much much faster but if you just need to save PDF file save Excel s PDF you click file and then click save as and then here in the list of options one of the options is saving as PDF you can find links and downloads in the description section of this video there are a lot of helpful links and a lot of other helpful information you will benefit make sure to check out my other relevant videos and subscribe to my youtube channel we have a lot of great stuff planned in the pipeline and I don’t want you to miss any of it and if you’d like to get notified about all the new stuff that are coming out make sure to subscribe to my email list as well all links are here in the screen make sure to click to stay in touch thanks again for watching

Comments

  1. Post
    Author
  2. Post
    Author
  3. Post
    Author
  4. Post
    Author
  5. Post
    Author

Leave a Reply

Your email address will not be published. Required fields are marked *