Conditional Formatting in Pivot Table

Conditional Formatting in Pivot Table

You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. In this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table. Below, I have used conditional formatting in pivot table to present a dynamic formatting. It will highlight city which has highest amount & a city which has lowest amount every time I filter states with slicer. I will show you how to…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

Excel Pivot Chart

Excel Pivot Chart

Do you remember when last time you created an Excel Pivot Chart? And, do you know Excel Pivot Chart is the easiest way to create dynamic charts in excel? The bad news is, most of the Excel users avoid using Excel pivot chart in their work. But the good news is, creating an Excel Pivot Chart is simple, just like a creating a pivot table. In this tutorial, you will learn how to use an Excel Pivot Chart and how you can make best out of it. I will also show you some…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

5 Effective Ways to Quickly Repair a Corrupt Excel File

5 Effective Ways to Quickly Repair a Corrupt Excel File

Excel is extensively used by both business organizations and individuals for maintaining records or tasks. The most petrifying situation is when the file is corrupt, and the data becomes inaccessible. In this blog, we will be discussing the causes of corruption and five ways to repair a corrupt Excel File. Even a minor error can completely corrupt the file. Some of the common causes of Excel file corruption are: Improper shutdown of the system – One of the primary causes of Excel file corruption is animproper shutdown of the system….

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

Learn Excel Basics – An Introduction To Microsoft Excel For Beginners

Learn Excel Basics – An Introduction To Microsoft Excel For Beginners

Now in these days, every company & business firm is trying to work smarter. Microsoft Excel is one of the most useful tools to work smarter. These days every company & employees as well are dependent on Microsoft Excel. From Accountant to Receptionist, Human Resource to Administration department all are using Microsoft Excel for their daily work. They are managing their lists, timetables, Ledger Accounts, Tax Calculation in excel. Excel is not limited to only large companies, even small entrepreneurs, college student are also running with Microsoft Excel for their…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

Excel 3D Reference

Excel 3D Reference

Using Excel 3D Reference can save your lot of time & help you to avoid lengthy formulas. Excel 3D Reference is like three-dimensional chart or image which has more than one phase. If we talk about the normal range it is all about the group of cells from a single worksheet. For Example =Sum(Sheet1!C5:D6).  Here, “C5:D6” is a group of cells to which is referred from Sheet1. But the 3D reference is a range of cells in which you can reference to the same cells but from multiple worksheets. In simple words, you…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

Google Translate now provides instant visual translations in 27 languages on iOS and Android

Google Translate now provides instant visual translations in 27 languages on iOS and Android

Above: Google Translate translating visual text instantly. Image Credit: Google Google today announced that within the next few days its Google Translate app for iOS and Android will be able to give users immediate visual translations of text in 27 languages. Instant visual translation is now available for Bulgarian, Catalan, Croatian, Czech, Danish, Dutch, English, Filipino, Finnish, French, German, Hindi, Hungarian, Indonesian, Italian, Lithuanian, Norwegian, Polish, Portuguese, Romanian, Russian, Slovak, Spanish, Swedish, Thai, Turkish, and Ukrainian, according to ablog post today from Google Translate product lead Barak Turovsky. Meanwhile, the…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

20 Tricks That Can Make Anyone An Excel Expert

20 Tricks That Can Make Anyone An Excel Expert

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2010. 1. One Click to Select All You might know how to select all by…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

RoBoHon Robot Mobile Goes on Sale in Japan

RoBoHon Robot Mobile Goes on Sale in Japan

The world’s first robotic mobile phone RoBoHon, a pocket-size walking and dancing robot, started sale on Thursday in Japan. The human-shaped smartphone, developed by Japanese electronics company, Sharp and engineer Tomotaka Takahashi, inventor of the first robot astronaut ‘Kirobo’, went on sale with a base price of JPY 198,000 ($1,800 or roughly Rs. 1.21 lakhs), EFE news reported. To mark the launch, the Osaka-based company opened theRoBoHon Cafe in Tokyo where visitors can test the robot until June 7. The Japanese electronics manufacturer is producing 5,000 units per month, aiming…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

BitTorrent Live streaming app coming to Apple TV with a free tier at launch, premium channels later

BitTorrent Live streaming app coming to Apple TV with a free tier at launch, premium channels later

 BitTorrent may be mostly known for file sharing, but for years the company has been leveraging its peer-to-peer technology for a number of different projects — from serverless messaging to a cloudless Dropbox rival and a broadcasting platform. Today’s announcement concerns the latter. Specifically, a dedicated BitTorrent Live app that’s set to launch on Apple TV this week, before coming to iOS and Android sometime in June. The service will focus on professionally created content with a free tier available at launch — among them is Leo Laporte’s TWiT network,…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

WhatsApp update: 5 new features added

WhatsApp update: 5 new features added

We’re always keeping an eye out for new WhatsApp features, and the latest update brings 5 new features, some new, some migrated from the beta version. Head to the updated sections below to see all the news on the latest WhatsApp update.   What’s new in the latest WhatsApp update? / © MULTIWAVE WhatsApp add rich text formatting, reply from notification shade, more April 30, 2016: WhatsApp has migrated several features from the beta version of WhatsApp to the final version and added some previously unseen ones, too. Firstly, all users can now use…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

Innjoo Fire 2 Plus LTE Android Phones -Specs and Price

Innjoo Fire 2 Plus LTE Android Phones -Specs and Price

Fire2 Plus LTE Quality in Elegance DESIGN Premium metal shell, comfortable touch feeling Fire2 Plus LTE is a real one-piece craft. Metal shell, cool touch; smooth arc, excellent grab feel; textured thin phone body, perfect experience. Fire2 Plus LTE redefines the limits of smartphone design. 5.5 inch HD display, stunning view Fire2 Plus LTE is a new 5.5-inch 4G smartphone. With the big IPS screen, every color jumps out from the screen, images are more defined, and videos sharper. 1280*720 HD resolution promises images fine and smooth. 16:9 aspect ratio…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

FACTORY RESET IPHONE WITHOUT PASSWORD

FACTORY RESET IPHONE WITHOUT PASSWORD

Everyone has their own Reasons of having password on their phone. Most of the time its about Security Reasons and to avoid unauthorized access but the real problem occurs when you fail to remember or forget your Password. In such situations, only thing that comes in mind is to factory reset the phone so that you can start all over again with new password. Today we will be discussing and sharing Steps on How to Factory reset iphone without password. So in Case you have forgot your password. Or you…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

10 Creative Ways To Make Money Online

10 Creative Ways To Make Money Online

If you’d claimed it was possible for the average guy on the street to make millions of dollars online just a decade ago, the chances are good you’d have heard nothing but laughter in response. Today, though, there are countless Internet millionaires who turned a great idea into obscene profit, used the power of the web to promote their offline business or simply worked their butt off to sell their skills online.   While it’s unlikely that you’ll ever earn enough to buy your own private island, there’s nothing to…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More

YouTube now supports livestreaming of 360-degree video

YouTube now supports livestreaming of 360-degree video

YouTube enabled support for 360-degree videos more than a year ago. Now, the Google-owned company is taking that pivotal next step in immersive video by enabling users to livestream 360-degree video. To ensure a seamless experience, YouTube Chief Product Officer Neal Mohan said they’ve been working with companies like Two Big Ears and VideoStitch to make sure their software is compatible with 360-degree livestreams and spatial audio. Speaking of, spatial audio is another new technology currently being rolled out albeit only for on-demand videos. Spatial audio lets viewers listen along…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Read More
1 2 3 4