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 Scott Fegette | Monday, January 26, 2015
Starting today, you can download the course notes that you’ve saved at lynda.com!
Since last year, our members have been able to take notes on their courses—but until now they were only handy while you were logged into your lynda.com account online.
Now you can export any note you’ve taken to three different file formats, and two popular cloud services.
By Suzanna Kaye | Monday, January 26, 2015
How many free address labels and calendars do you really need?
Nonprofit organizations are one of the prime contributors to the piles of junk mail we get at home every day. And although you may want to support a particular charity and its mission, most of us do not need the constant donation requests in our mailboxes.
In my free video tutorial Stopping unwanted junk mail, I offer lots of tips for reducing the amount of mail you have to sift through and recycle each day.
Here’s how to stop junk mail from charities, specifically:
By Steve Simon | Sunday, January 25, 2015
I’m a street photographer. What I most love about my profession is that it allows me to shoot anytime, anywhere. From big-city streets to rural dirt roads, there are great images waiting to be found at every turn. I liken it to a treasure hunt; the treasures are everywhere if we choose to see them.
Since triggering the shutter at the right moment is so important to the success of my work, I tend to put the odds in my favor by shooting more. The more I shoot, the “luckier” I get; it can mean the difference between capturing an average picture or a five-star masterpiece.
But shooting is only half the battle. The secret to success is in the editing.
How do you choose “the best” of the many images you’ve captured?
By Richard Harrington | Saturday, January 24, 2015
Moving time-lapses are a fun way to record a long duration of time and compress it into several seconds. And it’s easy to spend a lot of money on equipment to get the movement you want in your shots.
This week on Video Gear Weekly, I provide some affordable options that allow you to get the most bang for your buck when shooting a moving GoPro time lapse.
By John Derry | Saturday, January 24, 2015
The digitally driven confluence of art, photography, and ink-jet technology has resulted in an explosion of artworks on paper.
In many respects, the fine-art ink-jet print is the 21st century equivalent of a hand-produced stone lithograph. Using digital tools, photographers and artists can now create archival-quality prints for sale.
One tradition of the hand-made fine-art print is the deckled edge. Once considered an imperfection as the byproduct of the hand-made paper-making process, this feathery, unfinished edge now makes an archival ink-jet print appear even more valuable.
Here’s how to add deckled edges to your prints.
By Todd Dewett | Friday, January 23, 2015
One of the most difficult parts of any career is working for someone you don’t like.
Your boss might have impossible standards, play favorites, or be relentlessly negative. In some cases, bosses can be flat-out discriminatory or abusive.
Most people feel they have little to no power to remedy these situations. But they’re wrong. I’m going to give you some tips on how to deal with a difficult boss.
By David Blatner | Thursday, January 22, 2015
Need to alphabetize a list or sort it numerically?
You won’t find the feature in any menus, but you can sort text in InDesign with the script I introduce in this week’s episode of InDesign Secrets.
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.