Archive for Excel

Excel crashing at Startup – looking for external links

Here’s another Excel tip. Just helped a client resolve a situation and thought it would make a good Blog article.  This client had links to external references that were not resolving and Excel would immediately crash and close whenever they tried to open the spreadsheet in question.  Needless to say they were freaking out.  Here’s […]

Matching data in 2 cells in Excel

Today’s quick blog article will talk about a favorite formula string I use time and time again.  If you read my blog, you know I use Excel as my tool of choice for data manipulation. My challenge today was to find and match emails in two columns.  What I wanted to do was weed out […]

Kicking up Business Intelligence Data in ACT!

Starting with ACT version 2012, you can now create some informative Excel pivot tables using what is called a Star schema.  The data goes after histories and opportunities. Two tables are created.  It’s a bit complicated to set up, but once done you can start to do some sophisticated drill downs in Excel to show […]

Using SQL commands in Excel – Drilling down into ACT data

Today’s blog is about using SQL commands directly in Excel.  I am going after data in Sage ACT, but you can use the same technique to go after a wide variety of data sources that are SQL based. First off, open Excel.  I am showing you screen shots from Excel 2010.  You want to click […]