• Our team 10
  • Blog / News 276
  • Garage commons
  • Hong Kong 5
  • Singapore 1
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
Garage Blog 5 Key Tips for Planning Memorable End-of-Year Events

As the end of the year approaches, businesses across all industries are gearing up to celebrate their accomplishments and foster team spirit with memorable events - from Christmas Parties to team building activities and networking socials. If you're in charge of planning an end-of-year event for your organisation,  whether you're in Web 3 or Wellness, Banking or Blockchain, Art or AI, we've got you covered
Garage Blog "Paws for a Cause" Dog Adoption Month at Garage Collective Cafe

Join us for three incredible dog adoption events across September that will warm your heart and change lives forever!

 

Our "Paws for a Cause" month brings adorable shelter animals seeking their forever homes and compassionate individuals like you together at our pet friendly Garage Collective Cafe space.
Garage Blog International Dog Day 2023: Conversations with Pet Parents

To celebrate International Dog Day, we sat down with Damith Weerakoon - Director of Marketing & Operations at Garagers Milestone Beverages and proud Dad to Solo - our resident canine companion at Garage Collective SYP! Dive into our discussion below to explore the ins and outs of dog ownership in Hong Kong as we raise a bowl of water to our furry friends!

 

"A pet friendly space is  great for not just me but for Solo to have a space to meet other dogs, and everyone here loves her as much as me!" Damith Weerakoon

 

But that's not all—we also caught up with Tati, our Community Marketing Assistant, to explore another fascinating aspect of dog-related responsibilities in this bustling city.

Interview by Muskan Sharma, Assistant Project Manager
show more