3 Questions to Ask Yourself To Unblock Your Financial Abundance

Do you feel that your financial abundance is being blocked? It could very well be being blocked by you. In this audio, I talk about the three questions you should ask yourself in order to unblock your financial abundance.
http://bit.ly/1Vz88S7

Excel Tips – How to Convert Text to Numbers in Excel 2010

Excel Tips How to Convert Text to Numbers in Excel 2010 In this tutorial we will cover how to both detect text and then convert text to numbers in Excel 2010. Quick Keyboard Trick to Detect If Cells Are Numeric or Text A cool trick to detect text in a series of numeric values is using CTRL+SHIFT+# to quickly convert them to dates DD-MMM-YY format.  Only the numeric values will be convert to text, otherwise they will remain unchanged. Once you have detect if cells are text, there are some tricks you can use to quickly convert text to numbers. .video-container{text-align:center;} How to Convert Text to Numbers There are several ways to create a checkmark or checkbox in an Excel worksheet. Here are a few of them. You may find that sometimes after you import or copy data from a database or other external source, the numbers in your worksheet are actually stored in cells as text. This can cause problems with calculations and sorting, among other things. A telltale sign that a number is st
http://bit.ly/1Vyv97B

The Key Differences Between Gratitude vs Appreciation

Did you know there is a difference between gratitude and appreciation? But does the difference matter? Check what I found about gratitude vs appreciation.
http://bit.ly/1Pc1CRB

Excel Tips – How to Eliminate Divide by Zero Errors and Add Checkmarks in Excel 2010

Excel Tips How to Eliminate Divide by Zero Errors and Add Checkmarks in Excel 2010 In this tutorial we will cover two tips: how to eliminate divide by zero errors, and also how to add a checkmark, all in Excel 2010. How to Eliminate Divide by Zero Errors One question I m asked is how to get rid of the divide by zero errors, #DIV/0! It s common to get #DIV/0! errors in worksheets that contain formulas with division operations. This error results from the divisor part of a division formula referring to a cell that is blank or has a zero value. There is no perfect solution for this problem. Most times you ll want to know if a formula is trying to divide a number by zero, but there may be times where you want to suppress this error for reporting purposes. In the past we had to use one of these IF formulas to avoid this error. =IF(D2=0, ,C2/D3) or =IF(D2=0,0,C2/D2) But starting in Excel 2007, Excel introduced a new Excel function called IFERROR. With this function you need include your for
http://bit.ly/1PbyQAq

The Power Couples Hangout – Episode 29 | The Power of I AM Statements

Watch as Bren and Mike and power couples co-hosts, Felicia White and Brian White, talk about the power of I AM statements, and how to use them.
http://bit.ly/1O9z7mG

Excel Tips – How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010

Excel Tips  How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010 In this tutorial we will cover two tips: how to quickly edit formulas, and also how to quickly edit data in multiple cells, all in Excel 2010. How to Quickly Edit Formulas  I am sure once you see this tip you will find lots of uses for it. In typical worksheets, there is a great deal of consistency in formulas. They are usually identical in structure, differing only in the actual cells they are referencing within the spreadsheet. But when it comes to relative referencing, most formulas are identical. For example, =SUM(G1:G50) and SUM(H1:H50) are really SUM(the first row in this column to the cell immediately above this formula). When you create worksheets that have formulas with identical structures, it makes copying and editing and understanding your formulas a whole lot easier. To copy a formula, most Excel users type the first formula, then copy and paste it to the other cells. Same goes for editing
http://bit.ly/1O90cpX

The Power Couples Hangout – Episode 28 | With Guests Allyn and Gary Reid

Watch as Bren and Mike and power couples co-hosts, Felcia White and Brian White, interview with Allyn Reid and Greg Reid.
http://bit.ly/1KYMGQm