Tagged With spreadsheets

0

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.

7

Spreadsheets were one of the first "killer apps" of the PC age. They enabled desktop computers to move from being glorified typewriters and toys into an essential business tool. Now, a Silicon Valley start-up is changing the face of the spreadsheet, bringing it forth to the 21st century.

0

In my first post-university employed position, I worked for a boss who loved Excel spreadsheets. She thought nearly everything could be put into "boxes and rows", and after my first year working there, I was officially a convert. I'm big on organisation anyway, and those spreadsheet cells called to me, luring me in with their promises of order and clarity. Event planning logistics? I had a spreadsheet for that. Airline and hotel reservations for the office directors? Spreadsheet. Goals for the new fiscal year? Spreadsheet.

0

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.

1

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.

1

Excel has a bit of a reputation for being a tedious and fiddly pain in the arse. However, most of its foibles come down to user error. If you take the time to learn these 200 keyboard shortcuts (or just print out this cheat sheet) your life among the spreadsheets will become far rosier.

0

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.

0

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.

0

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.

2

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.

2

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.

0

Spreadsheets are a nerd's data-driven dream. For most regular people, though, they're a complicated mess. Fortunately, they don't need to be. Here's how to bend data to your will with Microsoft Excel 2016.