icon_hacks_b Created with Sketch. Garage Blog

Step Up Your Microsoft Excel Game With These 11 Hacks

We all have a friend or two who work in finance with mean spreadsheet skills. They whiz through without ever touching their track pad, selecting and shifting cells faster than your mind can process. Even if your job doesn’t call for mean MS Excel skills, it’s impossible to deny that it’s among, if not the most important computer programme in the workspace. From budgeting to organising client lists, Excel is powerful and takes years to master. Get started with our 11 simple tips, which we guarantee you’ll incorporate in no time at all. ***Don't forget to check out last week's 13 Microsoft Word Hacks You Need In Your Life, and stay tuned for the final of our 3-part series next week: hacks for Powerpoint!

  1. Add multiple rows at once by highlighting the number you want to add in the preexisting rows, right click, and select “Insert”
  2. Remove duplicated information by selecting the column, and selecting ‘Remove Duplicates’ under ‘Data’
  3. Transpose your information (change data in a row into a column or vice versa) by highlighting and copying the data, select the area you want to transpose it to, right click, select ‘Paste Special’, and choose ‘Transpose’
  4. Split information in one column into two (e.g. when you want to alter the data set of people’s names into two columns of first and last names) by highlighting the column, select ‘Text to Columns’ under ‘Data’, choose ‘Delimited’ or ‘Fixed Width’ based on your information, and Finish
  5. Create a Conditional Formatting formula (e.g. assign a colour to the top 10% of your data) by highlighting the information, select ‘Conditional Formatting’, and choose the conditions
  6. Input values starting with 0 by including a single quote (‘) before the number (e.g. ‘00098)
  7. Select the entire column by using Control + Spaceselect the entire row by using Shift +Space, and select cells as you scroll by holding down Shift
  8. Change numerical data into percent by highlighting the information and using Control + Shift + %
  9. Insert the current time into a cell by using Control + Shift + : (Colon)and Insert the current date into a cell by using Control + Shift + ; (Semicolon)
  10. AutoFill a series of data by inputting the first 2 cells and dragging the information to the selected cells
  11. Calculate a column of data (e.g. dividing a column of data by 2) by copying a cell with the number two, highlight the column you want to calculate, right click ‘Paste Special’ and select ‘Divide’
similarposts
icon_hacks_b Created with Sketch. Garage Blog Sustainability, Social Entrepreneurship, and the Joys of Growing Your Own Food: Q&A with Michelle from Rooftop Republic

As part of our #BeTheChange series, we sit down and discuss how people and business have evolved, with change-makers in our Garage Community. 

 

This week, we sit down with Michelle Hong, co-founder of Rooftop Republic, a social enterprise on a mission to introduce the joys of urban farming to the city folk of Hong Kong.

 

Rooftop Republic has been part of the Garage Community since 2018, and they have a rooftop farm on the terrace of our Wan Chai Lockhart space.

 

It was great to catch up with Michelle over sustainability, social entrepreneurship, and the joys of growing your own food. 

icon_hacks_b Created with Sketch. Garage Blog 6 Ways To Support Small Businesses

The advent of user-friendly e-commerce tools has made starting your own small business easier than ever.

With so many people embarking on their entrepreneurial journey, we thought we’d give you a reminder on how to support small, local business owners. 


We encourage everyone to be conscious consumers - whether this means voting with your dollar for locally farmed vegetables, or writing a positive review for the indie coffee shop in your neighbourhood.

 

Here are a few ideas to get started: 
 

icon_hacks_b Created with Sketch. Garage Blog Your 4-Step Wellbeing Toolkit

As part of our focus on growth, we asked the Garage Community what areas they would like they spend more time developing. It was very clear that you all wanted to dedicate more time to your mental and physical health! 

 

Considering that Hong Kongers have some of the longest working hours in the world, it’s important to carve out some time for yourself.

 

Here is a comprehensive wellbeing toolkit with guides, recommendations, and resources for bettering your mind and body. 

 

Want to take part in this month's Community Survey? Click here.