Archive by Author
10 Excel Formulas and Functions Students and Interns Should Know In Excel
Posted on 23. Mar, 2012 by admin.
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
Continue Reading
Freezing Panes in Excel
Posted on 19. Mar, 2012 by admin.
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
Continue Reading
Pivot Tables and Pivot Charts
Posted on 12. Mar, 2012 by admin.
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
Continue Reading
The VLOOKUP Formula
Posted on 10. Mar, 2012 by admin.
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
Continue Reading
A little intro..What do you want to learn?
Posted on 09. Mar, 2012 by admin.
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
Continue Reading
What Every Intern Must Know in Excel
Posted on 03. Mar, 2012 by admin.
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
Continue Reading
What is VBA?
Posted on 03. Mar, 2012 by admin.
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
Continue Reading
Why It Is Important to Know Microsoft Excel
Posted on 03. Mar, 2012 by admin.
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 [...]
