geoffnoble.co.za
Geoff Noble: December 2014
http://www.geoffnoble.co.za/2014_12_01_archive.html
Forget the Noise Blog. Welcome to my personal website/blog. Find out more about me here. Or on my LinkedIn profile. I also blog on the following sites:. No posts. Show all posts. No posts. Show all posts. Subscribe to: Posts (Atom). Geoff Noble is a Chartered Accountant and CFA Charterholder with over 10 years financial services experience. Geoff runs his own consultancy firm, Nob. The views on this website are my own and do not convey the views of the organisation I work for. Tweets by @gfro za.
geoffnoble.me
Geoff Noble, My Links
http://www.geoffnoble.me/Links
Geoff Noble - Google. Undisclosed - Durban, South Africa - Geoff Noble. Invest for the long term at the . A Common Sense Approach to Investing by Geoff Noble. 1. Add a comment. Geoff Noble (@gfro za) Twitter. The latest Tweets from Geoff Noble (@gfro za). Geoff Noble. Long term investing at the lowest cost. Looking to merge finance and technology. Durban. Forget The Noise A Common-Sense Approach to Investing. Geoff Noble - Director @ Noble Brothers Consult crunchbase. Geoff Noble on Pinterest. Forget the...
financeforexcel.com
FinanceForExcel.com by Geoff Noble: April 2013
http://www.financeforexcel.com/2013_04_01_archive.html
Finance and Excel by Geoff Noble. Find us on YouTube. Monday, April 15, 2013. Excel Boot Camp] Need to look up Data? Use INDEX MATCH, not VLOOKUP. I remember my Information Systems 1 course at UCT, we were taught this “wonderful” function called VLOOKUP. As a function that “looks in the first column of an array and moves across the row to return the value of a cell”. Sounds pretty handy, doesn’t it? Monday, April 1, 2013. Training] Basic Introduction To Excel Part 1. Subscribe to: Posts (Atom).
financeforexcel.com
FinanceForExcel.com by Geoff Noble: About
http://www.financeforexcel.com/p/structured-and-proper-use-of-excel-can.html
Finance and Excel by Geoff Noble. Find us on YouTube. This website is a collection of tips, thoughts and things that I have come across while using Excel. Feel free to copy and share anything you find here. Subscribe to: Posts (Atom). Excel Data] 7 Steps to complete a Sensitivity Analysis using Data Tables. MS EXCEL]: Create Yes/No Dialog Boxes with Data Validation and Advanced Number Formatting. Xlwings] Almost ready for v1.0. Xlwings] Excel and Python meet. EXCEL] SHORTCUT KEYS: CTRL ENTER.
financeforexcel.com
FinanceForExcel.com by Geoff Noble: [DATED-IF] A 2-minute tip: find the years between two dates
http://www.financeforexcel.com/2014/04/dated-if-2-minute-tip-find-years.html
Finance and Excel by Geoff Noble. Find us on YouTube. Wednesday, April 23, 2014. DATED-IF] A 2-minute tip: find the years between two dates. A friend highlighted a pretty neat function called DATEDIF today (Thanks, Craig). To be honest, I didn't even know this function existed. DATEDIF if basically finds the difference between two dates. For example, if you wanted to find someone's age you would look at the person's date of birth and the date today. DATEIF could give you the answer in years.
financeforexcel.com
FinanceForExcel.com by Geoff Noble: [Excel Data] 7 Steps to complete a Sensitivity Analysis using Data Tables
http://www.financeforexcel.com/2012/11/sensitivity-analysis-using-data-tables.html
Finance and Excel by Geoff Noble. Find us on YouTube. Thursday, February 7, 2013. Excel Data] 7 Steps to complete a Sensitivity Analysis using Data Tables. Data tables are a powerful tool for scenario analysis. They show the impact of changing up to two underlying assumptions (e.g. the discount rate) on a calculated value (e.g. a NPV). A data table can be created using the following steps:. Create a blank table as per first image below. Select the whole range of your table as per below. Quick Excel Video...
financeforexcel.com
FinanceForExcel.com by Geoff Noble: [MS EXCEL] TIME: Convert decimal number to hours and minutes
http://www.financeforexcel.com/2012/11/time-convert-decimal-number-to-hours.html
Finance and Excel by Geoff Noble. Find us on YouTube. Sunday, March 24, 2013. MS EXCEL] TIME: Convert decimal number to hours and minutes. I was helping a mate the other day calculate the number of hours a task took to complete. He was able to calculate numbers such as 0.8 hours and 1.6 hours to complete the task. What he wanted was a spilt between the hours and minutes. For example 2.7 hours equates to 2 hours 42 minutes. How do we do this? We can setup a spreadsheet as follows:. We can use the TIME.
financeforexcel.com
FinanceForExcel.com by Geoff Noble: March 2013
http://www.financeforexcel.com/2013_03_01_archive.html
Finance and Excel by Geoff Noble. Find us on YouTube. Sunday, March 24, 2013. MS EXCEL] TIME: Convert decimal number to hours and minutes. I was helping a mate the other day calculate the number of hours a task took to complete. He was able to calculate numbers such as 0.8 hours and 1.6 hours to complete the task. What he wanted was a spilt between the hours and minutes. For example 2.7 hours equates to 2 hours 42 minutes. How do we do this? We can setup a spreadsheet as follows:. Friday, March 15, 2013.
financeforexcel.com
FinanceForExcel.com by Geoff Noble: January 2013
http://www.financeforexcel.com/2013_01_01_archive.html
Finance and Excel by Geoff Noble. Find us on YouTube. Thursday, January 31, 2013. Excel]: Cool Conditional Formatting. Conditional formatting has also been revamped in Excel 2007. It allows you to change the format of a cell(s) if a particular condition has been met. The condition can be the result of the cell(s) in which you want to use conditional formatting or it can refer to another cell on the same worksheet. Read until the end to see a cool implementation of it! TEXT(value, format text). Use Goal s...
financeforexcel.com
FinanceForExcel.com by Geoff Noble: October 2014
http://www.financeforexcel.com/2014_10_01_archive.html
Finance and Excel by Geoff Noble. Find us on YouTube. Wednesday, October 29, 2014. Calculation in Excel] How, what, where? Calculation speed is very important when constructing excel spreadsheets. By how exactly do we ensure that our spreadsheets calculate as fast as possible? One way is the understand exactly when Excel recalculates. Examples are:. Entering new data (if Excel is in Automatic recalculation mode, described later in this topic). Deleting or inserting a row or column. Want to know more?
SOCIAL ENGAGEMENT