Slide numbers and caps changing

Office 365 quick post

Removing slide numbers from Powerpoint Office 365

  1. Click on the Insert tab.
  2. Select the Header and Footer option (towards the right of the screen).
  3. Uncheck the Slide Number option
    • If you’re just changing the title slide then click on “Don’t show on title slide” at the bottom
  4. Click “Apply to All” and close the tab.

The information on the official MS Office page seems to have completely forgotten the menu is hidden by default.

Sentence case to ALL CAPS and Title Case

Shortcuts for changing caps in MS Word, Powerpoint and Excel:

  • Word and Powerpoint
    Select and press Shift + F3 till you get the desired caps.
  • Excel
    1. Insert temporary column next next to the column you want to change caps.
    2. Use a formula to change the caps, i.e.
      =Proper(click on the cell you want to change the caps of)
      =lower(click on the cell you want to change the caps of)
      =UPPER(click on the cell you want to change the caps of)
    3. Copy the values in the temporary column.
    4. Right click anywhere else and Paste as Values.
    5. Delete temporary column.

Putting this here mainly for my own convenience. I suppose there is a reason why Excel’s a special case but really Microsoft, the fact that I had to write this entry in the first place says a lot about the total failure of your SEO.

Thoughts: Logitech Lightsync Bundle

G560 Lightsync Bundle (1)

Brand: Logitech
Promo name: Logitech G Lightsync Bundle
What it includes: Logitech G512 (Keyboard), G502 (mouse), G560 (speakers with subwoofers)
Recommended retail price (RRP): RM1947
Promo price: RM1380 – RM1388
Should you get it? Yes, if you need a speaker upgrade and either a new keyboard or gaming mouse.

The Logitech G Series is Logitech’s gear for gamer range with the prices to match. They recently released the G560 in Malaysia, and I think to celebrate they introduced a Logitech G Lightsync Bundle that included the speakers, keyboard and gaming mouse. Originally the promo was due to end 31 May 2018; right now it’s a “while stocks last” promo in most of the places I went in.

So what do you get for RM1388 and why am I writing about it?

Well, first is the G560. It’s a speaker that marks Logitech’s foray into RGB speakers. I won’t go into details about the speaker’s features – you can check them out here or video here, but I will say the bundle’s a damn good deal for the speakers.

The speakers themselves work as advertised and are really nice to look at and listen to. They’re really loud and if you have the Lightsync sampler set up, they match whatever’s on your screen, including your Youtube videos. But what about the price, you ask?

The RRP for the G560 is RM999. Online and in-store, it retails closer to RM880, depending on who you’re buying from.

Now, if you were in the market for a mechanical keyboard, then yes, I think the G512 serves very nicely. It is much smaller than both my CM Storm (I have a Quickfire Pro and a Trigger) and the Tactile version of the keyboard is certainly much nicer than I anticipated.

This is one of those few keyboards where I can really type without looking at the keys too closely – I have tiny hands, and I think this is why it’s so comfortable for me.

RRP for the G512 is RM579. Online and in-store, it’s about RM455, again depending on the seller.

The Logitech G502 is a gaming mouse. It has a shitload of buttons which has made my keyboard fairly redundant when simply browsing. I did have a G102, which is a great starting mouse if you want to spoil yourself.

My biggest complaint about it is that it doesn’t have enough buttons (yes, I know, first world problems). The G502 comes with enough buttons that I have a few spare ones but at the cost of it being too big for my hands. I can’t reach the forward upper button, aka G8 easily with my thumb or finger. Small hand issues.

RRP is RM369. Online it’s anywhere from RM280 to RM310. Let’s go with RM280.

So by that, the simple maths is RM880 + RM455 + RM280 = RM1615. This is quite expensive compared to the bundle price. If you’re in the market for speakers and some additional peripherals, then I highly recommend the Lightsync G Bundle before it disappears.

Final note: Bear in mind that there are cheaper sellers available online (affiliate link), but the prices usually do not include shipping. The speakers are crazy heavy, and I’ve seen fees from as low as RM14.50.

[Geekiness] Volume button not working in Windows 10

Quick fix if your volume icon stops working erratically like mine does in Windows 10. Still waiting for the day Microsoft fixes this (happens only in Win 10, did not happen before).

  1. Open Task Manager. If you don’t know how, click on your Windows Start Menu then type “Task Manager.”
  2. Scroll right down to the bottom past Windows Processes to “Windows Explorer.”
  3. Right-click, select “Restart.
  4. ????
  5. PROFIT! You can now select your sound output (headphones vs monitor, etc) and change your volume.

You’d think they would have fixed it by now, but as this thread shows, it’s still happening today. Sigh.

Digi Up – A few thoughts

Edited 20 Sept 2018: According to a Lowyat.net report, Digi Up has been discontinued effectively immediately. Huh. 

Digi Up is a new service for Digi subscribers, targeted at those who upgrade their phones frequently. It offers subscribers the “newest and greatest” phones at an affordable monthly rate. In a nutshell here’s what you need to know:

Who’s eligible:
– Those who receive the call or SMS from Digi beginning 2 Feb, if this page is right.
– Usage above RM80 monthly for the last three months
– My suspicion: Those who switched phones frequently in the last few years (I had 3 phones over the last 3 years, which was probably why I was targeted)

At a glance, you’ll get quite a few good benefits:
– New phone yearly if you like, or once every two years (flagship level, it seems)
– Phone theft protection (you can claim once per phone)
– Accidental damage (water, screen protection, etc)
– A concierge-like service for all your phone needs
Buy back guarantee for the phone they ~rent~ give you

So it looks like a pretty damn good deal right? You can upgrade your phone yearly if you like and it will always be flagship-level, you get great phone protection and dedicated customer service. I dropped by a Digi store to get more info, and then the hidden stuff came to light.

Here’s the bit that’s a little obscured on their site they don’t tell you:

  1. You MUST subscribe to the Digi Postpaid 110 plan.
  2. You will be paying the device price together with the plan.
    So if you choose the Note 8, you’ll be paying RM262 aka RM152 (device price) + RM110 (subscription).
  3. This is a phone rental service.
    Yes, you read that right, it’s a RENTAL service. You cannot keep the phone even after your contract is over. You need to either return it to Digi for a new phone or extend your contract (max 6 months) OR pay a Payoff fee that’s not listed on that page.
Is Digi Up worth it?

Well, it depends. Digi Up seems to be the next incarnation of Digi’s previous instalment plan, the Easy Up. The biggest change seems to be the mobile protection offered – Easy Up required a separate subscription to Mobisure while Digi Up offers it as part of their service. There’s some wording that also seems to indicate that users could keep their phones on the Easy Up service – on Digi Up, you have to return it or pay them an extra fee to keep it forever.

If you expect to change your phones every 12 months or so then this may be an option for you. If you are already on the RM110 plan OR are considering an upgrade to that plan and was in the market for a new phone, yes, this plan might be worth it. Otherwise, if you’re like me and you expect your phone to be with you for a few years… probably not.

What I learnt this week

Image of the video rendering in progress

So, a few quick things I wanted to write about this week.

Video editing is painful

As part of the ASMR series, I’m uploading a bunch of videos that show me typing. This week’s video with the CM QuickFire Pro has been delayed a few days because I’ve been playing around with Da Vinci Resolve.

The verdict? I’m taking a sledgehammer to a nail. This tool is powerful but I need to relearn how to edit videos from scratch. Why did you delete Movie Maker, Microsoft, why?

Rendering can be nuts

As part of my “learning curve” with the software, I ended up exporting a file that was 65GB. Don’t ask.

This explained why my subsequent export of the same video in a different file format took only minutes instead of hours.

Can’t edit noise in the software

For some reason, I could not edit sound to remove noise in Da Vinci. I am going to export and then add the sound back from Audacity when done. I thought I’d removed all noise earlier. Annoying? Yes, very much so.

Exercise hurts

Finally upped my fitness game from mere walking in Pokemon Go to actual exercise. Yesterday (Wednesday) was Day Two, and for some reason my thighs hurt. Note to self: It could also be due to the fact you walked about 10,000 steps a day last weekend.

Still, it is better than almost nothing of the last two years.

Conclusion

This week was a week of pain, to say the least. See you all next week.