By Mike Wong | Thursday, September 24, 2015
There are times when a full-fledged chart in Excel is overkill and you just want to create a quick visual representation of your data.
For those times, here are three in-cell alternatives for using charts in Excel.
By Mike Wong | Saturday, September 19, 2015
There are thousands of Excel tips out there—many of which you’ll rarely need to use.
But you can use these five little-known tips every day to make the time you spend in Excel more efficient and productive.
By Starshine Roshell | Friday, May 15, 2015
Lauren Kleist spent 11 years working in credit and collections for a Pittsburgh utility company.
“I’ve been trying to get out of the call center forever. Everybody wants out of the call center,” she says. “The noise—sometimes you go home and have such a headache.”
Then a job opened up in billing. Nice, quiet billing. But in order to get the job, she would have to pass an Excel test.
“I’m an artistic, creative person, so I let Excel get the best of me. I just couldn’t wrap my mind around it.”
But she really wanted this job, and that meant building an Excel spreadsheet in a timed exam—and scoring a 70% or better.
“I looked on YouTube for a couple of videos, but it didn’t help me,” she says. “I thought, This job is mine if I pass the test …”
By Starshine Roshell | Sunday, May 10, 2015
Paulette Perhach can do a lot of things that most people can’t.
She can carry four full dinner plates at a time. She can gallop on a horse. She can split names into two columns in Excel, craft subplots in a fictional story, and do the dance from Lady Gaga’s “Bad Romance” video. She can make quail traps, tie fancy bows on presents, and produce podcasts.
And she learned it all online.
Just how did she come to acquire this eclectic set of skills? And well … why?
Having graduated college only to realize that she possessed very few useful life skills, Paulette took to the Internet to fill in the sizeable gaps.
“Before I really took control of my own education, I felt like life was always coming at me: another late bill, another bounced check, another photo from a place I wished I could travel to,” says the Seattle resident. “So I started making it a practice to educate myself for 10 minutes a day.
“And life started getting better …”
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 3, 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:
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.