10 Excel Formulas and Functions Students and Interns Should Know In Excel

Posted on 23. Mar, 2012 by .

0

1. VLOOKUP The VLOOKUP is one of, if not, the most important formula in Excel. During the course of any internship or entry level job you’ll have to compare multiple lists of people, places, or things and match them up. A lot of people still sadly do this by manually comparing two or more lists […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

Freezing Panes in Excel

Posted on 19. Mar, 2012 by .

0

Freezing Pains is a great way to keep your menus in place as you scroll through your Excel worksheet. Typically in a sheet full of data you’ll have labels at either the top row of the column, the first column in a row, or both. It can be such a pain in the a** if […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

Pivot Tables and Pivot Charts

Posted on 12. Mar, 2012 by .

7

Download Example Excel Pivot Table Pivot Tables are a powerful way to show a ton of data in an easy to use table, where you can slice and dice data any way that you need. Pivot Charts are a great way to visualize the data that is shown in these pivot tables. To create a […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

The VLOOKUP Formula

Posted on 10. Mar, 2012 by .

2

Formula: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Download the VLOOKUP example The VLOOKUP is one of the most used formulas in Excel across all sorts of different industries. The “V” in VLOOKUP stands for vertical. It allows you to compare two lists. The formula looks for a value in the left most column of a worksheet of data and if […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

A little intro..What do you want to learn?

Posted on 09. Mar, 2012 by .

0

As you can tell this is a new blog and a new website. I’ve been working in Excel and VBA for the last 5 years and I’ve helped some very smart people learn stuff they never even thought possible inside Excel. I realized throughout my time in the professional world that most people who use […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

What Every Intern Must Know in Excel

Posted on 03. Mar, 2012 by .

1

What Every Intern MUST Know in Excel So, you’re looking for an internship or you just landed the internship of your life right? Well, that means you are going to be spending a lot of time with your old friend Excel. Here are the essential parts you should know: The Layout: As simple as this […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

What is VBA?

Posted on 03. Mar, 2012 by .

0

What is VBA? VBA stands for Visual Basic for Applications. VBA is an event-driven programming language that is proprietary to Microsoft and it is built into most Microsft Office applications including Excel, Word, Access, and Outlook. What Can It Do? VBA can allow you to do a lot of things. Anything that you do in […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading

Why It Is Important to Know Microsoft Excel

Posted on 03. Mar, 2012 by .

0

Microsoft Excel is used in almost every industry in one way, shape, or form. It is definitely used more heavily in the finance and other business related fields than it is in others, but I have seen it used in many different ways in other industries as well. Some Uses: Some people use Excel like […]

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Continue Reading