• Our team 7
  • Blog / News 280
  • Garage commons
  • Hong Kong 3
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 + Space, select 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 Hong Kong's Rising Stars: Purpose-Driven Startups Shaping the Future

Hong Kong has become a powerhouse for startups with a mission, fostering innovation that tackles urgent social and environmental issues. This vibrant city offers a unique ecosystem supporting entrepreneurs in building impactful businesses while providing access to vital government resources and funding.
icon_hacks_b Created with Sketch. Garage Blog Maximising Productivity in Coworking Spaces: Tips and Tricks

With over a decade in Hong Kong's bustling coworking scene, I've witnessed firsthand the remarkable rise of shared office spaces in the city.

 

These dynamic spaces have revolutionised the way we work, offering a perfect blend of flexibility, community, and professional amenities. 

 

According to a recent study by Coworking Resources, the number of coworking spaces worldwide is projected to reach a staggering 41,975 this year, marking a significant 42% increase from 2019 to 2024.

 

The appeal of coworking spaces is undeniable. They provide a cost-effective alternative to traditional offices, foster networking opportunities, and offer a vibrant atmosphere that can spark creativity and innovation.

 

However, with the myriad of distractions and the constant buzz of activity, maintaining productivity in these shared environments can be challenging.

So whether you're a freelancer, a remote worker, or part of a growing startup, these tips and tricks will help you harness the full potential of your coworking experience while keeping your productivity at its peak.

 

James Bernardo, Program Director, Garage Society
icon_hacks_b Created with Sketch. Garage Blog Taste the Best of Sai Ying Pun: Our Handpicked Top 10 Lunch Spots!

Join us as we uncover the hidden gems and popular dining hotspots around Garage Society Sai Ying Pun. Whether you're a local in search of new lunchtime favorites or a visitor craving a taste of the vibrant dining scene, this guide is your ticket to culinary delight.

 

From quick bites to leisurely lunches, Sai Ying Pun has it all, and we're here to guide you through the flavors that await. Get ready to recharge and refuel at the lunch spots that call Sai Ying Pun home

 

By Tatiana Park, Community Marketing Executive
show more