direct tag

direct tag

direct tag

direct tag

direct tag

How to check for hard-coded values in Excel formulas?

Here is a common problem. Imagine you are looking a complex spreadsheet, aptly titled “Corporate Strategy 2020.xlsx” which as 17 tabs, umpteen formulas and unclean structure. Whoever designed it was in insane hurry. The workbook has formulas like this, =SUM(Budget!A2:A30, 3600)+7925 .

It was as if Homer Simpson created it while Peter Griffin oversaw the project.

So how do you go about detecting all cells containing formulas with hard-coded values? Continue reading

direct tag

direct tag

Don’t Work From Your Inbox

5830444338_a8f3d62c43_m

When people have email lingering in their inboxes, there is generally one reason why. It’s not because they aren’t opening the emails, or because they’re not realizing they have to do something with the email.

It’s because they are trying to work from their inboxes.

This is a really bad idea, and today we will look at why people do it, and what should be done instead.

The post Don’t Work From Your Inbox appeared first on Simple Productivity Blog.


More great content can be found on the site at Simple Productivity Blog., or you can find me on Twitter (@SmplProdBlog) and Facebook (Facebook.com/SimpleProductivity).


Continue reading

direct tag

direct tag

8 Reasons you must get better at Excel in 2015

This is a guest post by Sohail Anwar

Why do so many of us use Excel? Let’s trace it back to the ’80s when Microsoft hit gold by being the first out of the blocks with the widely available operating system that was somewhat dummy proof.

Suddenly everyone could aspire to launch ‘Nukes’ like a fresh faced Matthew Broderick in the film ‘War Games’. 

By the early 90’s Windows had become even more established relative to other Operating Systems, so much so that PC manufacturers were developing components around Windows’ capabilities and suddenly PCs were Windows machines. As big business began accepting the significance of computing, Microsoft started winning huge licensing contracts with all the major corporations in all sectors, but the Finance sector in particular, where Excel would be king, was having an exponential boom at this time. For big organisations, once you spent a fortune buying licences for the Operating System it only made sense to purchase the seamlessly integrated and carefully developed/tested apps to run on them; enter Excel, Word, PowerPoint and eventually Outlook. Fast forward to 2015 and we are firmly in the age of second generation corporate professionals who have developed much of their productivity skill sets around those particular Windows tools. While all the excellent tools have their place, Excel stands out and here are 8 reasons why you need to up your Excel game more than ever this year. Continue reading

direct tag

direct tag

Open Loops 1/9/2015

On Fridays I pull the best of my blog readings to share with readers. Topics can come from anywhere, and cover anything.
This week I highlight articles on making daily unpleasantness less unpleasant; wrist wrests and the damage they do; how to cut cabl… Continue reading

direct tag

direct tag

direct tag

direct tag

CP027: 15 proven strategies to be awesome in 2015

In the 27th session of Chandoo.org podcast, let’s pave way for an awesome 2015.

We are going to talk about 15 proven strategies for making you awesome in Excel & Your work.

What is in this session?

We all get fresh dose of energy, enthusiasm & drive during new years. So we aim for bigger & more awesome things. But once the first few weeks are over, we just settle down to the normal rhythm and forget about these big, hairy & audacious goals.

Let’s make 2015 different. In this podcast, Let’s understand how you can become awesome in Excel & your work this year, with 15 proven strategies:

  • Announcements – my new year & plans for next few months
  • Becoming awesome – 3 important areas of focus
  • Learning
    • New formulas
    • New features
    • Different charts
    • Macros
    • Linkup Excel with other software
    • Get a book
    • Join a course
  • Application
    • Take up a work project
    • Consulting
    • Mimic a chart in Excel
    • Beyond XL – Power Pivot etc.
  • Sharing
    • Forums
    • Helping a colleague
    • Comment on blogs
    • Train your team

Continue reading

direct tag

direct tag

Guest Post at Productive Super Dad

LJontheweb

Check out my latest guest post over at Productive Super Dad: The Rules Of Email Productivity In this article I talk about the 5 Cardinal Rules of Email Productivity: Process your email without taking action Don’t work from your inbox Have things delivered to your inbox Make a magazine pile Unsubscribe from what doesn’t bring […]

The post Guest Post at Productive Super Dad appeared first on Simple Productivity Blog.


More great content can be found on the site at Simple Productivity Blog., or you can find me on Twitter (@SmplProdBlog) and Facebook (Facebook.com/SimpleProductivity).


Continue reading

direct tag

direct tag

direct tag