Many times when we analyze data, we have some textual, or categorical variables. For example, we can have small, medium and big. Or we can have gender as male and female. Many times our data can use Yes and No as an answer. So, it becomes problematic to analyze such categorical data because we can not perform arithmetic on them. For this purpose COUNTIF function in Google Sheets can be very useful.
Before some period of time, I have an interesting conversation with an entrepreneur. While we discuss, I noticed a sheet of paper before him with activities for that day. Those that were finished were crossed with a pen and at the moment when I arrived the last one was not completed and still in progress. It is a To-Do list, something that makes each of us more organized and more productive allowing the completion of all activities for the current day.
I have frequently asked this question in the past, and even now it sometimes comes to my mind. Do we have too little time to do everything that we want to do?
Why such a question?
Because in the past, every day when I go to my work and look at my to-do list, I see 50 to hundreds of tasks. There were tasks even before several months I put on the list.
When I analyze data, many times, I need to group different data source one with another. In such a situation, there is a need for playing with large datasets. One of the functions that I use in many cases to make my data clean when combining different data sources is the UNIQUE function in Google Sheets. This is one of the simplest functions.
I am a big fan of Alfred app for Mac. For the last four years, there is not a day in my life to use this app without a minimum once. With Alfred workflows, I can not say how much time I have saved in this period. This means increased productivity, efficiency and effectiveness when I work on my computers. Here I would like to share five best Alfred Workflows (according to me) that I use the most in my daily working routine.
What happens tomorrow. Let’s stop for a moment and think about tomorrow. Are you already planning your tomorrows? What do you have to do for tomorrow? Is tomorrow simply your busiest day for the whole week? How can you manage your time effectively tomorrow?