We’re using Excel 2010 here, but it’s the same process in any version of Excel since only basic fomulae are used. While you could tap in the figures on a calculator, Excel allows you to calculate percentages on multiple figures extremely quickly. How to calculate percentages in Excel When you have the amount and total If you have a total, and you want to calculate the percentage of a certain amount below this total, here’s the calculation: Amount / total = percentage We’ll use the UK referendum figures for this example....

The good news is that it is possible to change skin in Minecraft, but the process differs slightly between platforms. Here, we talk you through how to change skin in Minecraft on PC, on console and on mobile. Changing skins in Minecraft on PC The process of changing skins in Minecraft on PC is easy once you know how: Once the custom skin has been uploaded, it’ll automatically be applied to your character in Minecraft on your PC....

There is a way to change the system font in Windows 10, but it isn’t easy and can be risky if not done correctly. But follow the steps here and you’ll be able to safely and easily get rid of Segoe UI and replace it with your favourite font. First, you’ll need to copy the text below into a new Notepad file: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionFonts] “Segoe UI (TrueType)”=”” “Segoe UI Bold (TrueType)”=”” “Segoe UI Bold Italic (TrueType)”=”” “Segoe UI Italic (TrueType)”=”” “Segoe UI Light (TrueType)”=”” “Segoe UI Semibold (TrueType)”=”” “Segoe UI Symbol (TrueType)”=”” [HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionFontSubstitutes] “Segoe UI”=”New font name” Obviously, don’t copy New font name, but replace that text with the precise name of the font you want to use....

Converting an existing Word document into a PDF is easy, and we’ll show you how to do it. Of course, if you want to format files in the opposite directions then be sure to read out How to convert PDF to Word for free guide. How do I convert a Microsoft Word file to PDF? One of the quickest ways to reformat a Word file is to use Microsoft Word itself....

With the software heavily relied on for effective remote working, Microsoft has added a number of features in recent months which aim to improve video calling functionality. Some aim to make the virtual meeting experience more immersive, while others add a touch of fun to spice up the regular speaker and gallery views. Use Together Mode In-person meetings can take place in a wide variety of locations, but the virtual equivalent typically hasn’t reflected that....

You can create a dual-boot system from pretty much any version of Windows, but here we will add Windows 10 to a PC running Windows 7. (Note that Windows 7 is now end of life, so we do not recommend you run the OS any longer.) What do I need to dual boot Windows? Obviously you’ll need a copy of Windows to install, and this needs to be burned onto a CD or written to a USB memory stick....

We’ve got some guides on how to be safe online and how to remove ads in Windows 10 too, so if you’re a regular user you might want to have a look. Check your Windows sound settings It’s best to check the basics before we start to move on to the more complicated fixes, so humour me for a moment and make sure that your Windows sound isn’t muted. Right click on the speaker icon at the bottom right of your screen, and then hit ‘Open volume mixer’....

There are a couple of ways to easily add this to your prose and we’ll show you the steps you need to take. Using the number pad on your PC There are a number of superscript symbols available in Windows, far too many in fact for them to have dedicated buttons on a keyboard. To summon them you can use an ‘character code’ allocated to each individual symbol. For this technique to work you’ll need to have a number pad on your keyboard....

One of the greatest challenges facing parents these days is how to ensure that their children remain safe online. With so many kids now having tablets, smartphones, or PCs of their own, it’s increasingly difficult to know what content they access and who they’re meeting on the web. A study by the Oxford Internet Institute (OII) at Oxford University revealed that of 515 interviewed 12- to 15-year-old children, 14 percent had had a ‘negative’ online experience , 8 percent had been contacted by strangers, almost 4 percent had seen someone pretend to be them online, 2 percent has seen sexual content that made them feel uncomfortable, and three percent had seen something that scared them....

Although some of those – notably Spotify – had a free tier, that wasn’t supported on smart speakers. Beyond streaming services there are other options for listening to music, such as radio stations and podcasts. Here’s what you need to know about getting Alexa to play music for free, and the limitations you can expect to face. How to link a music service with Alexa It’s the same basic process to use any of the services mentioned here....

YouTube is one option which springs to mind, but most people think the only alternative is to illegally stream TV shows and films from the many pirate and torrent sites on the web. The content may not be as up to date or wide-ranging as the shows and movies on the paid-for streaming services, but there’s still plenty to like – even if you do have to put up with watching a few adverts....

On the face of it, Windows 10’s October 2020 update makes a number of useful tweaks, and there are relatively few known issues at the time of writing. However, that doesn’t always make for a better user experience. If you’re regretting upgrading and would rather go back to the previous version, you’ll be glad to hear there’s an easy way to do just that. The only potential catch is that it’s only available for 10 days after updating....

Every laptop has RAM slots and depending upon the configuration you’ll need to check that these are empty. For example, if your laptop has 2GB of RAM and two memory slots each filled with 1GB RAM chips you’ll need to remove at least one of these to upgrade. If you do have a spare slot you can simply slot the new RAM in without removing the existing RAM. Installing more RAM is an incredibly simple operation, but there are a few precautions you should take before upgrading....

To try out Smart Compose you need to be running the new version of Gmail on a PC or laptop. Tap the Settings cog at the top right and choose ‘Try the new Gmail’. You also need to enable experimental access in Gmail. Again tap the Settings cog icon, then choose Settings. On the General tab scroll down to and enable Experimental Access. Click Save changes at the bottom of the page....

We’re not disputing that the standard console controller is great for casual gaming, but it simply can’t offer the precision and ease-of-access to functions as what is provided by gaming keyboards and mice. Anybody that has tried to play an online FPS on PC with a controller will know exactly what we’re talking about! Besides, when was the last time you saw a major eSports player using a controller when keyboard and mouse are available?...

Microsoft doesn’t always broadcast its conferences which is a shame, but it will let you watch its conference in Barcelona. Best in Show – See our MWC 2019 Award Winners! When is Microsoft’s MWC press conference? The event is on Sunday 24 February and will start at 18:00 CET, so that’s 5pm in the UK or 12am ET if you’re in the US. Where can I watch the HoloLens 2 live stream?...

Bethesda’s annual celebration of its games – initially Quake of course, but now with a bigger focus on the likes of DOOM, Fallout, Elder Scrolls, and more – always features a host of tournaments, giveaways, livestreams, and game reveals. Last year the company had plenty to announce at the show, so we’re hoping for a similarly big spectacle when it kicks off later this year. And the best news is that Bethesda says that it’s “committed to returning with our full in-person festival in 2023,” meaning this should be the last year that QuakeCon stays online....

The 24th Winter Olympics take place in Beijing, China. Team GB are around fifty members strong, whilst Team USA boasts over 200 athletes. Hopes are high for more medals to be brought home by both countries after successful runs in Sochi 2014 and Pyeongchang 2018. When do the Bejing 2022 Winter Olympic Games take place? The official dates for the Winter Olympics games are 4 – 20 February 2022, although the curling did start 2 February, two days before the official opening ceremony....

The competition was paused for six weeks to accommodate the winter World Cup in Qatar, but its return coincides with a full schedule of festive fixtures. However, things aren’t quite as hectic as we’d usually see around Christmas and New Year. But with 19 live matches in the UK between 26 December and 5 January, there’s plenty to look forward to. Here’s everything you need to know about watching the Premier League live, including if you’re based elsewhere....

Europe’s largest gaming show takes place this week in Cologne, Germany, with the big press conferences. Microsoft’s Xbox briefing starts at 1pm Brutish summer time and even if you can’t be there in person you can still get all the news and announcements as they happen. If you’re interested in watching the live video stream (in your lunch break?) then simple enjoy it at the top of this page. Alternatively, you can watch the stream on your Xbox or with the Windows Phone app....