Articles from April 2012
Posted by Darren Hall on April 28, 2012
Data can arrive to use in many formats and one of those is where the records are by column, not by the traditional row format. Learn how to convert data from column to rows in Excel 2010… Records by column When records are stored by column the Excel file will look something like [...]
Categories: Time Saving Techniques
| 
Tags: Convert columns to rows in Excel 2010, Convert Excel records from columns to rows, Transpose data in Excel 2010
| 
No comments
Posted by Darren Hall on April 27, 2012
Learn how to create a descriptive name to refer to a range of cells on an Excel worksheet with this guide for Excel 2010 users… What is a Named Range? A Named Range refers to creating a descriptive name to refer to a range of cells, by doing so the descriptive name can [...]
Categories: Automation
| Tags: Dynamic Range Excel 2010, Name a range of cells in Excel 2010, Named Ranges in Excel 2010
| No comments
Posted by Darren Hall on April 26, 2012
Calculating the number of working days between 2 dates in Excel 2010 is a breeze when you know how, learn how with this guide… Dates In a previous post we covered calculating the difference in days between two dates in Excel 2010 and now it’s time to look at a slightly different calculation, [...]
Categories: Formula and Functions
| Tags: Calculate number of working days in Excel 2010, Networkdays Excel 2010
| No comments
Posted by Darren Hall on April 25, 2012
Do you have an Excel dashboard or Excel report showing 1,560,472 in the total rather than 1.56M? Get shot of those poorly formatted values, save some vital Excel dashboard space, and help your users understand the true meanings of your dashboard by learning custom formats… Overview A common question I get asked is how to [...]
Categories: Dashboards & Charts
| Tags: Dashboard Number formats in Excel, Excel Change Number to M, Excel Convert Number to Millions, Excel Millions M Format
| No comments
Posted by Darren Hall on April 20, 2012
This guide will show you how to insert a header and footer in Excel 2010 files. It’s a simple trick to learn so read on and you will be able to insert a header and footer in Excel 2010 in no time at all… What are Header’s and Footer’s? It’s worth explaining the [...]
Categories: Dashboards & Charts
| Tags: Header Footer Excel 2010, Insert Company Logo in Excel 2010
| No comments
Posted by Darren Hall on April 19, 2012
Hyperlinks are a useful tool to understand in Excel 2010, particularly in large reporting suites or Excel dashboards where they can be used as an effective navigation tool, find out how to make the most of hyperlinks in Excel 2010… What is a Hyperlink A hyperlink takes the user directly to another piece [...]
Categories: Automation, Dashboards & Charts
| Tags: Dashboard in Excel 2010, Excel 2010 Dashboard Help, Excel 2010 Hyperlinks, How to link documents in Excel, How to use hyperlinks in Excel, Hyperlinks in Excel 2010, What is an Excel hyperlink
| No comments
Posted by Darren Hall on April 17, 2012
Learn how to fix cells that show #VALUE after calculation. This guide explains why the #VALUE error occurs and will teach you how to prevent it occurring on your reports… What causes the #VALUE Error The #VALUE error will appear as the result of a calculation within your Excel file, the cause is [...]
Categories: Formula and Functions
| Tags: Excel #VALUE Error fix, Excel Fix Cell, Excel remove #Value Error, What does #Value mean in Excel
| No comments
Posted by Darren Hall on April 16, 2012
Macros, whether recorded or written using VBA, are an increasing part of the Excel analysts toolkit. A useful trick to learn is to make your macros or scripts run automatically when the Excel file opens. Read on to find out how… Situations There are lots of times where having a macro run automatically [...]
Categories: Excel VBA
| Tags: Automatically run macros in Excel, Auto_Open() Excel, Excel Guides, Excel How To, Excel Pop-up User Message, Make Excel macros run when file is opened
| No comments
Posted by Darren Hall on April 13, 2012
If you have ever been faced with text fields that contain poor formatting or capitalisation then you will find this guide on how to convert text fields to different cases a useful read… Convert text case with Excel 2010 Data comes in many formats, sometimes the correct format; other times a seemingly random [...]
Categories: Formula and Functions
| Tags: Convert lowercase to Capitals in Excel, Excel Capitals, Excel Format Text Field, Excel Lowercase, Excel Proper Case, Excel Text Format Error
| No comments
Posted by Darren Hall on April 12, 2012
When writing VBA for automating report production the ability to copy and paste data from one worksheet to another is a valuable tool. Learn how to do this with this how-to guide…. First Steps The first thing you need to decide is what range of data you wish to copy and from which [...]
Categories: Excel VBA
| Tags: Excel 2010 VBA Copy Data, Excel 2010 VBA Cut Data, Excel 2010 VBA Paste Data to Worksheet, How to copy data to another worksheet with VBA Excel
| No comments
Follow Us!