Articles from June 2012
Posted by Darren Hall on June 13, 2012
This simple technique for showing negative numbers in red in Excel will assist you in making your reports and Excel dashboards stand-out more…. Showing negative numbers in Red in Excel In general, unless your client or boss prefer differently, it tends to be standard practice to show negative numbers in red in Excel reports [...]
Categories: Dashboards & Charts
| 
Tags: Display Excel negative numbers in red, Showing negative numbers in red in Excel
| 
No comments
Posted by Darren Hall on June 12, 2012
A personal workbook in Excel 2010 can be a really useful way to save some extra time – especially when working on projects that use Excel templates, or if you are one of those Excel analysts (like myself) who like customise the look of your Excel spreadsheet. Personal workbooks in Excel 2010 are easy to [...]
Categories: Time Saving Techniques
| Tags: personal macro workbook excel 2010, personal workbook excel 2010, XLSTART folder location
| No comments
Posted by Darren Hall on June 7, 2012
One of the more common problems with Excel automation using VBA is that the warning messages in Excel, which are normally helpful, can halt our scripts mid-flow. Learn how to stop that problem and achieve full Excel automation using VBA… The problem Excel tries to be helpful to the user and will inform you when [...]
Categories: Automation, Excel VBA
| Tags: Excel Automation using VBA, Turn off displayalerts in excel, Visual basic excel automation
| 1 comment
Posted by Darren Hall on June 6, 2012
Assign a macro to a button in Excel 2010 in these simple, easy-to-follow steps and stop those non-technical users asking questions… The Macro A Macro is a series of commands either recorded, or manually written using the VBA Editor in Excel. Macros are common place in advanced Excel reports and dashboards – from [...]
Categories: Excel VBA
| Tags: assign macro to button, excel assign macro to button
| No comments
Posted by Darren Hall on June 2, 2012
Importing a text file into Excel 2010 is easy when you know how. Take 5 minutes to read this short guide on how to import text files into Excel 2010 and learn how… Text Files Text files have the common file type of .txt and can be opened directly, usually from within the [...]
Categories: Dashboards & Charts
| Tags: import text data into excel, import text file into Excel, insert text file into excel
| No comments
Posted by Darren Hall on June 1, 2012
When leading spaces, or blank characters, make their way into a dataset they can cause havoc on your Excel lookups and cause some very misleading reports. Learn how to remove the leading spaces from the Excel cells and how to take preventative measures to ensure your reports remain accurate… What are leading spaces [...]
Categories: Formula and Functions
| Tags: excel leading blanks, excel remove leading spaces, excel remove spaces from text, excel TRIM function
| 2 comments
Follow Us!