Design News

Prime 5 Content material Administration Techniques for Freelancers

Whether you are a freelance blogger, photographer or web designer, choosing the right content management system (CMS) for your freelancing business can be tricky. As a freelancer, you need…

The post Top 5 Content Management Systems for Freelancers appeared first on Onextrapixel.

Continue Reading

The Excessive 5: new discoveries in area and style

space2

What did Saturn say to NASA this week? “High Five.” Here’s a look at a few of the top trending Google searches orbiting the week of April 24.

What have you done this week?

For the first time ever, a spacecraft cruised through the narrow gap between Saturn and its rings. Now NASA’s Cassini is beaming information back to the mothership, and telling NASA about all the cool stuff it saw. Science, FTW! After the feat, people searched on Google for more information: “How does Cassini communicate with Earth?” and “How long did it take for Cassini to reach Saturn?” Some were looking for a refresher astronomy course, asking “How far is Saturn from Earth?” and “How many rings does Saturn have?”

Here comes the tour

Maybe we’re amazed that Paul McCartney is still touring—that guy is Here, There and Everywhere! It’ll be a Hard Day’s Night on the road, but fans twisted and shouted when he announced his 2017 tour dates this week. Though you can’t buy his love, you can buy a ticket to his show. And fans are itching to get those tickets, with questions like “How much are Paul McCartney tickets?” and “When do tickets for Paul McCartney go on sale?” Let it Be soon.

Centi-versary

This Saturday marks President Trump’s 100th day in office, and the first few months of his administration have prompted people to learn more about political concepts and processes. The five most-searched terms related to politics during Trump’s first 100 days are “recuse,” “filibuster,” “vetting,” “executive order” and “immigrant.” Another fun fact to bring to your political debates this weekend: the most-searched names alongside the phrase “Trump handshake”: Justin Trudeau, Angela Merkel, Neil Gorsuch, Shinzo Abe and Benjamin Netanyahu.

Clear as mud

Remember when you were a kid and tracking mud in

Continue Reading

Your twirling, dancing, arts-appreciating Google Assistant

dance

Ok Google, when is International Dance Day?

It’s tomorrow! So grab your dancing shoes—the Google Assistant is your new partner. Here’s how it can help you get in the spirit of International Dance Day:

  • Practice makes perfect! Ask your Assistant on Android phones to “show me a video of a fouetté.”
  • Those who can’t dance can become dance history buffs. Ask your Assistant on Google Home “who was the founder of ballet?”
  • If you’re looking to learn new dance moves—ask your Assistant on Android phones “how do you do the Nae Nae?”
  • Get in the spirit with the right music—ask your Assistant on Google Home to “play some samba.”
  • Dust off your history books and ask your Assistant in Google Allo “when was the Lindy Hop popular?”
  • Or answer that burning question you’ve always been wondering about—ask your Assistant “can you dance?” (who wouldn’t want to be a part of the world’s longest conga line?)

Whether you want to hone your dancing skills with some practice or leave it to the experts by watching a video, your Google Assistant can help. We’ll see you on the dance floor.

Continue Reading

The Excessive 5: new discoveries in area and trend

space2

What did Saturn say to NASA this week? “High Five.” Here’s a look at a few of the top trending Google searches orbiting the week of April 24.

What have you done this week?

For the first time ever, a spacecraft cruised through the narrow gap between Saturn and its rings. Now NASA’s Cassini is beaming information back to the mothership, and telling NASA about all the cool stuff it saw. Science, FTW! After the feat, people searched on Google for more information: “How does Cassini communicate with Earth?” and “How long did it take for Cassini to reach Saturn?” Some were looking for a refresher astronomy course, asking “How far is Saturn from Earth?” and “How many rings does Saturn have?”

Here comes the tour

Maybe we’re amazed that Paul McCartney is still touring—that guy is Here, There and Everywhere! It’ll be a Hard Day’s Night on the road, but fans twisted and shouted when he announced his 2017 tour dates this week. Though you can’t buy his love, you can buy a ticket to his show. And fans are itching to get those tickets, with questions like “How much are Paul McCartney tickets?” and “When do tickets for Paul McCartney go on sale?” Let it Be soon.

Centi-versary

This Saturday marks President Trump’s 100th day in office, and the first few months of his administration have prompted people to learn more about political concepts and processes. The five most-searched terms related to politics during Trump’s first 100 days are “recuse,” “filibuster,” “vetting,” “executive order” and “immigrant.” Another fun fact to bring to your political debates this weekend: the most-searched names alongside the phrase “Trump handshake”: Justin Trudeau, Angela Merkel, Neil Gorsuch, Shinzo Abe and Benjamin Netanyahu.

Clear as mud

Remember when you were a kid and tracking mud in

Continue Reading

How To Make Use of 5 Superior Excel Pivot Desk Methods

PivotTable to Summarize

The problem we all face isn’t a lack of data; instead, it’s finding meaning in huge amounts of data! That’s why I advocate for the use of PivotTables, an amazing feature in Excel to summarize and analyze your data.

Seeing the power of PivotTables is as simple as comparing the original data to the PivotTable version; with just a few clicks I was able to see the average item price by state.

As a finance professional, I’m genetically inclined to love spreadsheets. But I also find that I use spreadsheets to organize my creative and freelance work. No matter what you use spreadsheets for, a PivotTable can help you find greater meaning in the data.

In this tutorial, we’ll build upon on our starter tutorials on using PivotTables to work better with your data. I’ll show you five of my favorite advanced PivotTable techniques.

Throughout this tutorial, I’ll use sample data provided by Microsoft on this page. Use this data to recreate the examples or test the features I’m showcasing.

How to Use Advanced Pivot Table Techniques in Excel (Quick Video)

I love teaching with screencasts, which give you a chance to watch me use the features step-by-step. Check out the quick video below which cover five of my favorite advanced Excel PivotTable features:

5 Advanced Excel Pivot Table Techniques

Keep reading for a walkthrough of how to use each of these five features in the written tutorial below, covering: Slicers, Timelines, Tabular View, Calculated Fields, and Recommended PivotTables. Let’s get into it.

1. Slicers

Slicers are point and click tools to refine the data included in your Excel PivotTable. Insert a slicer, and you can easily change the data that’s included in your PivotTable.

Slicer Example in Excel PivotTable
In this example, I’ve inserted a slicer for the Item type. After

Continue Reading