Home
Videos uploaded by user “Subjectmoney” for the 2013
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: 786207 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: 888461 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: 16845 Subjectmoney
Microsoft Excel 2013 Tutorial For Beginners #4: Crash Course Data Entry, Formulas, Formats, Charts
 
04:49
http://www.excelfornoobs.com This is a Crash Course Microsoft Excel 2013 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. In this video we should you how to do basic math formulas in Excel, we introduce you to some data entry techniques and teach you formatting and how to make basic charts. By following along this Excel 2013 Crash Course you should be familiar with how to navigate and perform the most common Excel functions. 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. Follow the link below for another basic Excel tutorial for beginners https://www.youtube.com/watch?v=CapdrHxv18c 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 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=jrHpX99PDRw
Views: 116092 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: 14326 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: 26303 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: 9076 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: 81093 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: 13986 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: 98665 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: 18554 Subjectmoney
Excel 2013 Tutorial For Noobs Part 12: Conditional Formatting, Clearing Rules & Quick Analysis Tool
 
03:32
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20Conditional%20Formatting%20Introduction In this tutorial we introduce you to Conditional formatting in Excel. We do this by using our example of a simple sales report that we built in previous tutorials. We also show you how to remove conditional formatting rules and we introduce the quick analysis tool which is only available in Microsoft Excel 2013. Please be sure to 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=m9zaqVMACKU
Views: 7999 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: 43392 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: 18277 Subjectmoney
Excel 2013 Tutorial For Noobs Part 15: Data Entry Tricks AutoCorrect AutoComplete Tables Dates Times
 
06:47
http://www.excelfornoobs.com In this Excel tutorial I show you some data entry techniques and trick that will help make your time entering data into Excel more efficient. Here I show you how to use AutoCorrect to make an abbreviation represent a long word, I show you the AutoComplete feature, Introduce you to Excel tables and also show you different functions for dates and times. Using the Current function and the Now function. This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013 Don't forget to subscribe, share and rate. 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=QyYJ5VcDeW8
Views: 6527 Subjectmoney
Excel 2013 Tutorial For Noobs Part 20: How to Insert New Rows, Columns & Cells
 
03:08
http://www.excelfornoobs.com In this Microsoft Excel for Beginners tutorial I show you how to insert a new row, column or cell. I also show you how to insert multiple new rows, columns and cells in Excel. This tutorial will work for Excel 2007, Excel 2010 and Excel 2013. Please be sure to subscribe, rate and share our videos. Please also visit our website at http://www.excelfornoobs.com. You can also add us on Facebook for updates of new content and video tutorials. All of our links can be found on our channel page. Last hour Today This week This month This year https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=6fnElMlJZSY
Views: 9386 Subjectmoney
Excel 2013 Tutorial For Noobs Part 29: How to Copy and Paste Special Cells 2010 2013
 
03:41
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=p-zzyQtGQg4
Views: 4877 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: 27407 Subjectmoney
Microsoft Excel 2013 Tutorial For Beginners #2: Crash Course Data Entry, Formulas, Formats, Charts
 
10:01
http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=rhx7TnBPBAQ This is a Crash Course Microsoft Excel 2013 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. In this video we should you how to do basic math formulas in Excel, we introduce you to some data entry techniques and teach you formatting and how to make basic charts. By following along this Excel 2013 Crash Course you should be familiar with how to navigate and perform the most common Excel functions. 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. Follow the link below for another basic Excel tutorial for beginners https://www.youtube.com/watch?v=CapdrHxv18c 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: 229351 Subjectmoney
Microsoft Excel 2013 Tutorial For Beginners #3: Crash Course Data Entry Formulas Formats Charts 365
 
10:01
http://www.excelfornoobs.com This is a Crash Course Microsoft Excel 2013 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. In this video we should you how to do basic math formulas in Excel, we introduce you to some data entry techniques and teach you formatting and how to make basic charts. By following along this Excel 2013 Crash Course you should be familiar with how to navigate and perform the most common Excel functions. This tutorial also works for Microsoft Excel 2007, Excel 2010 and Excel 2013 Excel 365 however there are some features such as Recommended charts that the older versions of excel don't have. Follow the link below for another basic Excel tutorial for beginners https://www.youtube.com/watch?v=CapdrHxv18c 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 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=kRSwpx_ryq4
Views: 151503 Subjectmoney
Excel 2013 Tutorial For Noobs Part 19: How to View, Split & Compare Side by Side Multiple Worksheets
 
04:18
http://www.excelfornoobs.com In this Excel tutorial I show you how to view multiple worksheets at the same time, how to split worksheets and how to view worksheets side by side. This could be useful when comparing worksheets especially if you are updating a worksheet and you want to compare it to the older version. Splitting worksheets is useful when you have a worksheet that contains a large range of data. By splitting worksheets you can view multiple part of a worksheet without scrolling back and forth. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013 Last hour Today This week This month This year https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=lfEklr6TvfE
Views: 4106 Subjectmoney
Excel 2013 Tutorial For Noobs Part 27: How to Copy and Paste as an Image/Picture 2013
 
01:26
http://www.excelfornoobs.com In this Microsoft Excel tutorial for beginners I show you how to copy and paste a range of cells or a single cell as an image or picture. By doing this you insert an image of the copied cells. You can also save the image of cells as a picture to your computer. 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 by following the links located on our channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=qqLGqIvLM0M
Views: 2659 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: 7542 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: 77615 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: 3734 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: 32631 Subjectmoney
Excel Tutorial for Beginners #1 -How to Use - Formulas Data Entry Charts Formatting Navigation
 
10:10
http://www.excelfornoobs.com Excel 2013 Tutorials for beginners that cover the 10 most basic features that everyone must know about Microsoft Excel 2013 Excel 2010 and Excel 2007. In this accelerated tutorial I cover how to do the following How to Navigate through Excel Data Entry for Excel Resizing Cells to Make Content Fit Excel Formulas and Excel functions Worksheet Operations Excel Tables Excel Charts How to Save Excel How to Print in Excel https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=VTL8c4VU1jo
Views: 1503 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: 42987 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: 23453 Subjectmoney
Excel 2013 Tutorial For Noobs Part 31: How to Add Comments, Format, Add Pictures and Delete Comments
 
07:12
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial4.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Add,%20Edit%20and%20Format%20Comments%20in%20Excel In this Excel for beginners tutorial I show you how to add comments to a cell in Microsoft Excel 2013. I also show you how to format comments by adding fill color, patters, borders images and even how to change the shape of a comment box. This Excel Tutorial about comments will work for Microsoft Excel 2013, Excel 2010 and Excel 2007. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=S6bUI4Xz7JM
Views: 4606 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: 28415 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: 4983 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: 5116 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: 4036 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: 10441 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: 10474 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: 14327 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: 107152 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: 29210 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: 6922 Subjectmoney
Microsoft Excel Gantt Chart Tutorial Excel 2010 Part 2 - Automated Progress Gantt Chart Tu
 
09:46
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=340FtQdKTBA
Views: 7289 Subjectmoney
Excel 2013 Tutorial For Noobs Part 33: How to Style Tables in Excel Style Templates & Custom Styles
 
02:20
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial5.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Style%20Excel%20Tables In this Excel for beginners tutorial I show you how to style tables in Microsoft Excel. Here I show you how to use Table Tools to find different table styles and how to create custom table style for Excel tables. This Excel for beginners tutorial works for Microsoft Excel 2013, Excel 2013 and Excel 2007. Please be sure to interact with our videos. Rate, SUBSCRIBE, Comment, & SHARE!! This interaction helps with our ranking in the Search Engines. Please also visit our website at http://www.excelfornoobs.com and add us on Facebook and Google +. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=pXot8fU7FOA
Views: 3481 Subjectmoney
Excel 2013 Tutorial For Noobs Part 21: How to Delete Hide & Unhide Rows Columns & Cells 2010
 
02:41
http://www.excelfornoobs.com In this Excel for beginners tutorial I will show you how to delete, hide and unhide rows columns and cells in Excel. There are multiple ways to hide and unhide rows and columns along with multiple ways to delete rows columns and cell. In this Microsoft Excel tutorial we show you how. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. 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 and Google Plus. The links are located on our channel page. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=HY4xTMAF27E
Views: 7810 Subjectmoney
Excel 2013 Tutorial For Noobs Part 36: How to Move a Table in Excel
 
01:10
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial5.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Move%20Excel%20Tables In this Microsoft Excel for beginners tutorial I show you how to move tables in Excel. I also show you how to move an Excel table to a new or different worksheet within the same Excel workbook. This Excel tutorial about moving tables was performed using Microsoft Excel 2013 however it also applies to Excel 2010 and Excel 2007. Please be sure to subscribe to Excel for Noobs and also rate, comment and share. You can visit our website http://www.excelfornoobs.com for contextual versions of these tutorials. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=SeDJbUz61r0
Views: 17863 Subjectmoney
Excel 2013 Tutorial For Noobs Part 37: Excel Tables Total Row
 
01:55
http://www.excelfornoobs.com In this Microsoft Excel tutorial for beginners I show you how to use the total for for Excel tables. I show you how the total row has a drop down menu that offers many different formula such as the average formula, sum formulas, Count, Standard deviation and many more functions. This excel video tutorial was performed using Microsoft Excel 2013 but can also be applied to Excel 2007 and Excel 2010. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=4ef7fqAoLhg http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 37178 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: 31665 Subjectmoney
Excel 2013 Tutorial: How to Use Strikethrough Font Effect to Draw a Line Through a Word
 
04:32
http://www.excelfornoob.com http://www.excelfornoobs.com/tips.php?title=Excel%20Tips%20Tutorial:%20How%20to%20Draw%20a%20Line%20Through%20a%20Word%20in%20Excel%20-%20Strikethrough In this Microsoft Excel Tips and Tricks tutorial for beginners I show you how to draw a line through a word using the strikethrough font effect. This tutorial works for Microsoft Excel 2013, Excel 2010, Excel 2007 and Excel 2003. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=3NEnyYFibKw
Views: 7120 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: 38734 Subjectmoney
Excel 2013 Tutorial For Noobs Part 38: How to Remove/Delete Duplicate Content in Excel Tables
 
02:09
http://www.excelfornoobs.com In this Microsoft Excel tutorial for beginners I show you how to delete duplicate content in Excel. The best way to delete duplicate rows or content is to use Excel tables. You can use Excel tables to delete duplicate content and use the duplicate content dialog box to be as specific as you want. You can remove rows and are an exact match or you can delete rows where certain columns or categories. This video tutorial was created using Microsoft Excel 2013 but it will also work for Microsoft Excel 2010 and Microsoft Excel 2007. Please be sure to subscribe, rate, comment and share. Please also visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=NcISWhHuQF4
Views: 4304 Subjectmoney
Excel Tutorial: How to Name Excel Tables For Beginners Excel 2016 Tutorial Excel 2013 Tutorial
 
02:46
Excel 2013 Tutorial for Beginners on how to name Tables in Excel. http://www.excelfornoobs.com http://www.excelfornoobs.com/tips.php?title=How%20to%20Name%20an%20Excel%20Table Naming a table in Excel simply makes sense. A name can also provide a quick description of what the table describes. It is also easier to remember a table by a familiar name than simply trying to remember a generic table name like "Table1". To name a table in Excel simply follow the steps below. Step 1: Select a cell within your table. Step 2: Click on the Design tab and locate the Properties group in the Design ribbon. Step 3: In the Table Name box replace the generic table name (for example Table1) with the name you want to give to your Excel table and press ENTER. Excel 2013 Tutorial How to Name Excel Tables Excel Table Name Error for Invalid Table Name You may get an error box if you entered a table name that is invalid. Table names must start with either a letter or an underscore, they cannot contain a space and cannot be the same name as a range of cells or a name that will conflict with other names that Excel already has built in. This Excel Table Name Tutorial for Beginners works in Excel 2007 Excel 2010 and Excel 2013 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=qxbuvITKZOI Excel 2016 Tutorial, Microsoft Excel 2016, Excel 2016, Microsoft Excel 2016 Tutorial
Views: 20693 Subjectmoney