andrewexcel.blogspot.com
Andrew's Excel Tips: 04/17/15
http://andrewexcel.blogspot.com/2015_04_17_archive.html
Making Excel do the work for you. Friday, 17 April 2015. AET Data Checker v1.1. A while back I promised a new version of my AET Data Checker addin. and I just uploaded it! 1 Dropdown lists to select columns. This enables you to use your keyboard arrow keys to scroll across columns without having to type them in like before. The benefit is that you can just "scroll" across columns and watch the values change. 2 You can show percentages, including to the number of decimal places you like. See you next time.
andrewexcel.blogspot.com
Andrew's Excel Tips: 12/03/14
http://andrewexcel.blogspot.com/2014_12_03_archive.html
Making Excel do the work for you. Wednesday, 3 December 2014. Excel 2013 and the Ribbon. I've recently started using Excel 2013, and soon noticed the Ribbon doesn't act the same way as it did with Excel 2007 and Excel 2010. Addins that add menu items to "what used to be" (still is) the Top Menu (Menu Commands on the Add-Ins tab) and toolbars (Custom Toolbars also on the Add-Ins tab) are affected. After a quick look on the Internet, I found this. Well now, that changes things a bit. If you have already do...
andrewexcel.blogspot.com
Andrew's Excel Tips: 10/30/14
http://andrewexcel.blogspot.com/2014_10_30_archive.html
Making Excel do the work for you. Thursday, 30 October 2014. If you work with data from various sources, it's possible you will come across numbers formatted as Text. Depending on what you plan to do with these numbers, it's possible that the Text formatting will cause problems. For example, let's see how many "numbers" there are in the picture below. Look at the formula I've entered in cell B1. Let's set things right. Select Text from the Number tab, then click OK. Treat yourself to a well-earned cup of...
andrewexcel.blogspot.com
Andrew's Excel Tips: 11/21/14
http://andrewexcel.blogspot.com/2014_11_21_archive.html
Making Excel do the work for you. Friday, 21 November 2014. In 2004 I met someone who would change my life and give me inspiration to start blogging. That person was my friend and mentor, Masaru Kaji, more commonly known in Excel circles as Colo, of Colo's Junk Room fame. Please welcome him back. You can find his new site here. Links to this post. Subscribe to: Posts (Atom). Subscribe in a reader. For any enquiries, please contact. Me at the email address below. Code for Excel and Outlook.
andrewexcel.blogspot.com
Andrew's Excel Tips: 04/03/15
http://andrewexcel.blogspot.com/2015_04_03_archive.html
Making Excel do the work for you. Friday, 3 April 2015. AET Excel Utilities, Uploaded (Finally! Dick Kusleika from the Daily Dose of Excel. Site has very kindly allowed me to post about my AET Excel Utilities on his blog. That's right, they're finally uploaded, just waiting for you to try them out (for a small price! Read all about them here. Or go straight to the download page here. See you next time. Links to this post. Subscribe to: Posts (Atom). Subscribe in a reader. For any enquiries, please contact.
andrewexcel.blogspot.com
Andrew's Excel Tips: AET Excel Utilities, Coming Soon
http://andrewexcel.blogspot.com/2015/02/aet-excel-utilities-coming-soon.html
Making Excel do the work for you. Monday, 16 February 2015. AET Excel Utilities, Coming Soon. It's been a busy start to the new year for me. But things are winding down and I hope to start blogging again soon. In the meantime, I've uploaded the help files of my upcoming AET Excel Utilities so you can get a sneak peek. See you next time. Subscribe to: Post Comments (Atom). Subscribe in a reader. For any enquiries, please contact. Me at the email address below. Code for Excel and Outlook.
andrewexcel.blogspot.com
Andrew's Excel Tips: Excel Tips
http://andrewexcel.blogspot.com/p/excel-tips.html
Making Excel do the work for you. Dates, Time and Age. Colour Rows with Filter. Zeros in front of Numbers. Last of Month (EOMONTH). Cell Text To Comment. Add Comment With Text. Count and Add with Criteria. Count Characters in Single Cell. Count Characters in Range. Count Words in Single Cell. Count Words in Range. Auto Open (Unlocked Cells). Count Numbers in Range. Auto Open (Select Cell A1). Count Text in Range. Find Text in Range. Remove Numbers from Left. Remove Numbers from Right. Sum Every 3rd Row.
andrewexcel.blogspot.com
Andrew's Excel Tips: Downloads
http://andrewexcel.blogspot.com/p/downloads_12.html
Making Excel do the work for you. A comprehensive set of time-saving tools. Indent all VBA code in VBE modules or projects. Tools that make working with charts easier. An easy way to add your own Excel menus. Check your data conditionally on the fly. Simply edit all comments in VBE modules or projects. AET Find and Replace. Find and replace multiple fields at once. Work with high-visibility "Marlett" Checkboxes. View and edit off-screen data. Check Excel calculation when saving files. XL Help Files Maker.
andrewexcel.blogspot.com
Andrew's Excel Tips: 04/22/15
http://andrewexcel.blogspot.com/2015_04_22_archive.html
Making Excel do the work for you. Wednesday, 22 April 2015. Excel does not have a STDEVIF function. It's got other functions like COUNTIF(S), SUMIF(S) and AVERAGEIF(S), but is somewhat lacking when it comes to calculating conditional standard deviation. If you have a lot of data, that can be a problem. Using array formulas or a UDF can slow things down. So let's focus on what's important, why not just get the calculation results? Forget using functions or VBA, why not both? Dim sFunctionType As String.
andrewexcel.blogspot.com
Andrew's Excel Tips: 02/16/15
http://andrewexcel.blogspot.com/2015_02_16_archive.html
Making Excel do the work for you. Monday, 16 February 2015. AET Excel Utilities, Coming Soon. It's been a busy start to the new year for me. But things are winding down and I hope to start blogging again soon. In the meantime, I've uploaded the help files of my upcoming AET Excel Utilities so you can get a sneak peek. See you next time. Links to this post. Subscribe to: Posts (Atom). Subscribe in a reader. For any enquiries, please contact. Me at the email address below. Code for Excel and Outlook.