Home
Videos uploaded by user “Subjectmoney”
Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel 2013
 
08:14
http://www.excelfornoobs.com In this Microsoft Excel 2013 tutorial I show you how to make a basic Gantt Chart. This is a basic Gantt Chart that shows the time frame of a project and the time frame of the individual task that are to be performed. This Gantt Chart is basic so it doesn't show the progress of the project. If you would like to see an Excel tutorial on how to create a Gantt Chart that shows the progress of a project you can find it by searching through my videos. https://www.youtube.com/watch?v=-oD50HSBBBI https://www.youtube.com/user/Subjectmoney http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 1034244 Subjectmoney
Gantt Chart Excel 2016 Tutorial How to Make a Gantt Chart in Excel 2016
 
06:45
In this Excel 2016 tutorial you will learn how to make a Gantt chart in Microsoft Excel 2016 step-bystep. You can use Excel 2016 to create a Gantt Chart using Excel charts feature. http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 116986 Subjectmoney
Microsoft Excel 2013 Tutorial For Beginners #1: Crash Course Data Entry Formulas Formats Charts 365
 
10:03
Excel 2013 Tutorial http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Z1xHvWjJtOo For Excel 2016 Tutorial for Beginners click here This is a Crash Course on Microsoft Excel 2013 Office 365 Tutorial for Beginners. By the end of this 4 video Excel course you should have a decent understand of the most common and basic Excel functions and commands. In this video we show you how to do basic math formulas in Excel 2013, we introduce you to some data entry techniques, teach you formatting and how to make basic charts. By following along this Excel 2013 tutorial Crash Course you should be familiar with how to navigate through Excel and perform the most common Excel functions and commands. This tutorial also works for Microsoft Excel 2007, Excel 2010 and Excel 2013 however there are some features such as Recommended charts that the older versions of excel don't have. Excel 2016, Microsoft Excel 2016, Microsoft Excel 2016 Tutorial, Excel 2016 Tutorial for beginners, Excel 2016 Tutorial For Beginners Follow the link below for another basic Excel tutorial for beginners https://www.youtube.com/watch?v=bCsv3KNS6rA https://www.youtube.com/watch?v=Capdr... http://www.youtube.com/watch?v=bCsv3KNS6rA&list=PLHboMthwcZOv7wIJcflX6x06Oj1PRwFe- Follow this link for and Excel 2013 Tutorial on Formulas and Functions Part 1 http://www.youtube.com/watch?v=BVhuyY-tRvM Part 2 http://www.youtube.com/watch?v=KgxUAGobviA Part 3 http://www.youtube.com/watch?v=sdVKAx9AfbI Part 4 http://www.youtube.com/watch?v=E8hxIVR2RAE http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 898565 Subjectmoney
Excel Tables Tutorial #3 How to Create and Use Excel Tables 2013 2010 2007
 
02:58
http://www.excelfornoobs.com In this Excel Tutorial Video Series I show you how to create and Use Excel tables. I show you how to style your table, make custom table styles, navigate through excel tables, insert new table columns and table rows, Work with table style options, move tables, and how to sort and filter Excel tables. This Excel tutorial works for Microsoft Excel 2013, Excel 2010 and Excel 2007. Please don't forget to visit our website at http://www.excelfornoob.com. Please also subscribe, rate, comment and share our videos. The more interaction we have with our viewers the higher Youtube will rank our videos. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=O8TLmPDESMc
Views: 18711 Subjectmoney
Financial Statement Analysis #2: Ratio Analysis - Liquidity (Short Term Solvency)
 
04:30
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this financial statement analysis tutorial we are covering liquidity measures or short term solvency ratios. Here you will learn about the current ratio, the quick ratio (acid test) and the cash ratio. Short-term solvency measures are used to determine whether or not a company would be able to pay off its short-term liabilities if they were to come due within the near future. Please don't forget to subscribe, rate and share our videos. Please also visit our website at http://www.subjectmoney.com and http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=G8v9hF0k3gI
Views: 75533 Subjectmoney
Excel 2013 Tutorial For Noobs Part 30: How to Name Cells With Create From Selection & Name Manager
 
02:38
http://www.excelfornoobs.com In this Microsoft Excel tutorial I show you how to name a range of cells using the create from selection command. I also introduce you to the Name Manager dialog box which shows you all cell ranges that have been given names. This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. Please don't forget to subscribe, rate and share. Please also visit our website at http://www.excelfornoobs.com. Please also add us on Facebook. You can find the links on our channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=3avbbkCgP5I
Views: 15988 Subjectmoney
Excel Tutorial: How to Transpose a Table in Excel Change From Verticle to Horizontal 2010, 2013
 
02:40
http://www.excelfornoobs.com I this quick Excel Tips tutorial I show you how to use the clipboard and paste special feature to transpose a table in Excel. This is useful when you need to transpose a vertical table to a horizontal table or transpose a horizontal table to a vertical table. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013 Transpose table orientation in Excel Be sure to Rate, and share our videos and don't forget to subscribe. Please also visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Wow_Nb3a0V4
Views: 30540 Subjectmoney
Excel 2013 Tutorial For Noobs Part 1: The Excel Ribbon, Tabs, Commands and Buttons 2010, 2013, 2016
 
05:16
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltut... In this excel for beginners tutorial we introduce the Excel ribbon, the different tabs, commands, and types of buttons. This is a very detailed basic Excel tutorials series. Some of the stuff you see might seem like common sense but if you follow this tutorial series thoroughly you will learn many efficient features that you may not know exists in Excel. This tutorial series is good for Excel 2007, 2010 and Excel 2013 Microsoft Office 365 Excel 365. The Excel Ribbon is the main location of most Excel Commands. You can see an image of the Excel ribbon in 1-2 below. 1-2 The Excel Ribbon Tabs on the Ribbon The Excel ribbon has tabs labeled as follows: File, Home, Insert, Data, Review, View and sometimes Developer depending on whether or not it is showing. Inside these tabs are Excel commands that are separated into different groups. An image of the different tabs is shown below by image 1-3. Image 1-3 Excel for noobs Tutorial Ribbon Tabs Commands on the Ribbon? A Command is something that tells Excel what to do. An example of a command would be the Fill Color Command as shown in image 1-4. By click this command the activated cell will be filled with the selected color. Excel For Noobs Tutorial Commands As mentioned there are groups of commands on every ribbon offered by each individual tab. On the bottom right corner of some command groups you will see a small arrow button pointing down-right. This arrow appears in command groups that provide more command options than can fit into the command group. By clicking this button a dialog box will appear offering more options. For example, if you click on the Insert tab you will see the arrow button in the Charts Group. If you click on the right arrow button the Insert Charts dialog box will appear offering you a large variety of Chart options. This can be seen in Image 1-5 below. NOTE: Some commands require dialog boxes to gather more information before performing the command. Commands With Contextual Tabs Some commands such as Charts, WordArt & Equation have contextual tabs. Contextual tabs offer options directly related to the command you are using. For example, If you click on the Equation command listed in the Insert Tab, two contextual tabs names Drawing Tools and Equation Tools will appear. This can be seen in image 1-7 below. Please be sure the rate, share, and subscribe. Please also visit our website at http://www.excelfornoob.com where we add detailed Microsoft Excel tutorials weekly. We also have a section of tutorials dedicated to fund Excel tricks and tips. Today This Week This Month This Year Excel 2010 Tutorial Excel 2007 Tutorial Excel 2013 Tutorial Excel 2010 Tutorial For Beginners Excel Formulas https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=bCsv3KNS6rA http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 112286 Subjectmoney
Perpetuity Lesson/Tutorial: Definition, Present Value of a Perpetuity Formula & Examples
 
05:16
http://www.subjectmoney.com In this Perpetuity Lesson I define what a perpetuity is, how to calculate the present value of a perpetuity, and also provide you with some examples of solving the present value of a perpetuity. A perpetuity is a steady stream of Cash Flow s of equal amounts that are to be received or paid indefinitely. A perpetuity is a form of an ordinary annuity and is sometimes called a perpetuity annuity. A true perpetuity is rare but they are not non-existent. Around 1871 the British government issued a Bond that was a true perpetuity known as a Consol. The purchaser of a Consol was entitled to receive an annual coupon payment at a fixed rate forever. You may wonder why or how a government or any entity would want to agree to such a long-term commitment of payments. They do this because they can guarantee payment by reinvesting the money from the purchaser into Investment s that earn a higher return.
Views: 20583 Subjectmoney
Financial Statement Analysis #4 - Ratio Analysis Asset Management or Turnover Measures
 
03:38
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this tutorial on financial ratios we cover Asset Management or Turnover Measures. These ratios are often called asset management or utilization ratios The ratios that we will discuss can be interpreted as measures of turnover. They are intended to describe how efficiently and intensively a firm uses its assets to generate revenues. Please subscribe, rate and share our videos. Please also visit our websites at http://www.subjectmoney.com and http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=sAyS8ElLwUY
Views: 20008 Subjectmoney
Business Law - Contract Law - A Lesson/Lecture on Contract Law
 
07:18
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Introduction%20to%20Contracts%20%28Business%20Law%29 In this video I reach about contracts and contract law. This video should be helpful for studying the material provided for your business law classes however it should not supplement what your business law professor has assigned. Please be sure to subscribe, rate and share our videos. Please also visit our website at http://www.subjectmoney.com. https://www.youtube.com/watch?v=Y7tbQ6zbNxw https://www.youtube.com/user/Subjectmoney
Views: 23319 Subjectmoney
Excel Tutorial Circular Reference & Iterations - How to Fix Circular Reference Formulas 2016 2013
 
04:58
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial7.php?title=Excel%20For%20Noobs%20Tutorial:%20Circular%20Reference%20and%20Enabling%20Iterations%20to%20Fix%20Circular%20Reference%20Formulas Excel 2013 Tutorial for Beginners on How to Fix circular reference problems in Excel. A circular reference error arises when a formula either refers to the cell it is inserted in or refers to another cell that refers to its own cell. For example, if we were to enter =A1+B1+C1 into cell C1 we would get a circular reference warning. This is because we entered a formula into cell C1 that refers to cell C1 as an argument. The problem with formulas that contain circular references is that every time the formula is calculated, it must be calculated again. This could go on infinitely. When you enter a formula with a circular reference a warning box will appear as shown below. Circular Reference Excel Formulas 2013 When this box appears you can click OK and Excel will just display a 0 as the result of your formula, or you can click Help and Excel will display a help screen providing more information about circular references. Circular Reference Help Excel 2013 There are times when circular references are necessary. For example, suppose you owned a company and your employees' salaries were a percentage of net profit. Since net profit is calculated as Revenues -- Expenses and salaries are an expense, we would run into a circular reference problem. We must know what net profits are before we can calculate salaries and we must know salaries before we can calculate net profits. In this case we can use circular references to our advantage. Examine the data and formulas in the Excel screenshot provided below. I am using the show formulas feature so you can see what exactly is entered into the cells. As you can see we have a circular reference problem because Net Profits in cell B4 is =B1-B2-B3 but cell B3 contains a formula that refers to cell B4. Excel 2013 Formulas circular reference iterations The formulas entered into this worksheet are resolvable formulas and if the formula is repeated enough times a desired result can be reached for both cell B3 and cell B4. To solve this circular reference problem we simply need to enable iterative calculations. To enable iterative calculations follow the steps below: Step 1: Select File and then click on Options. The Excel options dialog box will appear. Step 2: In the Excel options dialog box click the Formulas tab. Step 3: In the Calculation Options group check the box where it says Enable iterative calculation. Now Excel will run the maximum allowed iterations until it reaches a result where Salaries are exactly 10% of Net Profit. Look at the screenshot below to see the final result. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=j0nRTcoKrE0 http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com Microsoft Excel 2016, Excel 2016, Excel 2016 Tutorial, Microsoft Excel 2016 Tutorial
Views: 94680 Subjectmoney
Financial Statement Analysis #3: Long Term Solvency Measures or Leverage Ratios
 
04:30
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this financial statement analysis tutorial we cover long-term solvency measure also known as leverage ratios. In this tutorial we cover the total debt ratio, the debt to equity ratio, the equity multiplier the TIE ratio and the cash coverage ratio. Please don't forget to subscribe, rate, & share our videos. Please also visit our websites http://www.subjectmoney.com & http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=qg1N9_CQtyk
Views: 44191 Subjectmoney
Dividend Discount Model (DDM) - Constant Growth Dividend Discount Model - How to Value Stocks
 
06:23
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Dividend%20Discount%20Model In this lesson we are teaching you how to price stocks using the Dividend Discount Model (DDM). We explain the concept of the dividend discount model (DDM) and show you the necessary assumptions along with how to get the cost of equity (discount rate) using the Capital Asset Pricing Model CAPM. We also teach you the constant growth dividend discount model and then show you how to tailor the dividend discount model according to the what is expected of the company in the future. Please don't forget to subscribe, rate and share our videos. Please also visit our website at http://www.subjectmoney.com and http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=n76Pz3HOBPo http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 115515 Subjectmoney
Time Value of Money: Present Value & Future Value - Lesson - Formula - Subjectmoney.com
 
06:37
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Time%20Value%20of%20Money:%20Present%20Value%20and%20Future%20Value What is future value? Future value is the value that money today will be worth at some point in the future if invested for a return. For example, we have $100 today, and we invest it for 1 year at 10% interest, then in 1 year the Investment will be worth $110. In other words, the future value of $100 invest for 1 year at 10% is $110. This is because we will still own the original $100 and we also earned 10%, an additional $10. In total our $100 investment will be worth $110 in 1 year. The future value formula is shown below. What is present value? Present value is today's value of a future Cash Flow . For example, everyone knows that $100 today is more valuable than $100 in the future, but what about $110, $120 or even $200 in the future. How do we calculate what they are worth today? To calculate the present value of a future cash flow we would need a few pieces of information. We need to know when to expect the cash flow, the value (future value) of the cash flow, and the Discount rate . What is the discount rate? The discount rate is the Opportunity Cost s that you have foregone to receive funds in the future. I know, this may sound confusing but it should eventually click. An easy way to understand the discount rate is to ask yourself this question. What kind of investment returns are available to me? If I had $100,000 today, what would the return be on my investment one year for today? Whatever that rate is would be your opportunity cost and would therefore be your discount rate. (It can be more complicated that this when comparing risk but this is a simplified lesson.) https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=XF_3Dt-8OPE http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 58350 Subjectmoney
How to Make a Gantt Chart Microsoft Excel 2013 Tutorial #1   Automated Progress
 
10:09
http://www.excelfornoobs.com In this Microsoft Excel 2013 tutorial I show you how to create a Gantt Chart in Excel. For this Gantt chart I also use the Today function (=today()) and I use the If function (=if()) to show to progress and to automate and update the progress as time passes. This tutorial will also work for Excel 2007, excel 2010 and excel 2013 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=t3FnjVY5YKY
Views: 19925 Subjectmoney
Excel Tables Tutorial #2 How to Create and Use Excel Tables 2013 2010 2007
 
10:01
http://www.excelfornoobs.com In this Excel Tutorial Video Series I show you how to create and Use Excel tables. I show you how to style your table, make custom table styles, navigate through excel tables, insert new table columns and table rows, Work with table style options, move tables, and how to sort and filter Excel tables. This Excel tutorial works for Microsoft Excel 2013, Excel 2010 and Excel 2007. Please don't forget to visit our website at http://www.excelfornoob.com. Please also subscribe, rate, comment and share our videos. The more interaction we have with our viewers the higher Youtube will rank our videos. Excel 2016, Microsoft Excel 2016, Microsoft Excel 2016 Tutorial, Excel 2016 Tutorial for beginners, Excel 2016 Tutorial For Beginners https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=mwbcwzjCDsc
Views: 39912 Subjectmoney
Financial Statement Analysis #1: Common Size Statements and Operation Analysis
 
03:36
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this lesson we are introducing you to financial statement analysis. We cover common size standardized statements, we cover measures of income and also financial ratios that can be used to analyze the way a company operates along with other features such as the companies financial structure. Please be sure to subscribe, rate, share and don't forget to visit our website at http://subjectmoney.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=TjZCpmtg1Kw
Views: 48512 Subjectmoney
How to Enter Large Numbers/Credit Card Numbers Into Microsoft Excel Tutorial
 
04:16
How to enter large numbers in Excel How to enter credit card numbers in Excel How to enter numbers larger than 15 digits into Microsoft Excel http://www.excelfornoobs.com http://www.subjectmoney.com This is just a quick Excel 2010 tutorial that teaches how to enter in credit card number into Excel. You wouldn't think that there would need to be an Excel tutorial made on this subject but the problem is that if a cell is not formatted correctly then Excel cannot handle a number as large as a credit card number. Watch this tutorial and hopefully it will save you some trouble in the future if you have to enter in a number that contains more than 15 digits or is larger that 9999999999999999. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=FEroTcfM0vA
Views: 121920 Subjectmoney
Excel Tips Tutorial: How to Hide and Unhide Worksheets & Make Worksheets Very Hidden VBA Editor
 
04:45
http://www.excelfornoobs.com In this Microsoft Excel tips tutorial I show you how to hide and unhide hidden worksheets. I also show you how to make worksheets very hidden and how to unhide very hidden worksheets using the Visual Basic Application VBA Editor. Making worksheets very hidden can be useful when you have worksheets that you don't want user to know about. However, you need to be careful with Excel because the security measures in Excel are easy to crack. This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. Please also be sure to visit my website at http://www.excelfornoobs.com and add us on Facebook. All the links are listed on our Channel. Last hour Today This week This month This year https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=0B1QDRVVE24
Views: 52085 Subjectmoney
Time Value of Money TVM Lesson/Tutorial Future/Present Value Formula Interest Annuities Perpetuities
 
21:53
http://www.subjectmoney.com This Time Value of Money Lesson TVM covers all the basic concepts of the Time Value of Money that you would learn in Finance. In this tvm tutorial we cover simple interest, compound interest, present value formula, future value formula, annuity due, ordinary annuity, present value of annuities, future value of an annuity, intrayear compounding interest, and perpetuities. In this time value of money lesson we teach you by video using visualizations to help you understand how money and time works. If you study this finance tvm video tutorial in combination with what you leanr about the time value of money in your finance class, you should have a clear understanding when it is time to take your time value of money tvm test or exam. I’m glad that I could help you study for your finance time value of money exam. What is simple interest? What is compound interest? What is an ordinary annuity? What is an annuity due? What is the present value formula? What is the future value formula? How to solve the present value of an uneven series of cash flows. What is a perpetuity? How to solve the present value of an ordinary annuity. How to solve the present value of an annuity due. How to solve the future value of an annuity due. How to solve the future value of an ordinary annuity. Present value of a perpetuity formula. Time value of money, time value of money lesson, tvm, tvm lesson, tvm formulas, time value of money formulas, present value formula, future value formula, present value, future value, annuity due, ordinary annuity, simple interest, compounding interest, intrayear compounding interest, perpetuity, present value of a perpetuity, how to present value, what is present value, what is time value of money
Views: 207895 Subjectmoney
Excel 2010 Tutorial For Beginners Part 1: How to Navigate Through an Excel Worksheet
 
03:57
http://www.excelfornoobs.com http://www.subjectmoney.com http://www.subjectmoney.com/Exceldisplay.php?title=Microsoft%20Excel%202010%20Tutorial%20Part%202:%20Navigating%20Through%20Excel In this short tutorial we are going to cover all of the different ways that you can navigate through an Excel worksheet. As described in the previous tutorial, an excel worksheet consists of rows which are represented by numbers 1 -- 1,048,576, and columns which are represented by letters A -- XFD. After column Z the columns are addressed by AA, AB, AC...BA, BB, BC...AAA, BBB,...,XFD. Where a row and a column intersect is an individual cell. For example, if you were to follow column B down to row 10 then you would find yourself at an individual cell which would be cell B10. Remember, as described in our previous tutorial, an active cell will have a dark bold border around it and the column letter and row number will be highlighted. When a cell is active, any data, text, numbers, formulas etc... will be entered into the active cell. Using You Keyboard to Navigate through Excel You are able to use your keyboard to navigate through excel. It is simple and is done just as you probably expected. You can use the arrow buttons to move up and down from cell to cell. If you press the right arrow then you will move right one cell. You will remain in the same row number but will move right one column letter. The same happens if you press the up, down or left button on your keyboard. If you press "CTRL + one of the arrows" then it will move you or "activate" the nearest cell which contains data, or is not empty. For example, if I was currently active in cell B4 and pressed "CTRL right" then it would activate F4 if cells C4 -- E4 were empty. If you press the PGUP or PGDN button then it will activate the cell that is exactly one page down or one page up. What is considered one page down or one page up depends on how much you are zoomed into the worksheet. For example, on my laptop using Windows 7, when Excel is zoomed at 100% there are 25 visible rows. If I am currently active in Cell C1 then when I hit the PGDN button it activates C26, exactly one page down. If I zoom out to 80% I can see 32 rows, therefore if I press the PGDN button it activates cell C33, exactly one page down. For the PGUP and PGDN buttons to work it is easier if you press the NUM LOCK button, or you can keep the NUM LOCK button off and simply press "SHIFT + PGUP or PGDN" Also many keyboards have the arrows and PGUP/PGDN buttons separate from the number pad. Navigating Through Excel With Your Mouse Another way that you can navigate through Excel is by using your mouse and keyboard in combination. You can always simply click on the cell that you want to activate instead of using the arrow buttons. Another thing you can do is zoom in and out of an Excel worksheet by holding the CTRL button and using the scroll wheel on your mouse if you have one. It is much easier to use your mouse when you are wanting to highlight multiple cells. This may be useful if you want to change the color of multiple cells at the same time or ad borders and other features that Excel offers. Using the mouse to scroll up, down, left, or right is also much faster than if you were using the arrows on the keyboard. When scrolling with the mouse Excel begins to scroll faster the more you move the mouse. When you activate a cell you are able to right click and make many different modifications that can also be made by using features on the ribbon. The way you make these modifications is just personal preference but you will find that using the right click button to modify cells is more efficient that referring to the ribbon for many features. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=BVhuyY-tRvM
Views: 8628 Subjectmoney
Excel 2013 Tutorial For Noobs Part 17: How to Open & Work w/Multiple Excel Workbooks Simultaneously
 
02:32
http://www.excelfornoobs.com In this Excel for beginners tutorial I show you how to open and work with multiple Microsoft Excel workbooks at the same time. I show you how you can minimize and resize each workbook manually and by using the arrange all command in the view tab. This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. Please don't forget to subscribe, rate and share. Please also visit our website at http://www.excelfornoobs.com. You can also add us on facebook where you can be updated every time we publish a new tutorial either on our website or here on Youtube. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=rZVP3Ervxzk
Views: 3958 Subjectmoney
Financial Statement Analysis #5: Ratio Analysis - Profitability Measures
 
03:53
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this financial ratio analysis lesson we are cover profitability measures. They all have the main purpose of measuring how efficiently the firm manages its operations and assets and are probably the most widely use ratios among financial analyst https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=tKLcdoFKgp8
Views: 16658 Subjectmoney
Pivot Table Tutorial Excel 2013 For Beginners Part 1: How to Make a Pivot Table in Excel 2013
 
03:53
http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=jraqkemFTNc - Excel 2013 Tutorial about how to use pivot tables. Pivot tables in excel are use to summarize and organize data which would otherwise be difficult and inefficient. In this tutorial I show you the basics on how to create and use a pivot table and make a pivot table report. This tutorial will work for Excel 2007 Excel 2010 and Excel 2013 Excel 2016, Microsoft Excel 2016, Microsoft Excel 2016 Tutorial, Excel 2016 Tutorial for beginners, Excel 2016 Tutorial For Beginners https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=jraqkemFTNc
Views: 38038 Subjectmoney
Excel 2013 Tutorial For Noobs Part 11: How to Create a workbook Sales Report & Forecast
 
04:54
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20A%20Step%20by%20Step%20Creation%20of%20a%20Sales%20Report%20and%20Forecast In this Microsoft Excel tutorial we will walk you through creating an Excel workbook by showing you step by step how to create a sales report and sales forecast. In this tutorial you will use different cell formats such as fill color and borders, you will learn number formats, text formats and formulas. You will also learn how to merge cells and align text. Please don't forget to subscribe, rate, share and check out our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Up5gJzmcjT0
Views: 23255 Subjectmoney
Microsoft Excel Gantt Chart Tutorial Excel 2010 Part 1 - Automated Progress Gantt Chart Tutorial
 
10:05
http://www.excelfornoobs.com Excel Gantt Chart Tutorial for Excel 2010. In this tutorial I show you how to make a Gantt Chart in Excel 2010 but this is not a basic Gantt Chart. This is a Gantt Chart that automatically updates the progress of the projects therefore it is a progress Gantt Chart. I do this by using the NOW function and the IF function along with the nested IF function. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=3JBs6gu2jKo
Views: 4156 Subjectmoney
Microsoft Excel Basics Tutorial for Beginners #1 (Excel 2013 Excel 2010 Excel 2007) Excel Basics
 
10:11
http://www.excelfornoobs.com This is a Microsoft Excel Tutorial for Beginners (not dummies) video series that covers the most necessary things that you will need to know about Microsoft Excel. In this accelerated crash course Excel tutorial series I describe the different parts of Excel, how to navigate through Excel, the types of data and how to insert data, data entry tips and techniques such as the autofill feature and copy and paste. I cover worksheet operations, Excel formulas and functions, cell reference and how to refer to cells using formulas and functions, cell and text formatting, illustrations and graphics such as wordart, charts and graphs and how to insert charts and graphs, I cover Excel tables and finally I show you how to save and print in Microsoft Excel. 1. A description of the Excel a. Ribbon i. Tabs (Organized by types of actions) b. Commands c. Cells i. Column letters ii. Row Numbers iii. Cell address 2. Types of Data a. Numeric Values b. Text c. Formulas 3. Data Entry a. Directly into the cell b. Entered into the formula bar c. Making Content Fit i. Changing Cell Size ii. Merging Cells d. AutoFill i. Months ii. Numbers iii. Dates iv. Text e. Copy Cut and Paste i. Keyboard Shortcut ii. Clipboard 4. Navigation techniques a. Using the Mouse b. Scroll Bars c. Using arrows i. CTRL+Arrows ii. Page Up and Page Down 5. Worksheet Operations a. Creating New Worksheet b. Deleting Worksheet c. Naming Work Sheet d. Worksheet Tab Formatting e. Duplicate Worksheet f. How to Hide a worksheet g. Order of Worksheets h. Copying and Pasting between worksheets 6. Formulas & Functions a. Operators i. Addition ii. Subtraction iii. Multiplication iv. Division b. Literal Values and c. Cell Reference i. Locking Cell reference ii. Locking Column, Locking Row, Locking Both d. Inserting Functions i. Manually ii. Function Library 1. Function Category a. Function description 2. Function Arguments a. Different types of arguments depending on the function i. No argument Now Function ii. Single Argument SQRT iii. Indefinite arguments Sum Function iv. Set number of arguments If Function iii. Insert Function Dialog Box e. Functions on the Ribbon i. Function Category 1. Function description 7. Formatting a. Format with the Ribbon b. Format Cells Dialog Box c. Borders d. Font Color e. Cell Fill f. Text Formatting g. Number Formatting h. Content Alignment i. Clearing 8. Graphics a. Charts b. Wordart c. Clip Art d. Images 9. Tables 10. Saving and Printing https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=CapdrHxv18c
Views: 7151 Subjectmoney
How to Price/Value Bonds - Formula, Annual, Semi-Annual, Market Value, Accrued Interest
 
09:40
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Bond%20Pricing In this video we show you how to calculate the value or price of a bond. We teach you the present value formula and then use examples to discount the coupon payments and principle payment to their present value. We also show you how to solve the price of a semi-annual bond. In this case you would multiply the periods by two and divide the YTM and coupon payments by 2. We also show you how to solve the accrued interest of a bond to find out what it would sell for at a date that is not on the exact coupon payment date. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=7zCqoED8MVk http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 90092 Subjectmoney
Excel 2013 Tutorial For Noobs Part 7: Borders, Draw Borders, Erase Borders 2007 2010 2013
 
04:04
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20To%20Style%20Your%20Workbook%20Using%20Borders In this Excel tutorial we introduce how to style your Excel workbook with borders. We show you the different ways to add, edit and erase borders. Please subscribe, rate and share our videos. Please also visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=DnlfvIHFCDQ
Views: 7769 Subjectmoney
Financial Statement Analysis #6: Ratio Analysis - Market Value Measures
 
06:10
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this financial statement analysis lesson we cover ratios know as market value measures. Market value measures need the stock price to be calculated therefore they are useful for publicly traded companies. The ratios we cover are market to book ratio, book value, the pe ratio or P/E ratios or price to earnings ratio, the eps or earnings per share, enterprise value, market capitalization and enterprise value multiple. Please be sure the subscribe, rate & share our videos. Please also visit our website at http://www.subjectmoney.com and http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=GUVbPr88rOA
Views: 34459 Subjectmoney
WACC for a Division - Weighted Average Cost of Capital Formula - How to - Corporate Finance
 
10:02
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=How%20to%20find%20the%20Weighted%20Average%20Cost%20of%20Capital%20%28WACC%29%20of%20a%20Division In this tutorial we show you step by step how to solve the Weighted Average Cost of Capital WACC for a division. Many companies operate in different industries therefore their risk and the cost of equity is different for each division. In our example we use Boeing. To solve the WACC for a division you will need to know the company beta, the capital structure, the cost of debt, the debt/equity ratio, the market risk and the risk free weight. You will also need to find proxies to assume the divisions unlevered and levered betas. You will use the Capital Asset Pricing Model CAPM to find the cost of equity for the division and then use this figure to solve the WACC for the division. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Pr-CYOQPN3g
Views: 11161 Subjectmoney
Excel 2013 Tutorial For Noobs Part 26: How to Copy, Cut & Paste a Range of Cells 2007, 2010, 2013
 
03:21
http://www.excelfornoobs.com In this Microsoft Excel for Beginners tutorial I show you how to copy, cut and paste cells and a range of cells in Excel. This tutorial works for Excel 2007, Excel 2010 and Excel 2013. Please be sure to subscribe, rate and share. Please also visit our website at http://www.excelfornoobs.com and add us on Facebook. All the links are on our channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=bEnpG3HZoos
Views: 5314 Subjectmoney
Excel 2013 Tutorial For Noobs Part 14: How to Print and Use Page Layout to Preview - 2007, 2010
 
01:16
http://www.excelfornoob.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20use%20Page%20Layout%20and%20Print%20in%20Excel In this tutorial we show you how to print your workbook and how to use the page layout command in the view ribbon to make sure your workbook prints out properly all on a single page. Please be sure subscribe, rate and share our videos. Please also visit our website at http://www.excelfornoobs.com and http://www.subjectmoney.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=RnPSErWFaNo
Views: 4516 Subjectmoney
Excel 2013 Tutorial For Noobs Part 16: How to Use Data Forms & Customize Excel Quick Access Toolbar
 
03:36
http://www.excelfornoobs.com In this Excel for beginners tutorial I show you how to customize your quick access toolbar and how to use data forms to enter data into Excel. Data forms are useful, especially if you are entering data into a large range of cells that doesn't fit on your screen. Using forms can make your data entry in Excel much more efficient that having to scroll and enter data cell by cell. This tutorial along with all of our other Excel tutorials works for Microsoft Excel 2007, Excel 2010 and Excel 2013. Please be sure to subscribe, rate and share our videos. Please also look on our channel for links to facebook, Google Plus and our websites. For text versions of our tutorials visit our website a http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=_D6L92W5_q0
Views: 9302 Subjectmoney
Excel 2010 Tutorial for Beginners - Part 3
 
09:02
http://www.excelfornoobs.com http://www.subjectmoney.com Excel For Noobs, Excel tutorial,beginners, Excel, Microsoft excel, excel for beginners, excel for dummys, Microsoft excel 2010, how to use excel, tutorial, Microsoft excel, How do I in excel, www.subjectmoney.com Follow the link below for another basic Excel tutorial for beginners https://www.youtube.com/watch?v=CapdrHxv18c https://www.youtube.com/watch?v=eMOjZWo4Z3M https://www.youtube.com/user/Subjectmoney http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 36754 Subjectmoney
Excel 2013 Tutorial For Noobs Part 22: How to Resize Rows and Columns in Excel 2007, 2010 and 2013
 
02:27
http://www.excelfornoobs.com In this Excel for beginners tutorial I teach you all the different ways to resize rows and columns in Microsoft Excel. This Excel tutorial works for Excel 2007, Excel 2010 and Excel 2013. Please be sure rate, share and subscribe. Please also visit our website at http://www.excelfornoobs.com. You can also add us on Facebook and Google Plus. The links are located on our channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=TuvFeKyxmKE
Views: 4165 Subjectmoney
Excel 2013 Tutorial For Noobs Part 24: How to Search, Find & Select Special Cells in Excel 2010
 
02:27
http://www.excelfornoobs.com In this tutorial I show you how to use the find and select command to locate special cells. For example, if you want to locate cells that contain formulas you can use the Find and Select command to find special cells. Comments Select cells that contain comments. Special Cells are listed below: Constants Formulas Blanks Current Region Current Array Objects Row Differences Column Differences Precedents Dependents Last Cell Visible Cells Only Conditional Formats Data Validation Please don't forget to subscribe, share, and rate. Please also visit our website at http://www.excelfornoobs.com and also add us on Facebook for updates. You can find the links on our YouTube channel page. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=NJOsuxtjFKA
Views: 5165 Subjectmoney
Excel For Noobs Part 50: How to Create a New Cell Style in Excel Excel 2016 Excel 2013
 
01:53
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial6.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Create%20a%20New%20Custom%20Cell%20Style%20in%20Excel In Excel you can create your own styles. As mentioned in other tutorials, Excel styles can have up to 6 different attributes, Font, Number Format, Borders, Alignment, Patterns, and Protection. Creating your own style can be very useful and efficient because you will have the option of adding your preferred style to multiple ranges of cells within a workbook simultaneously. This would obviously be much faster than working each cell and each attribute one by one. To create your own style in Excel follow the steps listed below. Step 1: Activate a cell and add all the different formatting options you want to be included in your new style. Here you can add color fill, font formats, borders etc. Step 2: Now go to Home, and in the Styles group click on Cell Styles. A drop-down menu will appear showing you a preview off all the pre-formatted cell styles. Step 3: Click on New Cell Style... which is located at the very bottom of the menu. The style dialog box will appear. How to add new cell styles in Excel Tutorial Step 4: In the Style dialog box where it says Style Name, enter the new name of your style and click OK. Step 5: Now click on the Cell Styles button and in the Custom group of the drop-down menu you will see that your style is now available for you to apply to any range of cells you prefer. Now if you want to add this cell style you can simply select a range of cells and apply the new cell style. This would obviously be much more efficient than adding each attribute one by one. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=_0azHoLKMvM Microsoft Excel 2016, Excel 2016, Excel 2016 Tutorial, Microsoft Excel 2016 Tutorial
Views: 3900 Subjectmoney
Excel Tutorial: How to Add Picture/Images to a Comment in Excel 2007, 2010 & 2013
 
05:21
http://www.excelfornoobs.com In this quick Excel Tip/Trick tutorial I show you how to add an image to your Excel comments. Sometimes it may be beneficial to add pictures to Excel comments especially when some of the qualitative data is something that my be best described with an image. Please be sure to share, subscribe and rate our videos. Please also visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=zvTYsVD0rGs http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 29882 Subjectmoney
Roth IRA Traditional IRA and 401K plans - Rules - Advantages - Disadvantages - Saving for Retirement
 
05:17
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Saving%20for%20Retirement:%20Roth%20IRA%20vs%20Traditional%20IRA This is a video explaining the differences of a Roth IRA and a Traditional IRA. In this video we also cover a little about 401k plans and explain the benefits such as the tax benefits and disadvantages such as the difficulty of withdrawing money. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=B3ARR1okoEU
Views: 11649 Subjectmoney
Excel 2013 Tutorial For Noobs Part 13: Charts - Multiple Series - How To Insert & Format
 
06:34
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Insert%20Charts,%20Chart%20Tools%20and%20Chart%20Formats%20For%202007,%202010%20and%202013 In this tutorial we introduce you to Excel charts. We will show you how to insert a chart and how to format a chart using the Format Chart dialog box and the chart tools. In our example we insert a 2d columned bar chart which is good when comparing multiple series of data among a range of categories. Please be sure to subscribe, rate and share our videos. Please also visit our websites at http://www.excelfornoobs.com and http://www.subjectmoney.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=7yvUIzDqoAs
Views: 23910 Subjectmoney
Excel 2010 Tutorial Circular Reference Warning & Enabling Iterative Calculations
 
04:18
Excel 2010 tutorial for beginners circular reference warning with Excel formula and resolving the circular reference by enabling iterative calculations. http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial7.php?title=Excel%20For%20Noobs%20Tutorial:%20Circular%20Reference%20and%20Enabling%20Iterations%20to%20Fix%20Circular%20Reference%20Formulas https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=BPuDV3--Wkg
Views: 8286 Subjectmoney
Excel 2013 Tutorial For Noobs Part 28: How to Name a Range of Cells and Search by Name 2010 2013
 
02:05
http://www.excelfornoobs.com In this Microsoft Excel tutorial for beginners I show you how to copy and paste special cells. For example, using this Excel function you could copy a range of cells that contains formulas comments and formats but you could choose to only paste special features of the copies range of cells. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. Please be sure to subscribe, rate and share. Please also visit our website at http://www.excelfornoobs.com and add us on Facebook. The links can be found on our channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=ImuLpyi8W-Q
Views: 2643 Subjectmoney
Excel 2013 Tutorial For Noobs Part 35: How to Add and Delete New Excel Table Rows and Columns
 
02:21
http://www.excelfornoobs.com In this Excel for beginners tutorial I show you how to insert and add new rows and columns to a table in Excel. In this Excel tutorial I also show you how to delete rows and columns in Excel tables. In this Microsoft Excel tutorial I am using Excel 2013 but this tutorial also applies to Excel 2010 and Excel 2007. Please visit our website at http://www.excelfornoobs.com and also don't forget to rate, comment, subscribe and SHARE our videos. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Xbg-I1vd9FM
Views: 16383 Subjectmoney
How to Make a Gantt Chart Microsoft Excel 2013 Tutorial #2   Automated Progress
 
10:01
http://www.excelfornoobs.com In this Microsoft Excel 2013 tutorial I show you how to create a Gantt Chart in Excel. For this Gantt chart I also use the Today function (=today()) and I use the If function (=if()) to show to progress and to automate and update the progress as time passes. This tutorial will also work for Excel 2007, excel 2010 and excel 2013 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=C_TOI-eip-o
Views: 11513 Subjectmoney
Price Elasticity of Demand (PED) - Point PED & ARC PED Formula w/Mid-Point Formula - Microeconomics
 
06:02
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Price%20Elasticity%20of%20Demand In this lesson I am briefly teaching the formulas behind price elasticity of demand. I teach the point price elasticity of demand formula and the ARC price elasticity of demand formula which contains the mid-point formula. I also cover what the values mean. A PED greater the 1 is inelastic, a value less than 1 is elastic and a value equal to 1 is unit elastic. The goal is to have a ped of 1 which is the price where revenues will be maxed. Please don't forget to subscribe, rate & share our videos. Please also visit our websites at http://www.subjectmoney.com & http://www.excelfornoobs.com. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=8a6zADgZM9s http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 47336 Subjectmoney
Excel 2013 Tutorial For Noobs Part 25: How to Find & Replace Content Numbers & Formulas in Excel
 
03:49
http://www.excelfornoobs.com In this Excel for beginners tutorial I teach you how to search find and replace content, numerical values and formulas in a cell or multiple cells. You can do this by using the Find and Select command. In Excel you can locate cells by using the Find and Replace command. Suppose you wanted to locate a cell or all cells that contained a certain word or number. Instead of searching throughout your worksheet you could use the Find and Replace command and let Excel do the work for you. Find In the Home tab under the Editing group click on the Find & Select command and from the drop-down menu click on Find and the Find and Replace dialog box will appear. The Find and Replace dialog box has two tabs, the Find tab and the Replace tab. Where it says "Find What" enter the content that you want to locate. Now click on the Options button and more search options will appear in the dialog box. Here you have options of Within, Search, Look in, Match case and Match entire cell contents. Use the options to tailor your search and press Find All. find and replace in excel 2013 Within: Here you can choose to search a single worksheet or the entire workbook. Search: Here you can organize your search by rows or columns. If you were to choose By Rows then your search results would be organized by rows. The very next cell in the search would be the very next cell in the row that contained your data. If you organized your search By Columns then the very next cell in your results would be the next cell in the column that contained your data. Look In: Here you can choose to search inside formulas, comments are regular values for the data you want to locate. Match Case: If this box is checked then your search will be case sensitive. Match entire cell contents: If this box is checked then the cell or cells found must contain on the search string and nothing else. Replace Imagine you had a large inventory list with the names of multiple suppliers. What if one of the suppliers changed their company name? It would be very time consuming to change the company name cell by cell. Instead you can use the Find and Replace command and change all cells instantly. In the Find and Replace dialog box make sure the Replace tab is activated. The only difference with the Find tab and the Replace tab is that you have a new box and buttons that allow you to replace the cells in your search results with other content. The options work the same in Replace as the do in Find. Make sure that you use the Match Case and Match entire cell contents if necessary. If you searched and replaced the number 3 with 5 without checking the Match entire cell contents option then the number 2 would be replaced with the number 5 even if it was in a series of numbers. For example, 638 would be 658 after you click Replace All or Replace Next. This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=aKUICZPIpqg
Views: 29762 Subjectmoney
Excel For Noobs Part 45: How to Display Text at an Angle Text Orientation Format Excel 2016 2013
 
01:51
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial6.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Display%20Text%20at%20an%20Angle Many Excel users like to display the content within their column headers at an angle or diagonally across the cell. This gives the worksheet a more professional and visually stimulating appearance. To format your text diagonally at a 45 degree angle simply follow the steps below. Step 1: Select the cells of range of cells where you want to format your text to be displayed diagonally. Step 2: Activate the Home tab and locate the alignment group. Step 3: In the alignment group locate and click the orientation button and and drop down menu will appear offering you many different text orientation options. How to make text a 45 degree angle diagonally in Excel Step 4: Select either Angle Counterclockwise or Angle Clockwise depending on which angle you would like you would like you text to be present diagonally. How to make text diagonal at a 45 degree angle in Excel Choosing a Specific Angle Degree for your Text Orientation Your text doesn't have to be displayed at a 45 degree angle. You could display it at whatever angle you want. To do this follow the steps below. Step 1: Press CTRL+1 on your keyboard to open the Format Cells dialog box. Step 2: Make sure the Alignment tab is activated. Step 3: In the top right of the dialog box there will be a group labeled Orientation with what looks like half a clock, and a spinner button where you can choose the degree of the angle you would like your text to be displayed. Use the Degree spinner button to choose the degree of the angle you prefer your text to be displayed at and click OK. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=5gnkHtw0eVs Microsoft Excel 2016, Excel 2016, Excel 2016 Tutorial, Microsoft Excel 2016 Tutorial
Views: 38350 Subjectmoney
Excel 2013 Tutorial For Noobs Part 23: How to Select a Range of Cells & Cells in Multiple Worksheets
 
04:32
http://www.excelfornoobs.com In this Microsoft Excel tutorial for beginners I show you how to select an entire column, an entire row and how to select a range of cells in a single sheet or how to edit cells in multiple worksheets at the same time. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. There are multiple ways to select cells, a range of cells or multiple ranges of cells in Excel. Sometimes you might even need to know how to select multiple noncontiguous ranges in multiple worksheets to make one single change. This would be much more efficient than making the same change cell by cell. If you are this far along then I assume you are already familiar with how to select cells so I will only cover additional cell selecting techniques that you might have not discovered yet. Selecting Entire Rows and Columns To select an entire row or column simply click on the row number or column letter. Now any commands you click on will affect every cell within the selected column. To select multiple adjacent rows or columns click on the row number or column letter and while holding the left-click button drag your mouse over the range of columns or rows you want to select. Now any command you click will affect all cells in the ranges or columns you have selected. To select multiple rows or column that are not adjacent to each other click on a row number or column letter, hold down CTRL and select all the other rows or columns you want to include in the selection. To select and entire row or columns click on a row number or column letter and press CTRL + SHIFT + SPACEBAR. Now all commands will affect the entire sheet. Select Multiple Ranges of Cell Simultaneously There may be times that you want to select multiple ranges of cells that are not connected. Select a range of cells, press and hold CTRL and then select the other range of cells you want to be select. You can do this for as many cell ranges as you need. Another way to perform this action is to select a cell, press and hold SHIFT and then click on the opposite corner of the range of cells. Then press and hold CTRL and click the first cell in the next range of cells you are going to select. Now press and hold SHIFT and select the cell in the opposite corner of the range. You can also select a range of cells by manually entering it using the Find and Select command. In the Home tab under the Editing group click Find & Select and from the drop-down menu click on Go To.... The Go To dialog box will appear. In the Reference box enter the range of cells you want to select and click OK. If cell A1 was going to be the top left cell in the range and cell F20 was going to be the bottom right cell in the range then you would enter A1:F20 in the reference box and press OK. How to Select Cells and Ranges in Multiple Worksheets Simultaneously Suppose you have a workbook that contains identically formatted tables in separate worksheets. This could be the case if you had a workbook that contained quarterly sales reports, budgets, scenarios etc. You might want to make changes to the borders, fill colors or other types of cell formats. To select cell ranges among multiple sheets first activate all sheets by selecting all worksheet tabs while holding the CTRL button. Now select the range of cells in the worksheet that is showing. Any changes you make to the format of the cells will be made in the same range of cells in every worksheet that you selected. When you have multiple worksheets selected, Excel is in Group Mode. Your title bar should have [Group] next to the file name. If you want to select all worksheets in a workbook you can right-click and from the shortcut menu click Select All Sheets. NOTE: In group mode not all commands are available. For example if you click on the Insert tab you will see that almost every command on the ribbon is deactivated. Please be sure to rate, subscribe and share our videos. Please also visit our website at http://www.excelfornoobs.com. You can also add us on Facebook to keep updated. The links can be found on our Youtube channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=ILQ-rXjNGmU
Views: 34671 Subjectmoney