Learn it fast with expert-taught software and skills training at lynda.com. See what you can learn

By Curt Frye | Thursday, June 26, 2014

Getting Started with Excel VBA

excel-cells-in-repose

Excel is a powerful and versatile tool you can use to analyze data—but not every capability you might want is built in.

Using the Visual Basic for Applications (VBA) language, you can script custom processes in Excel. VBA is an object-oriented language, which means that elements of Excel—such as workbooks, worksheets, and the program itself—are represented as objects. An object has three main components:

  • properties, which describe the object
  • methods, which are things the object can do
  • events, which are occurrences the object can recognize and react to

By Scott Fegette | Wednesday, January 15, 2014

Excel’s VLOOKUP and HLOOKUP functions explained

Understanding HLOOKUP and VLOOKUP

Explore this course at lynda.com.

When looking up information in Microsoft Excel, you’ll regularly need to compare data against a table—and tables can be found in a variety of locations and formats. For example, in the image above you may need to find the appropriate tax rate in the table on the right for a given employee’s salary listed in the table on the left.

On the Formulas tab in the Excel ribbon, you’ll see a categories function called Look up and Reference. The two key functions for this type of task are VLOOKUP (V meaning vertical) and its companion function HLOOKUP (H meaning horizontal).

Why two functions instead of one? As shown in the image below, data tables can be found in horizontal and vertical orientations—so with two dedicated functions, you’re covered either way.

By lynda.com | Friday, January 10, 2014

5 must-know Excel tips

Boost your spreadsheet know-how in minutes with these easy Microsoft Excel tips from expert lynda.com instructors.

1. Learn how to keep the content of your cells within the boundaries of your design.

Watch more…

By Jess Stratton | Monday, January 06, 2014

Migrate data with ease using Excel spreadsheets: Monday Productivity Pointers

Matching header rows in your spreadsheets

Explore Monday Productivity Pointers at lynda.com.

Welcome to this week’s edition of Monday Productivity Pointers! This week I’m covering a great skill to know: how to migrate data between two apps with minimal headaches, by using an Excel spreadsheet. Hint: It’s all about the header column labels.

In the first video, I’ll show you how to make sure you’re correctly matching up the header row of column labels on your Excel spreadsheet for a smooth data import. And just in case you don’t know the column labels in the app you’ll be importing your data into, I’ll show you a great trick for finding out.

By Crystal McCullough | Sunday, December 27, 2009

Office 2010 Beta Preview offers a taste of enhancements and new features

In Office 2010 Beta Preview, David Rivers offers a taste of the enhancements and new features in Microsoft Office 2010. He explores the improved Ribbon, which is now customizable in each application in the suite. In Word, he discusses the expanded search function, in-document image editing, and the introduction of OpenType fonts.

David shows off the expanded filters and conditional formatting in Excel, and the ability to add screenshots and animation in PowerPoint. Access now includes the ability to create pre-built database modules, and David shows how to integrate and re-use these assets in an example database. Last but not least, he reviews the enhancements to Outlook and OneNote, which can link notes to all the applications in the suite. View the full course and let us know what you think.

By Megan O. Read | Friday, November 20, 2009

lynda.com author (that Excel guy) Curt Frye teaches critical financial skills

When Curt Frye started working with lynda.com, we were all very excited about the slew of new and much needed Microsoft Excel courses he was planning for us. With the state of the economy, and more people doing their own finances, as well as tightening their belts nearly to the point of of asphyxiation, it is becoming more critical for the general public to understand their finances, even on a very basic level.

In the November 2009 issue of the Harvard Business Review, The Forethought column “Teach Workers About the Perils of Debt.” states:

“It’s widely known that many consumers have poor numeracy–they can’t figure out percentages or do other elementary calculations–and have barely a rudimentary grasp of economics. In our research, we looked deeper, studying consumers’ ‘debt literacy,’ the ability to understand how interest rates work and make simple decisions about borrowing. We found it to be strikingly low.”

With the state of the economy, and more people doing their own finances, as well as tightening their belts nearly to the point of of asphyxiation, it is becoming more an more critical for the general public to understand their finances, even on a very basic level. <em>Photo courtesy of iStockphoto, image #3154423</em>

Curt's aim in creating a course on financial analysis was to teach skills required to analyze debt. Photo courtesy of iStockphoto, image #3154423

“My aim in creating Excel 2007: Financial Analysis was to teach the skills required to analyze debt,” said Curt Frye of his first lynda.com course. “I’m hoping that it helps subscribers better understand some critical skills that not everyone is taught at home or in school.”

Curt is currently working on a new book, as well as new lynda.com courses. For a full list of his training, visit his author page.

Get the latest news

  •   New course releases
  •   Pro tips and tricks
  •   News and updates
  
New releases submit clicked

You can change your email preferences at any time. We will never sell your email. More info

Featured articles

A lynda.com membership includes:

Unlimited access to thousands of courses in our library
Certificates of completion
New courses added every week (almost every day!)
Course history to track your progress
Downloadable practice files
Playlists and bookmarks to organize your learning
Become a member

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.