How to link a single slicer to two or more Excel PivotTables

Friday, September 23, 2016 7:12:00 PM America/Los_Angeles

Last month's article How to create an effective, user-friendly slicer in Excel offered an introduction to Excel's slicer feature. This graphic tool lets users, with no specialized skill, filter data in a meaningful way. This month, we'll continue our discussion of slicers with a more advanced topic: using a single slicer to update two or more PivotTables. Doing so is helpful when you want to focus on data in the same data source in different ways.

I'm using cheap office 2016 on a Windows 64-bit system, but the feature is available in Excel 2010 and 2013. In Excel 2010, slicers work only with PivotTables. Beginning with Excel 2013, you can add a slicer to a Table. They even work in a browser using Excel Web App. For your convenience, you can download the .xlsx demonstration file. (This file also contains the example data and slicer from last month's article.)

We'll be working with the data shown in Figure A to create two PivotTables and then link the same slicer to both. The first PivotTable will sum the Value field by region; the second will sum the Commission field by personnel. The second PivotTable won't even display the region, but the slicer will still filter it by region.

We'll begin by generating the first PivotTable. If you're using Excel 2016, Excel does almost everything for you. To generate the first one, do the following:

1.Click anywhere inside the Table (the demonstration file's sheet name is Multiple PivotTable Table).

2.Click the Insert tab and then choose Recommended PivotTables in the Tables group.

3.Select the first option (Figure B), Sum of Value by Region, and click OK. Excel creates the selected PivotTable (Figure C) on a new sheet—I named the new sheet Multiple PivotTables, but doing so isn't necessary.

Posted in News By SEO admin

Office 2016 will updates hit Mac Office 365 users

Thursday, September 22, 2016 7:50:57 PM America/Los_Angeles

Microsoft is continuing its cross platform push today by finally releasing cheap Office 2016 for Mac. For Mac users still using Office, it has been a little over five years since the office suite had been addressed by Microsoft. On the Mac, Office received a few updates that brought more security features issued rather than UI and UX implementations. Since Office 2011 first debut on the Mac, a lot has changed in both the Microsoft and Apple camps.

Since 2010, OSX has gone through several visual and functional retooling to the user interface. Office 2011 and its antiquated toolbars, ribbons and iconography meant to compliment OSX Lion, and Mountain Lion were reminders to Mac users of Microsoft's neglect for the platform. In addition to Office 2011 being a visual nightmare, the office suit suffered from a deficit in functionality. Anecdotally, Office 2011 users on the Mac often complained about performance, and lack of feature parity compared to Office users on Windows. In the same time, Microsoft revisited Office on the Windows side several times. Over the past five years, Office has gone from a mostly static box purchase meant to sustain workflows for years at a time, to a living online productivity tool.

With Office 2016 for Mac, Microsoft is now bringing its new cloud-connected productivity tools into a modern OSX environment. According to the Office team, “It works the way you expect, with the familiar ribbon interface and powerful task panes. Mac users will appreciate the modernized Office experience and the integration of Mac capabilities like a Full-Screen view and Multi-TouchTM gestures. With full Retina display support, your Office documents look sharper and more vibrant than ever.” Specifically, OSX users can look forward to built-in document sharing tools, multi-platform compatibility, improved animations, performance improvements, extended layout and design templates, and new PivotTable Slicers for compiling denser amounts of information.

Posted in News By SEO admin

Which should you buy Office 365 or Office 2016?

Wednesday, September 21, 2016 7:35:05 PM America/Los_Angeles

Office 365 and Office 2016 share a lot of similarities, yet deciding between the two involves a lot of factors.

Office 365 is a subscription-based service that currently uses Office 2016 apps, but when the next version of Office is released, users will get that as part of their subscription.

Office 2016 is a buy-once app suite that brings you the cheap Office 2016 apps as they are, without any available updates in the future. If you want to upgrade to the latest version of Office without paying for a subscription, you'll have to pay full price for the new version — there's no discounted upgrade option.

These are only a couple differences between the two products. Looking to invest in Office? We break down the differences between the two products to help you decide which is better for personal and home use.

Office 365 is a subscription-based service. If you choose to pay on a yearly basis, you essentially get a discount that works out to two free months per year. If you choose to pay on a monthly basis, you'll be paying a bit more by the end of the year, but you'll also have the ability to back out of your subscription at the end of any month.

The monthly subscription plan is therefore better for students who only need Office for a few months out of the year, whereas a yearly subscription is great for anyone working from home.

Office 2016 is a classic, buy-once sort of deal. This is better for those of you who want to purchase an item once and have it forever. If you only want Word, Excel, PowerPoint, and OneNote, Office Home & Student 2016 is worth looking at.

Keep in mind, though, that Office 2016 only receives security and bug updates and does not get any of the new features coming in the future. If you buy an Office 365 subscription today and keep it going until, say, 2020, you'll basically have Office 2020. If you buy Office 2016 today and keep it until 2020, you'll still have the same old Office 2016 without any new features.

If you want the full suite of Office apps, you have to go with either Office 365 or Office Professional 2016. As you can see in the table above, buying an Office Professional 2016 plan, which has the same apps as Office 365, but doesn't have the same cloud storage or multiple device functionality, will set you back about $400. For the same apps, 1TB of storage, and the ability to install the apps on a PC, a tablet, and a phone, you're only paying about $70 for a year with Office 365 Personal.

Posted in News By SEO admin

How to create a new Microsoft account on Windows 10

Tuesday, September 20, 2016 7:40:48 PM America/Los_Angeles

1.Open Settings.

2.Click on Accounts.

3.Click on Family & other people.

4.Under "Other people", click the Add someone else to this PC button.

5.Type your email address on the field.

6.Click Next.

7.Click Finish.

8.Sign out from your account.

9.Sign-in to the newly created account using your Microsoft account credentials.

10.Open Settings.

11.Click on Update & security.

12.Click on Activation to verify your digital license is linked your Microsoft account.

13.Sign-out from your Microsoft account, and sign-in again to your local account.

You have successfully associated your cheap Windows 10 product key to an Microsoft account without losing your local account.

Now chances are you'll rarely go back to the secondary Microsoft account, but because you'll lose the link if you remove it, one thing you can do is to hide the account on the sign-in screen, so no one will know is there.

Posted in News By SEO admin

Microsoft: Free Music, Sound Effects For Office 2010 Users

Monday, September 19, 2016 7:31:00 PM America/Los_Angeles

AudioMicro, a site where you can find royalty-free stock music and sound effects backed by DFJ Frontier and Fotolia, has struck a deal with Microsoft to provide music and sound effect files to cheap Office 2010 users worldwide.

Under the terms of the licensing and distribution deal, Microsoft Office 2010 users are able to select from a hand-picked collection of over 1,500 music tracks and sound effects at Office.com to use with any Microsoft Office project.

The partnership is noteworthy because AudioMicro launched in 2008 with a heavy emphasis on the needs of PowerPoint slideshow creators, AudioMicro founder and CEO Ryan Born says.

Royalty-free sound effects offered by AudioMicro on Office.com include parts of The Hollywood Edge sound effects library created by the sound editors of Soundelux, whose credits include such films as Unstoppable, Inglourious Basterds, The Bourne Ultimatum and Braveheart.

AudioMicro is not all about stock music and sound effects, by the way – the company operates a constantly growing network of digital content licensing marketplaces, including for cartoons, celebrity pictures, and tattoo flash.

The company also announced that it recently brought on Myspace VP Sean Percival as an advisor – he will be helping the young company out with all things SEO and social.

Posted in News By SEO admin

App-Specific Changes with office 2016

Sunday, September 18, 2016 7:19:25 PM America/Los_Angeles

As mentioned earlier, the core functionality of each cheap Office 2016 application hasn’t changed much in Office 2016. Here’s a quick list of a few of the changes that Microsoft did managed to squeeze in:

Six new chart types are available in Word, Excel, and PowerPoint

Excel has gained some new built-in business intelligence, integrating the Power Query add-in previously available in Excel 2010 and 2013 into a new Get & Transform section in the Data ribbon

Outlook lists recently opened Office documents when inserting an attachment

Outlook Clutter attempts to be more intelligence in filtering email that’s not necessarily spam, but isn’t terribly important either

Posted in News By SEO admin

Office 365 Admin app gets an update

Saturday, September 17, 2016 7:15:46 PM America/Los_Angeles

The updated cheap Office 365 admin app has been treated to a overhauled design which is expected to make it easier and more efficient for the users. Just like we said earlier, Office 365 admin has been doing well ever since its launch in 2014 and it has also been receiving some rave reviews with a 4+ star rating across all platforms.

Initially launched as a companion app, the Admin 365 has been adding new features which has made it like a complete app that offers most of the features that the actual software on PC would. Statistically speaking, Microsoft has added 40 feature updates since the last 12 months.

The update also brings in feature grouping for the app which would let you group similar features which will eventually be displayed on a single card. Furthermore, new quick links on the dashboard that would let you directly access the settings.

Important issues that need your assistance will be easier to spot with the update, as it would be highlighted in the app. The new updated version will be available for Android and Windows Phone, and will hit iOS in the upcoming weeks. If you are an admin and want to manage Office 365, download the admin app from here.

Posted in News By SEO admin

Link Windows 10 license to Microsoft Account

Tuesday, September 13, 2016 7:26:16 PM America/Los_Angeles

Microsoft now gives you a digital license for your cheap Windows 10, as well as other Microsoft software, that you can save to the cloud, linking it to your Microsoft Account, so that whenever you fresh install Windows, the OS will get activated automatically.

If you use a Local Account to log in, your license may not get saved online. For this, you will have to specially take some steps to link the Windows 10 product license to your Microsoft Account. Let us see how you can do it in Windows 10 Anniversary Update v1607 and later.

From the Start Menu, open Settings > Update and security > Activation.

When here, click on Add a Microsoft account. The following window will open.

Here you will have to log in with the Microsoft account with which you want to link the license to. If you do not have one, you can Create one.

Once you link the two together, you will see a message always displayed – Windows is activated with a digital license linked to your Microsoft Account.

It might be a good idea to link the two together if you haven’t done so already.

Posted in News By SEO admin

Want to buy a new Windows 7 PC?

Monday, September 12, 2016 7:13:43 PM America/Los_Angeles

Microsoft has quietly updated its Windows Lifecycle Fact Sheet page, adding October 31, 2016 as the last date on which manufacturers can sell PCs with Windows 7 preinstalled.

Microsoft's policy is to set the end-of-sales date for a specific Windows version two years after the launch of the version of Windows that succeeds it. Under that policy, sales of Windows 7 PCs should have ended in late October of 2014, two years after the launch of Windows 8.

But the tepid response of the market to Windows 8 led Microsoft to give PC makers a reprieve, allowing them to continue selling PCs with Windows 7 Pro installed. At the time, the company promised it would give a year's notice before changing that policy.

That time's up, apparently. PCs with Windows 8.1 and cheap Windows 7 can continue to be sold until October 31, 2016. After that date, businesses will need to use downgrade rights or exercise Software Assurance rights with volume license agreements to run the old version on new hardware.

Ironically, the end-of-sales date for Windows 8 PCs will arrive even sooner, on June 30, 2016.

For an explanation of how the new sales lifecycle dates affect the PC market, see "What the Windows 7 Pro sales lifecycle changes mean to consumers and business buyers."

The change represents a vote of confidence from Microsoft management that businesses are willing to migrate from Windows 7 to Windows 10. It also means they're betting that consumer acceptance of the newest OS release will be solidly positive.

(It's worth noting here that the support lifecycle for Windows 7 isn't changed. All editions of Windows 7 will continue to receive security updates throughout the Extended Support period, which ends on January 14, 2020. Windows 8.1 is still in mainstream support. The Extended Support period begins on January 9, 2018 and runs through January 10, 2023, when Windows 8.1 will no longer be supported.)

The bottom line: One year from today, you'll still be able to find new PCs running Windows 7 and Windows 8.1, but only in existing inventory. And Windows 7 PCs will become increasingly hard to find as that inventory vanishes from warehouses, because OEMs won't be allowed to build new consumer and business PCs for the retail channel with any version except Windows 10 preinstalled.

Posted in News By SEO admin

Microsoft 2016 Edge now support Bing Image Search

Sunday, September 11, 2016 7:16:43 PM America/Los_Angeles

Last April, Bing finally put out its own Image Search engine, once again entering a space long dominated by Google. Like Google Images before it, it allows its users to configure settings in order to make searches more specific, and offers an attractive interface.

With the app having gained enough traction, Bing Image Search is now being integrated into 2016 versions of Microsoft Office as well as the Edge Web browser via "Ask Cortana."

When using Office, Image Search is accessible from "Insert>Online Pictures" from the ribbon at the top of the screen. In addition, you'll be faced with a grid consisting of thumbnails and filters, as well as the option to get more information about an image by hovering over it with your cursor.

After filtering the images, whether by size, type, color, license restriction, or something else altogether, you can select your image and insert it into the document simply by clicking on it.

With Edge, on the other hand, Bing Image Search is a little different. You can get to it either by right-clicking the "Ask Cortana" feature or by using Bing Lookup. While browsing the Web, you easily can find out more about an image by right-clicking and asking Cortana. Bing will, as a result, provide you with more details on the image such as its dimensions, the different sizes it's available in, related images/searches, and more.

The process of enabling Bing Image Search is easy, because it is in fact not a process at all. Just open a compatible version of Office or Edge for cheap Windows 10, and you'll quickly and conveniently gain access to the aforementioned slew of image-perusing features.

While it's by no means revolutionary, the addition of conducive features is certainly welcome. Nonetheless, I'm sure most of us would prefer to see the option to change search engines, as is typically the case with Bing.

Posted in News By SEO admin

Office 2010 is proving an invaluable tool for my holiday planning

Friday, September 9, 2016 6:20:40 PM America/Los_Angeles

The final day of my Office 2010 challenge is here at last. To be honest, I can't wait to grab the disc to install the full suite again. Using the Web Apps has had great benefits, but the majority of the online tools are surprisingly light on features.

However, reinstalling the full version of Office soon makes me realise what a powerful tool they are for portability, working on documents wherever you are. One of the best features of the Web Apps is the ability to use your Windows Live SkyDrive like a physical drive for your information.

This means your online storage drive looks and acts just like your C: drive, USB stick or Documents folder. You can drag and drop files from your desktop so they're available anywhere with an internet connection, and then they can be edited on the move, before being reloaded quickly into cheap Office 2010.

With this in mind, Office Web Apps has changed the way I'll use Microsoft Office forever.

Posted in News By SEO admin

Here’s some new stuff you get with Windows 10

Thursday, September 8, 2016 7:33:25 PM America/Los_Angeles

It’s a shame that Windows 8’s interface was so divisive. The UI dominated the conversation around the OS to the extent that its other, subtler changes got buried. People who stuck with Windows 7 never saw these updates at all.

Windows 10, as we’ve covered, is Microsoft’s effort to repackage Windows 8’s improvements in a way that will be more appealing to Windows 7 loyalists. As if to drive that point home, Microsoft is giving current Windows 7 users a whole year after launch to hop on the buy Windows 10 train at no charge.

Microsoft has made a bunch of changes to Windows in the last two years that have nothing to do with the new user interface. This list doesn’t have anything new on it, but if you’re still running Windows 7 and you decide to upgrade to Windows 10, it’ll be new to you, and you'll get to use it all without having to figure out how to live life without a Start menu. (If you're interested in seeing some of the UI stuff that you'll be sidestepping, ZDNet's Ed Bott recently published this piece about Windows 8 features that got cut from Windows 10).

1.Faster boot time

2.Better support for better screens

3.New class drivers

Posted in News By SEO admin

How Make starting up Windows 10 quicker

Wednesday, September 7, 2016 7:36:09 PM America/Los_Angeles

By default, Windows 10 will ask for the user's password every time the computer boots up. Although this is an example of security best practice, you may feel it's a touch unnecessary, particularly if your machine sits in a secure home office.

If you want to get rid of this safety precaution, click on the Search field next to the start menu and type 'netplwiz' and then press Enter. Untick the box next to 'Users must enter a username and password to use this computer', click apply and enter your password to finish up.

Be warned, however - this will disable all forms of login authentication, meaning that anyone will be free to use your PC. We would discourage anyone who handles sensitive or valuable information from doing this, and password requirements should never be disabled on laptops.

Make shutting down cheap Windows 10 faster

If you like to shut down your computer after a hard day's work, then you will realise that the process still requires three clicks. To speed this up you can use a shortcut. Simply right-click anywhere on a free part of the desktop then click New > Shortcut. In the Location field, type in the following.

%windir%\System32\shutdown.exe /s /t 0

Click on the Next to finish. Now each time you click on that shortcut, your PC will immediately shut down. Be careful though!

Disable Startup programs in Windows 10

Virtually every version of Windows allows you to disable startup items, and Windows 10 is no exception. Stopping some programs from starting up will speed up the OS.

To find this option, right-click the taskbar and choose Task Manager, and then click on the Startup tab. Here you can disable the programs you don't want to start up. Remove bloatware in Windows 10

No one likes bloatware (except PC manufacturers) but it does mean your system is slightly cheaper as a result. But you can ditch this crapware. For the most part, these are programs such as disc burning software, backup tools from the manufacturer or other utilities that you don't necessarily need.

Why programs such as PC Decrapifier and CCleaner do a sterling job of getting rid of bloatware, if you have a brand new (but bloatware laden) computer, then a clean install of Windows 10 could be the best way of clearing out unnecessary software clogging up your system.

Posted in News By SEO admin

Windows 7 Update is still a problem

Tuesday, September 6, 2016 7:21:38 PM America/Los_Angeles

Last time, I griped about Windows Update on Windows 7. Turns out, I left some gripes on the table.

Installing the most recent round of bug fixes, released May 10th, many experienced continued performance problems.

Despite installing the four recommended patches I wrote about previously, Windows Update still ran for a long time for me.

On one Windows 7 machine, after it had detected the missing patches, I clicked the button to install them, and waited. And waited. For what seemed like an eternity, the download process sat at zero percent complete (see above), while Process Explorer showed the CPU was busy running Windows Update.

As before, Woody Leonhard had a suggestion; install a single patch manually, before running Windows Update. The patch, KB3153199, was released this month. It comes in both 64 bit and 32 bit editions. I took Woody's advice and Windows Update ran much faster on subsequent machines. Thanks again, Woody.

But this illustrates an important issue with Windows Update - don't trust it.

The Defensive Computing approach is not not to install patches the day they are released. Too many Windows patches have caused too much grief over the years. Let others find the problems Microsoft did not.

Waiting a few days, gives Microsoft time to pull back or fix any bad patches. It also gives experts, such as Woody Leonhard, time to come up with workarounds to whatever issues crop up.

This approach translates to the settings shown above - Windows Update never runs automatically and recommend updates are not accepted.

Just last week, this would have saved Windows 7 users with Asus motherboards. As Woody Leonhard reported, Microsoft changed KB3133977 from an optional to a recommended patch. It's a long story, but the end result was that installing KB3133977 caused a Secure Boot Violation and Windows would not run.

Recommended updates also made news recently when Microsoft abused them to nag and/or install Windows 10 on machines running cheap Windows 7 and 8.1.

Brian Krebs has his own defensive strategy for Windows updates. Writing a few days ago, about the last batch of bugs fixes, he said

Posted in News By SEO admin

How to auto log in on wake up for windows 10

Monday, September 5, 2016 7:28:15 PM America/Los_Angeles

By default when cheap Windows 10 resumes from sleep mode a log in prompt is displayed, including a password prompt.

If you do not have a password or do not want to keep entering it – you can disable this feature using the steps below.

1.In the Windows search box, type ‘Power Options' and click on it when it appears in the list of results

2.In the left hand side, click on ‘Require a password on wake-up'

3.Click on the ‘Change settings that are current unavailable' link

4.Under ‘Password protection on wake-up' select ‘Don't require a password'

5.Click ‘Save changes' to save the changes.

Posted in News By SEO admin
clear