Month: August 2013

5 Excel Functions Every Young Professional Should Know

Salary Monkey


In my experience, a shocking number of business professionals have very little fluency in Excel. Many are intimidated by it or don’t perceive it worthy of the time it takes to learn the basic productivity-boosting functions that Excel offers. Instead, they choose to slog through the data, or shoot it to some poor underling to do for them.

For the entry level candidate, making yourself the resident Excel expert presents an opportunity for visibility and advancement. If your office is like those I’ve worked in, the resident Excel expert gets a huge amount of cache simply for spending a few minutes working your “magic” on a given data set to make it more easily usable by your office mates. Even executives will know your name and seek you out.

The idea of the Electronic Spreadsheet or “interactive visible calculator” dates back to 1979 with the introduction of a software program…

View original post 1,087 more words

Arrays vs Collections vs Dictionary Objects (and Dictionary help)

Newton Excel Bach, not (just) an Excel Blog

A recent comment by Lori Miller at Daily Dose of Excel suggested that (for the particular application being discussed) the VBA Collection object was quicker than using scripting dictionaries.  Since I hardly ever use collections (other than the built-in ones), and recently I have made quite extensive use of dictionaries I thought I would investigate further. In the process I found a comprehensive article on the scripting dictionary, which I recommend to Microsoft to see how to write truly helpful help articles:

Using the Dictionary Class in VBA

Commenting on the differences between dictionaries and collections, this article says:

For relatively simple needs, such as identifying only the distinct items in a list, there is no advantage to using a Dictionary from a feature functionality perspective.  However, if you must:

  • Retrieve keys as well as the items associated with those keys;
  • Handle case-sensitive keys; and/or
  • Be able to accommodate changes…

View original post 301 more words

Import Excel Data into MySQL

Development Stuff

This very helpful little guide shows how to export your excel data into a csv file and then import them to MySQL using a command. I’ve used it many times in the past and I keep it handy in my bookmarks.

Read the full guide here: Import Excel Data into MySQL in 5 Easy Steps

View original post

Import Data from Excel Sheet into Sitecore

ishraq al fataftah

I managed to work recently on many sites that required importing Data into Sitecore from an Excel Sheet. These Data might be from Sharepoint, xml, Migrated data, actually any kind of data that you managed to store in Excel and need to import into Sitecore.

Below, a number of code snippets that allows you to do so by using CSharpJExcel.Jxl library to read Excel sheets.

Create a method to that takes the destination path (where the new Item would be stored in Sitecore tree), Item name and the template ID from which the new Item would be created.

Once the Sitecore item is created, you can loop through all the item fields to update the Sitecore Item field with the new value. This method takes a Sitecore item, Sitecore field and the new value to update the field.

The last step would be to read the Excel sheet, loop through…

View original post 117 more words

Part 2 – Power Query API – Parameterized Data Indeed!


This the second part in the Indeed! Series and we will cover how to parameterize a query in Power Query. In part 1 we setup our Indeed API calls to gather some basic data with Power Query. The file from Part 1 can be downloaded here. This probably didn’t help a whole lot of people out unfortunately; unless you are a software engineer in Austin, TX. Hopefully you have had a chance to go over to Faisal Mohamood’s blog and read up on parameterizing a Yelp query or for a crazy parameterization in Power Query you can check out Devin Knight’s blog post.

View original post 752 more words