Welcome to My Blog

Building a (sub-$1000) Hackintosh that meets the Oculus Rift hardware requirements – Part II

In part I of our Hackintosh tutorial, we discussed our choice of hardware and the reasons behind those decisions. The main goal was to create a machine that had enough power to meet the Oculus Rift hardware requirements.

In this follow-up tutorial, we’ll show you the entire software install process needed for completing the build. Watch our 18+ minute step-by-step tutorial and witness this Hackintosh come to life. more…

Filed under:
How-To
Tagged: Clover, Elgato, EVGA, GeForce, Gigabyte, GTX 970, Hackintosh, how to, Intel Core i5, Mac OS X, mATX, MultiBeast, Oculus, Oculus Rift, OS X 10.11 El Capitan, Samsung EVO SSD, UniBeast

Apple launches Apple News Format for all, enabling publishers to deliver rich-media content in the News app

 

Screen Shot 2016-03-15 at 20.49.42

Apple is finally rolling out its Apple News Format to all publishers, after an initial announcement at WWDC 2015. The format lets anyone, big or small, create rich multimedia stories within the Apple News app, featuring panoramas, videos, animations and more.

Until today, Apple News Format was limited to exclusive launch partners (like Wired) whilst everyone else had to resort to basic RSS import. Publishers interested in using the format should check out the documentation on Apple’s website.

more…

Filed under: AAPL Company, iOS, iOS Devices, Tech Industry Tagged: apple news, apple news format, format, IAd, iOS, monetisation, News, publisher

Feature Request: How Apple could enhance Do Not Disturb and VIP to better control notifications

There’s a new display and brightness feature in iOS 9.3 called Night Shift which “automatically shifts the colors of your display to the warm end of the color spectrum after dark.” Apple even says that Night Shift “may help you get a better night’s sleep” which is mainly why I’ve been using (and enjoying) the feature during the iOS 9.3 betas. Who doesn’t want a better night’s sleep, right?

But Night Shift has me thinking about other ways iOS could be optimized to make our iPhones and iPads less distracting at night. The foundation for what I have in mind is already there: Do Not Disturb and VIP. But both of these features are currently short of where I’d like them to be to work best for me. Here’s what I’d love to see DND and VIP offer:

more…

Filed under: Feature Request Tagged: do not disturb, iOS, Night Shift, VIP

Music Tracker’s latest iOS update improves large music library scans on older devices

Music Tracker, an app that tracks your music library’s changes, received an update today that will make it process larger music libraries more efficiently. Ben Dodson outlines in his latest blog post that instead of needing to scan through an entire music library, it could handle the library in batches. Music Tracker keeps users aware of when music that had been added to their music library may have been removed by accident or because of music licensing deals expiring.

more…

Filed under: Apps, iOS Tagged: Apple Music, Ben Dodson, iOS, iTunes in the Cloud, iTunes Match, Music Tracker

7 Amazingly Effective Lead Nurturing Tactics

ThinkstockPhotos-179225452-938101-edited.jpgAs companies adopt inbound marketing as a way to generate more leads, the importance of having an effective lead nurturing strategy becomes very clear. In most cases only a relatively small percentage of your inbound leads will be ready to make an immediate purchase, leaving upwards of 90% of your inbound leads on the table.

Implementing an effective lead nurturing strategy can have a huge impact on the results of your inbound marketing strategy. Research conducted by Forrester has shown that marketers see an average 20% increase in sales opportunities from nurtured vs non-nurtured leads. Furthermore, the research also reveals that companies that excel at lead nurturing generate 50% more sales at a 33% lower cost (Source: Forrester, 2014).

Despite the clear benefits of lead nurturing, a study by MarketingSherpa indicates that only 36% of marketers actively nurture their sales leads (Source: 2013 Email Marketing Benchmark Report). Without question, this means that there’s a huge opportunity for savvy marketers like you to implement effective lead nurturing strategies and gain an advantage over your competition.

So you are probably wondering…

  • Which lead nurturing tactics work best? 
  • What do super successful marketers do differently?
  • Or how do I get started with lead nurturing?

Lead nurturing is of course just one component that goes into executing an inbound marketing strategy. If you’d like to learn what super successful inbound marketers are doing differently to attract traffic, convert leads and close customers you can check out this comprehensive resource – An Epic Guide to Creating an Inbound Marketing Strategy.

Now let’s get down to it – we’ve read through dozens of reports, dug into the most recent data about lead nurturing and compiled this list of the seven amazingly effective lead nurturing tactics. 

7 Amazingly Effective Lead Nurturing Tactics

1) Targeted content – Leads nurtured with targeted content produce an increase in sales opportunities of more than 20% (Tweet this stat)

When it comes to lead nurturing, one size certainly does not fit all. As the research proves, strategically nurturing your leads using targeted content can significantly improve the results of your inbound marketing strategy.

Using targeted content for lead nurturing may seem obvious, but it’s something that marketers are struggling with. Last year Forrester Research reported that 33% of B2B marketers cite “targeted delivery of content” (i.e., delivering the right content, to the right people, at the right time) as their biggest lead nurturing challenge.

There are a few prerequisites for using targeted content for lead nurturing. First of all, you need to understand each of your unique buyer personas. Of course, you then need to create an assortment of targeted content designed to nurture each of your personas based on their interests, goals, objectives, and marketing triggers. Lastly, you need to have a marketing automation platform in place to help you identify, segment and target your unique buyer personas as you scale your inbound marketing strategy.  

2) Multi-channel lead nurturing – Four out of five marketers say their email open rates don’t exceed 20%. It’s time to think beyond the inbox. (Tweet this stat)

In the past, most lead nurturing strategies involved setting up a simple email drip campaign that would send out generic emails to a list of prospects. These day, email-only lead nurturing strategies have a few inherent problems.

For one thing, almost four out of five marketers say their email open rates don’t exceed 20% (Source: The State of B2B Lead Nurturing Survey, Oracle). On top of that, 79% of marketing leads never convert into sales. A lack of effective lead nurturing is the common cause of this poor performance (Source: MarketingSherpa).

Today, marketers like you are looking for new lead nurturing tactics and technologies that go beyond the limits of email. With the help of powerful marketing automation platforms, savvy marketers are now executing multi-channel lead nurturing strategies.

Effective multi-channel lead nurturing most commonly involve a combination of marketing automation, email marketing, social media, paid retargeting, dynamic website content and direct sales outreach. Because there are so many tactics involved, to execute this properly, you really need to ensure that your sales and marketing teams are well aligned and working cohesively.

3) Multiple Touches – Prospects receive an average of 10 touches from the time they enter the top of the funnel until they’re a closed-won customer (Tweet this stat)

While the buyers journey for every product and service can be quite different, research from the Marketing Lead Management Report indicates that on average, prospects receive ten marketing touches from the time they enter the top of funnel until they’re a closed won customers.

Interestingly, another research study from Demand Gen suggests that 49% of marketers include less than five touches in their lead nurturing programs (Source: 2015 Lead Nurturing Benchmark Study). If you’re in this category, it might be time to revamp your lead nurturing efforts a bit. 

As you can imagine, the most successful lead nurturing strategies deliver content that helps prospects progress through the buyer’s journey by addressing common questions and concerns. In addition to email tactics, consider how you can use a mix of content types like social media, blog posts, whitepapers, interactive calculators, or even direct mail, to nurture your prospects into customers. 

4) Timely Follow Ups – The odds of a lead entering the sales process, or becoming qualified, are 21 times greater when contacted within five minutes versus 30 minutes after an inbound lead converts on your website (Tweet this stat)

The benefits of immediate follow up calls seem quite evident, but most organizations still aren’t acting very quickly. A recent article in Harvard Business Review highlighted the surprisingly slow response times of most US based companies. Here are a few benchmarks from the study which included feedback from more than 2,240 US companies:

  • The average first response time of B2B companies to their leads was 42 hours
  • Only 37% of companies responded to their leads within an hour
  • 24% of companies took more than 24 hours
  • 23% of the companies never responded at all

Automated lead nurturing can help you reach large groups of prospects, but a timely followup email or a phone call is still quite often the best way to convert inbound leads into qualified sales opportunities. As several research studies have shown, the odds of converting a lead into a sales opportunity are exponentially higher when the lead is contacted immediately following a website conversion.

When you make a timely, well researched call to an inbound lead it’s far more effective than any volume of cold calling. You know exactly what the prospects is researching based their recent browsing behaviour and you also have enough information about the prospect to do some initial research about the organization they work for and their specific role within the company.

5) Personalized emails – Personalized emails generate up to 6 times higher revenue per email than non-personalized emails do (Tweet this stat)

Several research studies indicate that email marketing continues to be the most effective tactic for lead nurturing.  The research also consistently shows that personalized emails tend to produce significantly better results than generic email blasts. In fact, a recent study by Experian indicated that personalized emails can generate up to six times higher revenue per email than non-personalized campaigns do (Source: Experian Email Marketing Study).

As highlighted in this helpful blog post, there are all kinds of ways you can personalize your emails to improve your lead nurturing strategy. You can send triggered emails when someone downloads your gated content, clicks on links in your emails, visits certain pages on your website, or when they demonstrate a high level of engagement. When you combine the power of marketing personalization with behavioral triggered emails you can deliver the right marketing messages to the right people, at exactly the right times.

6) Lead Scoring – 68% of successful marketers cite lead scoring based on content and engagement as the most effective tactic for improving revenue contribution from lead nurturing (Tweet this stat)

As the 2013 Lead Generation Marketing Effectiveness Study revealed, 68% of successful marketers cite lead scoring based on content and engagement as the most effective tactic for improving revenue contribution from lead nurturing. With compelling research like that you’d think that everyone would be adopting lead scoring, but a recent study by MarketingSherpa indicates that only 21% of B2B marketers are using lead scoring.

For those who are new to the concept of lead scoring, it is a methodology used to rank prospects against a scale that represents the perceived value each lead represents to the organization. Lead scoring can be implemented in most marketing automation platforms by assigning numeric values to certain website browsing behaviours, conversion events, or even social media interactions. The resulting score is used to determine which leads should be followed up with directly by a sales rep or which leads need to be nurtured further down the funnel. 

Based on this research, it seems as though lead scoring is an effective lead nurturing tactic that most marketers simply aren’t taking advantage of yet. 

7) Sales and Marketing Alignment – 89% of companies that align their sales and marketing lead nurturing efforts report measurable increases in the number of sales opportunities generated (Tweet this stat)

According to a study by market research firm CSO Insights, when both sales and marketing share responsibility for lead nurturing, companies experience a significant increase in conversion rates. As the 2014 Sales Performance Optimization Study revealed, 89% of companies that aligned sales and marketing lead generation efforts reported measurable increases in the number of leads that turned to opportunities as a result of continuous nurturing (Source: Sales Performance Optimization Study).

In order for both sales and marketing to contribute to lead nurturing you’ll need to identity when prospects should be transitioned between teams as they progress through the funnel. In creating your lead nurturing strategy, think about how you can use triggers like lead scoring, pageviews, workflow enrollment, conversion events or sales contact to transition leads from automation to direct one-on-one outreach.

The shared expectations, responsibilities and goals for this collaboration between sales and marketing should be outlined in a sales and marketing service level agreement (SLA). Creating a formal sales and marketing SLA will help the two teams hold each other accountable for converting leads and effectively nurturing them into paying customers.

In review, let’s quickly recap the seven most effective lead nurturing tactics:

1) Targeted content – Leads nurtured with targeted content produce an increase in sales opportunities of more than 20%

2) Multi-channel lead nurturing – Four out of five marketers say their email open rates don’t exceed 20%. It’s time to think beyond the inbox.

3) Multiple Touches – Prospects receive an average of 10 touches from the time they enter the top of the funnel until they’re a closed-won customer.

4) Timely Follow Ups – The odds of a lead entering the sales process, or becoming qualified, are 21 times greater when contacted within five minutes versus 30 minutes after an inbound lead converts on your website.

5) Personalized emails – Personalized emails generate up to 6 times higher revenue per email than non-personalized emails do.

6) Lead Scoring – 68% of successful marketers cite lead scoring based on content and engagement as the most effective tactic for improving revenue contribution from lead nurturing. 

7) Sales and Marketing Alignment – 89% of companies that align their sales and marketing lead nurturing efforts report measurable increases in the number of sales opportunities generated.

Want some more tips & tricks to boost the results of your inbound marketing strategy?

Inbound-Strategy-CTA.png

Review: Synology NAS, a solid backup solution and great home media server with Plex

I’ve recently been testing the brand new Synology DS-216+ NAS ($329), a network-attached-storage product meant for consumers. Although Synology products include a variety of features, I will be focusing on two primary functions that I consider most essential and most useful to people today: Mac backup and home media management (TV shows and movies).

With Apple no longer shipping optical drives in most of their products, I think now is a great time to convert your home movie collection of DVDs and Blu-rays to digital files, which a NAS is great for storing. The Apple TV 4 was another big factor: with an app, I can now view all the TV shows and movies, stored on my NAS, from my TV.

Before I owned a NAS, I was worried about two things: whether the features would be useful and how much hassle would be necessary to get everything up and running. Hence, my review starts with an explanation of the setup steps involved …

more…

Filed under: AAPL Company, iOS, iOS Devices, Reviews, Tech Industry Tagged: Backups, home media server, how to, NAS, Plex, server, Synology, Time Machine

How to watch March Madness 2016 on iPhone, iPad, MacBook, or Apple TV

Every basketball fan’s favorite time of year kicks off later today with the play-in round of the NCCA March Madness tournament. After tonight, we’re looking at non-stop basketball for the rest of the month and it really doesn’t get much better than that.

Earlier this month, the NCAA announced that it would be live streaming all of the 2016 March Madness games on various platforms, and even teased an exclusive feature for Apple TV users. With games commencing this evening, it’s time to make sure you have everything setup so you’ll never run the chance of missing a game this year…

more…

Filed under: Apple TV, Apps Tagged: Apple TV, how to, iOS, March Madness, streaming

9to5Toys Lunch Break: Dell 24″ 4K Monitor $390, Guitar Hero Live iOS $50, VIZIO Sound Stand $150, more

Keep up with the best gear and deals on the web by signing up for the 9to5Toys Newsletter. Also, be sure to check us out on: Twitter, RSS Feed, Facebook, Google+ and Safari push notifications.

TODAY’S CAN’T MISS DEALS:

screen-shot-2016-03-14-at-10-16-48-pm

4K Displays: Dell 24″ $390 (Reg. $600), Dell 27″ $500 (Reg. $700), Acer 28″ refurb $240 (Reg. $500), more

guitar-hero-live-sale-01

Games/Apps: Guitar Hero Live iOS $50, Battlefield Hardline from $20, GTA Trilogy for Mac $6, freebies, more

vizio-ss2521-c6

Home Theater Audio: VIZIO 25-inch Sound Stand $150 shipped (Reg. $200), JBL Soundbar (Refurb) $70 (Orig. $200)

macbook-pro-retina-mf840lla

Apple 13-inch Retina MacBook Pro (newest) 2.7GHz/8GB/256GB $1,200 shipped (Reg. $1,499)

Apple 13-inch MacBook Pro 2.7GHz/8GB/128GB: $1,049 shipped (Reg. $1,299)

ipad-pro-gold-ebay

Fresh iPad Pro discounts: 32GB Wi-Fi $650, 128GB Wi-Fi + Cellular $890, all other models $100 off

Apple iPhone 6s/Plus Factory Unlocked up to $100 off, 16GB just $579 shipped (Reg. $649)

Apple TV Deals: 4th Gen 64GB $175 (Reg. $200), 3rd Gen $49 (Reg. $69), more

oneSafe-Free App of the Week-01

App Store Free App of the Week: oneSafe Premium Password Manager on iOS goes free for the first time (Reg. $5)

App Store Indie Game Sale 50% off: The Room Three, BADLAND 2, Mutant Mudds, more

Grab the Hitman GO & Hitman Sniper iOS bundle for just $1 (up to $10 value)

The Room Three mystery-puzzler for iOS gets its very first price drop: $2 (Reg. $5)

BADLAND 2 for iOS gets its very first price drop: $2 (Reg. $5)

TomTom for iPhone goes free for first 50 miles per month w/ new “GO Mobile” app

MORE NEW GEAR FROM TODAY:

motorola-cable-modem-lineup

End the madness – stop renting your cable modem with these refurb Motorola deals from $35 shipped (Orig. up to $130)

MORE DEALS STILL ALIVE:

apple-watch-band-dock-deal

Apple Watch 42mm Space Gray Milanese Loop Band + Aluminum Dock: $26 Prime shipped (Reg. $34)

house-powered-by-prius

How-to: Use your car and an inexpensive inverter to replace the need for a home generator

NEW PRODUCTS & MORE:

philips-hue-white-ambiance

Philips introduces new ambient Hue Lights that automatically simulates the sun

wd-pidrive

WD’s new internal hard drive for Raspberry Pi brings 314GB of additional storage

Filed under: Tips and Tricks

Buy Parallels ($49-$79) & get 7 Mac apps free: 1Password, Parallels Access, & more (Reg. $269)

Starting today, Parallels is offering a new bundle for a limited time that will let you get 81% off 7 great Mac apps with the purchase or upgrade of Parallels Desktop for Mac ($50-$79).

That means if you either purchase Parallels Desktop for $79.99, or upgrade to the latest version for $49.99, you’ll get the following 7 apps free: 1Password, CleanMyMac, Kaspersky for Mac, PDF Expert, PDF Office for iPad & Parallels Access.

Get the Parallels Power Bundle now

more…

Filed under: Apps Tagged: 1Password, 81% off, Access, Bundle, Coupon, discount, free, Mac, parallels desktop, PDF Expert, Upgrade

Apple Music secures rights to mixes and DJ mixes; brings EDM artist deadmau5 to Beats 1

While mixes and DJ mixes can be popular, getting the streaming rights to them can be a complex business – especially when a single mix can contain elements owned by up to 600 different rights holders. But an agreement between Apple and digital distributor Dubset means that Apple Music now has the right to stream many thousands of mix tracks, reports Billboard.

Thousands upon thousands cool mash-ups and hour-long mixes have effectively been pulled out of the underground and placed onto the world’s second-largest music subscription service […]

Dubset will use a proprietary technology called MixBank to analyze a remix or long-form DJ mix file, identify recordings inside the file, and properly pay both record labels and music publishers.

Dubset CEO Stephen White says the company had to overcome tough challenges on both technological and legal fronts …

more…

Filed under: Apple Music Tagged: Apple Music, deadmau5, DJ mixes, EDM, mau5trap, mixes, Remixes, SoundCloud

Review: Philips 27-inch Quantum Dot monitor promises greater color accuracy and clarity

I had never heard of quantum dot display technology until Philips announced their new E6 monitor. Touting to be the world’s first quantum dot display monitor and the only one to reach 99% AdobeRGB color, I definitely became interested. I was already on the hunt for a high-quality monitor, so this seemed like the perfect opportunity.

more…

Filed under: Reviews Tagged: 276E, Philips, Quantum Dots

Apple granted patent for one-shot panoramic photo feature, using optical image stabilization

iPhones have long allowed you to create panoramic images by taking multiple photos which the camera stitches together. But an Apple patent granted today could allow future iPhones to take panoramic photos effectively with a single shot. Apple describes this as ‘super resolution mode.’

The reality would be that the iPhone would still take multiple photos to switch together, but the process would be automated so the user experience would be taking just one shot …

more…

Filed under: iOS Devices Tagged: image stabilization, iPhone, iphone camera, Panorama, Patent

Review: Phiaton BT 460 wireless headphones combine touch-panel, auto-pause/play gadget appeal with balanced sound

I’ve always been slightly torn when it comes to headphone choice. While I make no claims to being an audiophile, sound quality is my number one criteria when it comes to selecting headphones. I like neutral sound characteristics that faithfully reproduce what the musicians intended us to hear. I also like high-quality, traditional materials with understated looks. That tends to leave me choosing from the traditional hifi brands.

At the same time, though, I’m a gadget guy. I loved the touch-panel controls of the Parrot Zik. The only thing that put me off those is that, plane journeys aside, I’m not a fan of noise-cancelling cans. I like to be able to hear just a little of what’s going on around me – enough to hear when an announcement is being made on a train, or that I’m about to step in front of a bus – and the Zik headphones don’t sound good in passive mode.

So when Phiaton announced the BT 460, which has a similar touch-and-swipe interface, I thought I’d give them a try. These also have one further claim to fame on the gadget front: they automatically pause music when you take them off, and auto-resume when you put them back on …

more…

Filed under: Reviews Tagged: Bluetooth, headphones, Phiaton, Phiaton BT 460 wireless headphones

Foxconn seeking concessions from shareholding banks in attempt to rescue Sharp takeover

The Nikkei Asian Review reports the latest on the on-off-maybe acquisition of display maker Sharp by iPhone assembler Foxconn.

Various potential deals appear to be under discussion with both Mizuho Bank and Bank of Tokyo-Mitsubishi UFJ. These include paying the banks less for the shares they hold, reducing the interest rate payable on a joint loan to Sharp and agreeing that the banks will provide financial support in the event that the feared liabilities do indeed materialize after the deal is done.

It was initially reported last month that the deal had been done before details of potential Sharp liabilities put it into doubt. Negotiations then resumed.

It had been suggested at one stage that Apple may help to support the deal, but as there has been no recent mention of this, we’d say this currently seems unlikely. Foxconn has, however, long played a role in helping keep Sharp afloat.

Filed under: AAPL Company Tagged: china, Foxconn, iPhone, Sharp, The Bank of Tokyo-Mitsubishi UFJ

Personalize or Perish: The Definitive Guide to Personalization for Digital Publishers [New Ebook]

Segmentation.png

Readers are being bombarded by more and more content each and every day. This overwhelming volume of articles, videos, status updates, and more is causing audiences to bounce faster from websites, click “delete” immediately on emails, and use any method available to tune our the noise.

At the same time,  reliable sources of content distribution are becoming increasingly important for publishers, as spam filters grow more powerful, ads are blocked, and social media becomes a pay-to-play channel. So what can publishers do to earn the reader attention and engagement they so desperately need to drive revenue? 

It’s easy for readers to glance over emails that make them feel like “just another name on an email list.” Or leave a website that’s littered with far too many irrelevant options. But when it feels like a newsletter was curated just for you, or a website had the exact link you were looking for—that’s what keeps people engaged for longer. 

Audience segmentation and personalization can make one-to-many communications feel more personal, while simultaneously offering greater value to a larger number of readers.

To help you learn more about audience segmentation and personalization, we teamed up with BrightInfo to write Personalize or Perish, the definitive guide on how publishers can:

  • Collect better unified audience data across websites, events, emails, and more
  • Build audience segments specific to internal or external offerings
  • Communicate unique messages out to these segments via email and on-site content

Ready to learn more?

>> You can download the full ebook here

Personalize or Perish

How to Create a Pivot Table in Excel: A Step-by-Step Tutorial (With Video)

create-pivot-table.jpg

The pivot table is one of Excel’s most powerful — and intimidating — functions. Powerful, because it can help you summarize and make sense of large data sets. Intimidating, because you’re not exactly an Excel expert, and pivot tables have always had a reputation for being complicated.

Download our complete guide to using Excel here for more step-by-step Excel tutorials.

The good news: Learning how to create a pivot table in Excel is much, much easier than you’ve likely been led to believe. But before we walk you through process of creating one, let’s take a step back and make sure you understand exactly what a pivot table is, and why you might need to use one.

What Is a Pivot Table?

To quote Microsoft, a pivot table is a report that lets you, “summarize, analyze, explore, and present a summary” of your data. And it is particularly useful “when you have a long list of figures to sum, and aggregated data or subtotals would help you look at the data from different perspectives and compare figures of similar data.”

In other words, a pivot table lets you extract meaning from that seemingly endless jumble of numbers on your screen. And more specifically, it lets you group your data together in different ways so you can more easily make comparisons.

The “pivot” part of a pivot table stems from the fact that you can rotate (or pivot) the data in the table in order to view it from a different perspective. To be clear, you’re not adding to, subtracting from, or otherwise changing your data when you make a pivot. Instead, you’re simply reorganizing the data so you can extract useful information from it.

Use Cases for Pivot Tables

If you are still feeling a bit confused about what a pivot table actually does, don’t worry. This is one of those technologies that’s much easier to understand once you’ve seen it in action. So, here are two hypothetical scenarios where you’d want to use a pivot table.

Scenario #1: Comparing Sales Totals of Different Products

Say you have a worksheet that contains monthly sales data for three different products — product 1, product 2, and product 3 — and you want to figure out which of the three has been bringing in the most bucks. You could, of course, look through the worksheet and manually add the corresponding sales figure to a running total every time product 1 appears. You could then do the same for product 2, and product 3, until you have totals for all of them. Piece of cake, right?

Now, imagine that monthly sales worksheet of yours has thousands and thousands of rows. Manually sorting through them all could take a lifetime. Using a pivot table, you can automatically aggregate all of the sales figures for product 1, product 2, and product 3 — and calculate their respective sums — in less than a minute.

Scenario #2: Combining Duplicate Data

In this scenario, you’ve just completed a blog redesign and had to update a bunch of URLs. Unfortunately, your blog reporting software didn’t handle it very well, and ended up splitting the “view” metrics for single posts between two different URLs. So in your spreadsheet, you have two separate instances of each individual blog post. In order to get accurate data, you need to combine the view totals for each of these duplicates.

That’s where the pivot table comes into play. Instead of having to manually search for and combine all the metrics from the duplicates, you can summarize your data (via pivot table) by blog post title, and voilà: the view metrics from those duplicate posts will be aggregated automatically.

How to Create Excel Pivot Tables

Now that you have a better sense of what pivot tables can be used for, let’s get into the nitty-gritty of how to actually create one.

Step 1: Click a cell to create the table. 

If you’re using a Mac, click anywhere inside your data array, navigate to the Tables tab, and click New. (Alternatively, you can go to Insert > Table via the top navigation). Then, select the Summarize with PivotTable option from the Tables tab and click OK on the pop-up menu.

If you’re using a PC, this process is a little bit simpler: Just click anywhere inside your data array and navigate to the Insert tab. Next, select the “PivotTable” option and click “OK” on the pop-up menu.

pivot-table-step-1.png

Step 2: Drag and drop a field into the “Row Labels” area.

After you’ve completed Step 1, Excel will create a blank pivot table for you. Your next step is to drag and drop a field — labeled according to the names of the columns in your spreadsheet — into the “Row Labels” area. This will determine what unique identifier — blog post title, product name, and so on — the pivot table will organize your data by.

For example, let’s say you want to organize a bunch of blogging data by post title. To do that, you’d simply click and drag the “Title” field to the “Row Labels” area.

pivot-table-step-2.png

Note: Your pivot table may look different depending on which version of Excel you’re working with. However, the general principles remain the same.

Step 3: Drag and drop a field into the “Values” area.

Once you’ve established what you’re going to organize your data by, your next step is to add in some values by dragging a field into the “Values” area.

Sticking with the blogging data example, let’s say you want to summarize blog post views by title. To do this, you’d simply drag the “Views” field into the Values area.

pivot-table-step-3.png

Step 4: Fine-tune your calculations.

The sum of a particular value will be calculated by default, but you can easily change this to something like average, maximum, or minimum depending on what you want to calculate.

On a Mac, you can do this by clicking on the small “i” next to a value in the “Values” area, selecting the option you want, and clicking “OK.” Once you’ve made your selection, your pivot table will be updated accordingly.

If you’re using a PC, you’ll need to click on the small upside-down triangle next to your value and select “Value Field Settings” in order to access the menu.

pivot-table-step-4.png

Digging Deeper

You’ve now learned the basics of pivot table creation in Excel. But depending on what you need your pivot table for, you might not be done.

For example, you may notice that the data in your pivot table isn’t sorted the way you’d like. If were the case, Excel’s Sort function can help you out. Alternatively, you may need to incorporate data from another source into your reporting, in which case the VLOOKUP function could come in handy.

To take a deeper dive into the world of Excel and learn about its various functions, download our comprehensive guide, How to Use Excel.

Editor’s Note: This post was originally published in December 2013 and has been updated for accuracy and comprehensiveness.

free guide: how to use excel

 
free guide: how to use excel

Pressure on Apple over European tax affairs ramps up as European Parliament seeks explanations

With a long-running investigation into the legality of Apple’s tax arrangements in Europe not expected to end any time soon, the company will come under additional pressure tomorrow when it is called before the European Parliament’s tax committee.

more…

Filed under: AAPL Company Tagged: AAPL, Apple, Europe, European Parliament, European Union, Tax, tax investigation