All posts tagged: saves

Your Pivot Tables are okay, but rebuilding them this way takes 5 minutes and saves hours

Your Pivot Tables are okay, but rebuilding them this way takes 5 minutes and saves hours

Published by skeptic

Pivot Tables in Excel are fine, right? They get the job done, but only until the moment you need to tweak the layout, add a new field, refresh the numbers after a new data dump arrives. Before you start scrambling through Excel’s UI, clicking through dozens of dialog boxes and dragging fields around hoping you don’t break something, know that there’s a better way. Excel has hundreds of built-in formulas that let you do anything from simple arithmetic to, you guessed it, building Pivot Tables. And now that Excel can write its own formulas, there’s no reason why you shouldn’t be using its PIVOTBY function to rebuild the same summaries in minutes instead of hours. Related Excel finally fixed its biggest data entry problem, and it’s a lifesaver One click in the Data tab can catch almost all issues. Stop clicking—build Pivot Tables with formulas A faster, more flexible way to create dynamic summaries Yadullah Abidi / MakeUseOf First introduced in Excel for Microsoft 365, PIVOTBY is a dynamic array function that produces essentially the …

Leno saves Fulham in goalless West London derby at European hopefuls Brentford

Leno saves Fulham in goalless West London derby at European hopefuls Brentford

Published by Sam Flores

April 18 : Goalkeeper Bernd Leno kept alive Fulham’s faint European hopes with a standout 90th-minute save in a goalless Premier League clash at high-flying rivals Brentford on Saturday. A West London derby that could have turbo-charged either side’s hopes of a place in European competition ultimately fell flat at the Gtech Community Stadium. Brentford, now on five successive league draws for the first time since 1957, missed a chance to leapfrog Chelsea for sixth place while Fulham stayed 12th pending later fixtures after a game they really needed to win. Only six points separate Chelsea (48) and Newcastle United (42) in 14th place, with Brentford and Fulham (45) having five matches remaining and most of their rivals still with a game in hand and everything to play for. Brentford, now level on points with Chelsea but with an inferior goal difference, could have nicked the three points but for Leno’s brilliant effort in keeping out Dango Ouattara as the clock ticked into stoppage time. Leno had not had much to keep him busy until …

This Android shortcut saves me hours every week, and almost nobody knows it exists

This Android shortcut saves me hours every week, and almost nobody knows it exists

Published by skeptic

I’ve spent 15 years writing about mobile operating systems. Yet I still get that “eureka” moment when I find a toggle I’ve ignored for three hardware cycles. It’s usually tucked away in a sub-menu with a boring name like “Gestures.” I scroll past it a dozen times before finally tapping it and wondering how I ever lived without it. Quick Tap was exactly like that for me. I enabled it on a whim, fully expecting to forget about it within a week. Instead, it became one of the first things I set up on my Pixel 9 Pro XL. I’ve done the same on every Pixel I’ve tested since then, including older ones. Most Android users I know have never heard of it. Some have carried a Pixel for years and still haven’t stumbled across it. That’s the thing about Android: it hides its best stuff just far enough off the beaten path that most people never find it. Here’s what I reach for every day, and a few others worth turning on while you’re …

This simple email trick saves me from annoying marketing spam (and it’s free to do)

This simple email trick saves me from annoying marketing spam (and it’s free to do)

Published by skeptic

Kerry Wan/ZDNET Follow ZDNET: Add us as a preferred source on Google. As a Gen-Z shopping editor, I spend most of my dollars online. I’m always looking for easy ways to save with promo codes, sign-ups, memberships, and more.  I’ve also written full guides on how I’ve saved over $500 using services like Rakuten. But most importantly, after covering numerous sale events like Black Friday and Prime Day, I’ve learned how to avoid the deluge of spam that usually follows signing up for coupons or free shipping.  Also: 3 money-saving tricks I use every time I shop online – and you should too That’s why I’m sharing one of my favorite email tips that helps put marketing, ads, promotions, and other salesy emails in your rearview. This first tip is so obvious, you’ve probably never thought twice about it before. I’ve been using this shopping tip for almost a decade, and it’s still as functional as ever. Plus, it’s totally free.  How I decrease marketing clutter in my inbox So, you want to know the easiest way to …

Your Old Fridge Is Costing You. Here’s How Much Energy a New Model Saves Each Year

Your Old Fridge Is Costing You. Here’s How Much Energy a New Model Saves Each Year

Published by skeptic

New, more energy-efficient appliances may cost you at the register, but the savings tend to catch up over time. Most people think of heat pumps or solar panels when they hear “long-term energy-saving investment,” but your refrigerator quietly makes the same case.  Newer models use considerably less electricity than those from even 10 years ago, and that gap in energy use translates directly into lower utility bills. I wanted to put an actual number on it, so I did a ton of math, analyzing 2,630 fridges and their Energy Star data to compare today’s models to those from 2016. (While I didn’t calculate the energy delta for fridges older than 2016, it’s almost certainly greater.)  Here’s how much energy and money you could save by making the switch. Where my fridge data comes from Publicly available Energy Star data is a major player in this analysis. Screenshot by John Carlsen/CNET For my 2025 samples, I analyzed energy usage in modern Energy Star-certified models. For 2016, I couldn’t rely on Energy Star data because it lists only models that meet the most …

RSPCA saves 250 poodle-cross dogs from filthy house

RSPCA saves 250 poodle-cross dogs from filthy house

Published by Sam Flores

The RSPCA rescued more than 250 poodle-cross dogs that were kept crammed inside a breeder’s home. Many were found covered in dirt, and dozens had skin sores and matted coats. Photos from the house in Nottingham show the poodle-crosses pressed up against each other as they fought for space in the cramped living room. Several had been sleeping in a wood-burner in the fireplace while others cowered under a table in the tiny living space. RSPCA rescuers were tipped off about the property by concerned neighbours. The charity said the dogs had been over-bred, allowing their living conditions to “spiral out of control”. The animal welfare charity took 87 of the dogs to its Radcliffe Animal Centre in Nottinghamshire and the rest were taken by Dogs Trust, which rescues and rehomes animals. Two of the rescued dogs – Stevie and Sandy – have formed a close bond and will be rehomed together – RSPCA There were rumours that images from the house had been generated using AI. However, Jo Hirst, an RSPCA superintendent, said: “We …

Maybe robots SHOULD steal some jobs: firefighting ‘bot saves lives

Maybe robots SHOULD steal some jobs: firefighting ‘bot saves lives

Published by skeptic

Hyundai announced the unimaginatively named Unmanned Firefighting Robot last week – but this life-saving robot isn’t just a futuristic concept. The first operational unit was donated and deployed at the National Fire Agency, where it hopes to prove that there are some jobs robots should take from humans. Hyundai believes its Unmanned Firefighting Robot can save human lives by being preemptively deployed to active fires and other high-risk scenes that are especially dangerous to humans due to risks of collapse, explosion, high temperatures, toxic gas, or dense, acrid smoke. The robot’s on-board AI works with remote operators to identify and assesses the scene upon its arrival, approach the fire’s source, and work to directly extinguish the blaze. By tackling dangerous situations in place of people, Hyundai’s robotic firefighter ultimately saves more lives by going into hotter, more dangerous fires sooner, and helps more first responders find their way home. To that end, Hyundai has baked a number of advanced technologies into its new robot that cover the full range of automotive ADAS we’re familiar with, but …

Specialist palliative care saves NHS thousands and improves lives

Specialist palliative care saves NHS thousands and improves lives

Published by skeptic

Specialist palliative care has the potential to reduce costs by up to £8,000 per person and improve quality of life, according to new research published in Palliative Medicine. Led by researchers at King’s College London, the research considered two modes of palliative care for those living at home and for those in acute hospital settings. As well as significantly reducing the overall cost of care per person, specialist palliative care delivered at home and in the hospital was associated with improved quality of life for patients in their final months. Peter May, Senior Lecturer in Health Economics at King’s College London and lead author of the study, stated: “This is the first study to estimate the economic impact for England. “About half of the people who might benefit from specialist palliative care receive it, and this is highly cost-effective for both patients and the NHS.” Unplanned hospital admissions lead to higher costs In high-income countries, about 1% of people die annually, but this group accounts for 8-10% of all healthcare spending. This high cost is …

History made as robot saves Brit’s life – controlled 1.5k miles away | UK | News

History made as robot saves Brit’s life – controlled 1.5k miles away | UK | News

Published by Sam Flores

Mr Dasgupta controlled the robot in Gibraltar using a console at his London clinic (Image: PA) A surgeon in London has operated on a patient with prostate cancer 2,400km away in Gibraltar, in the first UK remote robotic surgery. Patient Paul Buxton, 62, who is originally from Burnham-On-Sea in Somerset, moved to Gibraltar 40 years ago. He said it was a “no-brainer” to be involved and he was happy to be the “guinea pig”. Mr Buxton added: “A lot of people actually said to me: ‘You’re not going to do it, are you?’ I thought, ‘I’m giving something back here’. I love football — we’ve literally gone from being in the Championship to the Champions League as far as surgeons are concerned.” The only hospital in Gibraltar is St Bernard’s at Europort. Patients with more complex problems usually have to travel further afield, including to the UK for those needing NHS care. Read more: UK health chiefs share update on horror Victorian disease outbreak in London Read more: Warning issued over new shortage of common …

The Trump Administration Is Ending Aid That It Says Saves Lives

The Trump Administration Is Ending Aid That It Says Saves Lives

Published by Sam Flores

A year after the Trump administration began the dismantlement of USAID, it is initiating a new round of significant cuts to foreign assistance. This time, programs that survived the initial purge precisely because they were judged to be lifesaving are slated for cancellation. According to an internal State Department email obtained by The Atlantic, the administration will soon end all of the humanitarian funding it is currently providing as part of a “responsible exit” from seven African nations, and redirect funding in nine others. Aid programs in all of these countries had previously been up for renewal from now through the end of September but will instead be allowed to expire. Each of them is classified as lifesaving according to the Trump administration’s standards. The administration had already canceled the entire aid packages of two nations, Afghanistan and Yemen, where the State Department said terrorists were diverting resources. The new email, sent on February 12 to officials in the State Department’s Bureau of African Affairs, makes no such claims about the seven countries now losing …