Learn it fast with expert-taught software and skills training at lynda.com. Start your free trial

By Starshine Roshell | Sunday, January 04, 2015

Fitness Resolution for 2015? Learn While You Burn!

fitness resolution

It’s a fact. New year’s resolutions fall into two categories: want to and have to.

We want to do fun things like create stuff, tackle projects, pursue our interests, and master new toys. But we have to make time for the basics—like exercise.

The clever lynda.com fans you’re about to meet have all found a way to combine those two things: to check off the unavoidable have to of exercise while indulging in the gratifying want to of learning.

And some of them have even lost weight doing it.

By Starshine Roshell | Friday, December 26, 2014

He Helps Fight Hunger in Rwanda. And lynda.com Helps Him.


At a time of year when many of us are filling our homes and our bellies with an abundance of delicious treats, Jules Rugwiro is fighting hunger in Rwanda.

Jules is a database manager with the UN’s World Food Programme (WFP), the largest humanitarian agency that addresses hunger.

“The work that we do includes providing food and/or cash for refugees, responding to emergencies, feeding school children, and connecting farmers to markets,” says Jules, a Rwandan who lives and works in Kigali, the nation’s capitol. “I collect information on whether food is available and accessible, and how it’s utilized by people in different parts of the country. Once we have this information, we identify who the vulnerable people are (i.e. those who are ‘food insecure’), where they live, how insecure they are, and why they are insecure. WFP bases its interventions on these results.

“If my job is not done properly, the most vulnerable people would not be identified and thus not assisted.”

How does he make sure his job is done properly?

“I learned most of my programming and database management skills through self-study and the material available on lynda.com,” says Jules, who studied information technology in school.

By Curt Frye | Thursday, November 20, 2014

Set Up Worksheets Faster with Excel Flash Fill — and More

Excel Flash Fill and other tools make data entry easier

Setting up worksheets often means entering long strings of data, such as row numbers or dates, to create a framework for your data. This work can be repetitive and boring. What’s worse, it takes time away from analysis.

Let me show you how to make it go faster—with Excel Flash Fill, fill handle, and more.

By Curt Frye | Monday, October 13, 2014

Enhance Excel Lookup Using INDEX and MATCH


Business users of Microsoft Excel take advantage of many of the program’s built-in functions. One of the most popular tools is the VLOOKUP function, which lets you search an Excel worksheet as if it were a database table.

By Starshine Roshell | Tuesday, August 19, 2014

Work Faster and Easier in Microsoft Office — Weekly!


Over a billion people use Microsoft Office software: Word, Excel, PowerPoint, etc. That’s one in seven people—on the planet.

If you’re one of them, you need the essential time-saving tips in our new Weekly Office Workshop. (Or as we like to call it around here, “W.O.W.”)

By Jess Stratton | Friday, August 01, 2014

Microsoft Office for iPad: New Features!

Microsoft has just released the first major update for its Office for iPad suite of apps, including PowerPoint, Word, and Excel for iOS. Every update has been made in response to vocal user feedback in the first iterations of using the Office suite on a tablet, and we see some nice new features including gestures, print options, and presentation tools.

By Curt Frye | Thursday, June 26, 2014

Getting Started with Excel VBA


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 Jolie Miller | Thursday, March 27, 2014

Microsoft Office for iPad hits the App Store

Office for iPad First Look - now available

If you watched Microsoft’s San Francisco press event earlier today, you know there’s big news–the much anticipated Office for iPad applications are available for download in the App Store today as of 11 Pacific. Excel, PPT, and Word are all available individually and for free download. If you’re looking to just read Office documents from your iPad, you can use the apps for free, but editing rights will cost you an Office 365 subscription.

With the auto-save feature ensuring you won’t lose your work and the friendly ribbon interface and document editing abilities, you’ll see a lot of familiar features as you download each app. Plus, access your Camera Roll photos to add to docs or presentations, and get used to the 123 numerical keyboard in Excel. Get used to making your PowerPoint presentations on the iPad and then presenting them from it.

Downloaded the new Office for iPad apps and ready to dive in? Be sure to watch Jess Stratton’s free course Office for iPad First Look to get a head-start.

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
Start your free trial

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.