Spreadsheets are indispensable tools to us data geeks so I always keep an eye out for new ideas and tips in managing data using spreadsheets. I use many of the features and functions listed in the article and even inspired by a few I never thought of before! In the Related links below the first link is one of the most popular posts on infophile.
Spreadsheets get a raw deal. We are so dependent on tools like Excel and Google Sheets for managing budgets and P&Ls that it’s easy to fall into the trap of seeing spreadsheets only as applications for managing money, or at the very least, for working with numbers.
But the structure and features of spreadsheets make them so useful for a wider range of purposes, from project planning to writing. Breaking information or text into cells helps you break your work into bite-size chunks so you can find different ways of structuring it. The ability to sort and filter cells makes it easy to find, categorize, or reorganize lists or content. And yes, it’s nice to be able to do quick calculations when you are working with numbers. READ MORE: An Ode to the Underappreciated Spreadsheet | HBR
According to a 2015 study of more than 4,000 designers conducted by Subtraction.com and Adobe’s Khoi Vinh, 64 percent of designers still prefer pencil and paper to begin the creative brainstorm process.
Despite this, most companies continue to invest in digital drawing. Apple, Wacom, FiftyThree and others continue to design innovative hardware and apps, such as the iPad Pro and Bamboo Paper, to enhance performance and increase speed while on the go. Are the efforts to bring digital deeper into the creative workflow all in vain?
The answer, as you might suspect, is no. Digital will never be a paper killer, but hardware and apps leveraging the latest technology advances are closing the gap with undeniable benefits in accessibility, efficiency and artistry. READ MORE: The Benefits Of Digital Drawing | TechCrunch
Modern work — from waiting tables to crunching numbers to designing products — is about solving brand-new problems every day, flexibly and collaboratively. But as Yves Morieux shows in this insightful talk, too often, an overload of rules, processes and metrics keeps us from doing our best work together. Meet the new frontier of productivity: cooperation.
When writing business documents (aside from emails), most people turn to word-processing software. That’s not the only option. You can do everything — outlines, drafts, revisions, and even layouts, if you’d like — in PowerPoint or similar presentation programs. That’s what I’ve used to write my books, internal documents, sales collateral, and web copy, for several reasons. READ MORE: Why I Write in PowerPoint | Harvard Business Review
Raise your hand if you like sitting through slide-show presentations. How about reading dense, jargony business documents? These are the staples of modern business communication, and yet they’re enjoyed by precisely no one. Enter Nancy Duarte, CEO of Duarte Design. Duarte thinks she can redesign business communication with Slidedocs, a new concept she defines as “a visual document, developed in presentation software, that is intended to be read and referenced instead of projected.” Think of it as a kind of a hybrid between slide-show presentations and prose documents—but one that eliminates the most annoying qualities of each. Duarte’s new book on Slidedocs, which she wrote entirely in PowerPoint, has just been released as a free download on her website. READ MORE: Book Written Entirely In PowerPoint Aims To Reinvent How Businesses Communicate | FastCompany
If it wasn’t already clear through common sense, it’s become painfully clear through science that sitting all day is terrible for your health. What’s especially alarming about this evidence is that extra physical activity doesn’t seem to offset the costs of what researchers call “prolonged sedentary time.”
In response some people have turned to active desks—be it a standing workspace or even a treadmill desk—but the research on this recent trend has been too scattered to draw clear conclusions on its benefits (and potential drawbacks). At least until now. A trio of Canada-based researchers has analyzed the strongest 23 active desk studies to draw some conclusions on how standing and treadmill desks impact both physiological health and psychological performance. READ MORE: Everything Science Knows Right Now About Standing Desks | Co.Design | business + design.
Microsoft and Dropbox are expanding their already close partnership with the reveal of a new integration that will now allow consumers to edit their Microsoft Office files, including Word, PowerPoint and Excel documents, in Dropbox using Office Online via the web.
Previously, many of these edits would have taken place using Microsoft Office’s desktop applications – which also meant that you would have to be at a computer where the software was installed. The online option makes the service more flexible, as you can edit your files from any computer, including a borrowed machine or a shared computer, like a business center’s kiosk PC, for example.
To use the new feature, you’ll click the “Open” button when you’re previewing the file on the web, Dropbox explains, and then you’ll have the option to edit the file from your web browser using Office Online. The option is available to Dropbox for Business customers who have an Office 365 license as well as Dropbox Basic and Pro users, and those who are on the free tier of Office Online. The only requirement for using the free tier of Office Online is creating a free Microsoft account, the company says.
The number of college students taking at least one online course has nearly doubled over the past five years according to a report by market research agency Refuel.
Online students are often faced with the challenge of juggling their academic responsibilities alongside families or full-time jobs, which is certainly no easy task.
Technology can help students better manage their learning by providing everything from study aids and research tools to time-management apps, so it’s somewhat surprising to learn that few students are actually using such tools for learning purposes.
The majority of students use online and mobile apps primarily for entertainment according to the Refuel report, with over 70% using them for games, 67% using them for music, and 64% using them for social networking.
If you want to encourage your students to start taking advantage of the many technology tools available to them, here are a few examples of the types of productivity and learning apps that can support them in their studies.
There’s that project you’ve left on the backburner – the one with the deadline that’s growing uncomfortably near. And there’s the client whose phone call you really should return – the one that does nothing but complain and eat up your valuable time. Wait, weren’t you going to try to go to the gym more often this year?
Can you imagine how much less guilt, stress, and frustration you would feel if you could somehow just make yourself do the things you don’t want to do when you are actually supposed to do them? Not to mention how much happier and more effective you would be?
The good news and its very good news is that you can get better about not putting things off, if you use the right strategy. Figuring out which strategy to use depends on why you are procrastinating in the first place…
Is your life a hotch-potch of missed deadlines, forgotten shopping and reneged commitments? Sounds like you need to get organized. Where better to start than with hard numbers and figures? For this, you might want to take advantage of the many spreadsheets available on Vertex42 that allow you to keep track of your time, belongings, projects and money. Here are 10 of the best.