By Starshine Roshell | Sunday, January 4, 2015
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
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
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
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
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 1, 2014
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
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:
By Jolie Miller | Thursday, March 27, 2014
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.
You can change your email preferences at any time. We will never sell your email. More info
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:
Keep up with news, tips, and latest courses with emails from lynda.com.
We've updated our terms and conditions (now called terms of service).Go Review and accept our updated terms of service.