By Gini Courter | Tuesday, March 24, 2015
Here’s some great news for business users of Microsoft Office 2010 and 2013: You have all the tools you need to apply your company brand—its unique look and feel—to documents, presentations, even spreadsheets.
Office themes are designed to enforce your branding efforts whether you’re building robust templates that support your organization’s communications, launching a fresh identity for a departmental initiative, or creating an innovative personal brand.
Many of the Office branding features are global, so the branding work you do in one Office application (for example, Word) is automatically available for use in Excel and PowerPoint.
Here’s how you can use Office themes to communicate your organization’s identity:
By Adam Wilbert | Wednesday, February 11, 2015
The subscription model is here to stay, and that’s a good thing.
When you dig into the benefits of a subscription—and evaluate the actual costs of “buying” versus “renting” your Office software—you might be surprised at what the numbers tell you.
Here’s why I think an Office 365 subscription is an unbeatable deal.
By Curt Frye | Tuesday, February 03, 2015
Excel users are often faced with spreadsheets that summarize sales data for multiple areas, such as states within the U.S. or individual countries.
Functions such as SUM or AVERAGE let you summarize your data as a whole—but it can be difficult to find the totals, averages, or counts for subsets of that data. For example, suppose you want to find the total of all sales to Canada. To do that using a standard SUM formula, you would have to identify cells that contain values for all sales to Canada and then create a formula for just those cells.
Fortunately, there’s a set of conditional functions in Excel that let you specify which values should be included in a sum, average, or count calculation. Those functions are: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, and COUNTIFS.
Here’s how to take advantage of them:
By Curt Frye | Tuesday, January 27, 2015
Excel workbooks let you summarize your data using a powerful set of built-in functions and features such as sorting and filtering.
That said, basic worksheets are static and make rearranging data difficult. Fortunately, there’s a way to avoid all that cutting and pasting: Pivot Tables.
You can learn everything you’d ever want to know from my lynda.com courses Excel 2007: PivotTables for Data Analysis, Excel 2010: PivotTables in Depth, and Excel 2013: PivotTables in Depth.
But here’s a quick-start guide for you:
By Starshine Roshell | Sunday, January 04, 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.
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.