Even if you use Microsoft Excel regularly, there's a fair chance you might not be getting as much out of it as you can. Improve your Excel efficiency and proficiency with these basic shortcuts and functions that absolutely everyone needs to know.
Tagged With spreadsheets
In a new piece on The Cut, writer Moira Donegan reveals that she created the "Shitty Media Men" list, the anonymous collaborative Google Sheets spreadsheet naming prominent men in media who have assaulted, harassed, or otherwise used been shitty to the women they work with. The list went viral overnight and helped end, or at least interrupt, the careers of several sexual harassers.
Predicting the future is near impossible -- but that doesn‘t stop us all from having a red hot go. Human beings have been predicting the future since the beginning of history and the results range from the hilarious to the downright uncanny.
One thing all future predictions have in common: they‘re rooted in our current understanding of how the world works. It‘s difficult to escape that mindset. We have no idea how technology will evolve, so our ideas are connected to the technology of today.
Microsoft Excel is packed with useful data management features that don't see a lot of use, like pivot tables, index and match, and conditional formatting. If you're just using excel to sum and chart columns, this graphic can show you some other tools to help you become the spreadsheet ninja you always wanted to be.
If you're playing buzzword bingo out there, you can check AI off from your cards for about the billionth time this year. Google continues to find ways to integrate AI with changes made to their spreadsheet app Sheets. The software has been updated with AI that looks at your data and makes suggestions, by using "machine intelligence", on how to best analyse and visualise your data.
There are some excellent time-tracking apps out there, but if you prefer the comfort of good old Microsoft Excel, here's some good news. A Redditor made an Excel-based to-do list with built-in time tracking, and the template is free to download.
Web/Android: If you use an online app like Google Docs then you've long been accustomed to having multiple people collaborate on the same document or spreadsheet at once. Microsoft Excel is finally taking a step into this brave new world of simultaneous editing and adding the ability to co-author spreadsheets.
This video, from the always-great LinusTechTips, is perfect if you're upgrading or building a gaming PC before the end of the year. The beginning is a straightforward rundown of which video card you should buy, and after the TLDR section is over, the nitty gritty of price-to-performance comes in.
This week, the world celebrated Spreadsheet Day, AKA the most boring holiday devised by humankind. But wait! If you hate spreadsheets and everything they stand for, it probably means you don't know how to use them properly. Here are our most useful spreadsheet hacks for Microsoft Excel and Google Sheets; suitable for novices and experts alike.
Shopping for an Intel processor is no joke. There are enough that it can be confusing to buy the right one for your needs, whether you're gaming, working, doing video editing, need something you can overclock, and so on. Luckily this video and spreadsheet -- from Linus of LinusTechTips fame -- breaks it all down nicely.
If you've mastered the basics of Microsoft Excel and you're looking to boost your spreadsheet skills, this visual guide explains some useful tips and shortcuts you may not have tried.
Data and Microsoft Excel spreadsheets go hand in hand. Certainly, data analysts have a love affair with Excel, but other people in their organisations may not be so keen on it. While spreadsheets are useful for documenting data on business performance, they may alienate a number of employees from knowing what's going on within their companies. Here's why this matter.
Many of us live and die by our spreadsheets, but every true spreadsheet ninja has to start somewhere. These helpful, Excel shortcuts can help you save time and get more done. From highlighting every cell at once to quickly copying formulas, they're a refresher for experts and worth remembering for beginners.
An oldie but a goodie, this little titbit was much appreciated when it was first posted back in 2012, so I've dug it out of the archives to share with a new generation of Excel wizards. While Excel (still) has no way to natively sort a list randomly, it's a pretty easy process with a few short steps.
If you're new to using Microsoft Excel, or you're an experienced user looking for a good visual reference, this handy cheat sheet covers eight helpful tricks for becoming a spreadsheet pro. The infographic explains how to use absolute and relative references, how to use the ampersand and combine cells, organise your spreadsheets with cell colouring, how to use the VLOOKUP function and more.
When it comes to productivity on the go, Android has come a long way. You now have plenty of options to stay productive on your phone or tablet. While the best will cost you money, you can get respectable features for free. We think MobiSystems' OfficeSuite 8 is the best overall option for Android, but we have more options if the price tag scares you.