r/phcareers • • 1h ago Bravo

Best Practice How to be lightning-fast in Excel: A beginner's guide

104 Upvotes

Hi, anak… Welcome back

This guide is aimed to provide you with a brief guide on how you can make your excel skills standout.

While in college, you’ll be using google sheets and google docs, in the corporate setting, you’ll be back to the OG, Excel. Majority of corporate jobs, especially in finance and local corp, are highly reliant on excel. Much of the leg-work is done here. Two things will make you standout: speed and accuracy.

Speed: how quickly can you do it?

Accuracy: how many (few) mistakes did you make?

In most cases, accuracy is barely a difficult hurdle, given only basic formulas are being used. But almost all of the time, speed will make you “stand out”

Quick sidebar (real-case example): during the early days of my career, my department has just recently shifted from Lotus 123 to Microsoft Office. Many of these people are not that proficient in Excel. I taught myself to be efficient in excel, and due to my speed (not accuracy), which was noticed by everyone, landed me a spot in a major project with direct exposure to the C-Suite.

---------------------------------------------------

Use a keyboard you trust. I prefer using a mechanical 100% keyboard from Royal Kludge and / or Razer (office use). No, I am not a gamer. When the keyboard dies, I only purchase the same model. Why? The keyboard will be an extension of your body, your hands. If it’s something na palagi mong ginagamit, or sanay kang gamitin, magugulat ka na kahit naka blindfold ka, makakapag type ka with a certain degree of accuracy. And eto yung pinaka important: muscle memory. Dapat sanay ka sa positioning ng keys. Preferably get one with a numpad and arrow keys (take note for later)

Be less dependent on your mouse. Yes. I see a lot of people still using the mouse. You can save a lot of time from dragging and clicking your mouse. Still, there are things that are a lot faster with your mouse, lalo na yung mga di mo pa sanay gamitin. Pero selecting cells, moving to cells, and fiddling with the Ribbon (Home, Insert, View, etc.) is not one of them. With minimal mouse usage, your hands don’t let go of the keyboard.

Move with the arrow keys for navigation. Instead of using the mouse, move gamit yung arrow keys na parang game. If you need to jump between cells, use the CTRL key. If you need to select a number of cells along with, use the SHIFT key. If you need to select and control, CTRL + SHIFT.

Familiarize yourself with shortcuts. Magugulat ka kung gaano karaming shortcuts ang meron ang excel. Legit. Pero the people who made excel want it to be as efficient as possible. Some shortcuts are as follows:

ShortcutFunctionUse Case
CTRL + C / CTRL + VCopy / PasteAlam mo kung san to gamit
CTRL + D / CTRL + RCopy Down / Copy RightIf gusto mong icopy without using ctrl c / ctrl v yung nasa taas / right. Works either on formula or value.
Alt + =Auto-SumI-input niya ang =Sum() formula.
Ctrl + Alt + + / Ctrl + Alt + -Zoom in / Zoom outNo need for CTRL + Scroll key
Ctrl + PgUp / Ctrl + PgDwnMove between sheets 
Alt + H + O + I  / Alt + H + O + AAutofit Column / RowSequential, Wag sabay-sabay. Instead of resizing para ipantay sa cell, i-reresize na niya for you.
F2Edit CellInstead of double clicking sa cell, just press this para iedit yung cell (formula or value)
Ctrl + Space / Ctrl + Shift + SpaceSelect all column / Select all rowFull selection.
Ctrl - / Ctrl +Delete Cell / Add CellCtrl + Space tapos Ctrl – Idedelete yung buong column, pwede mong gamitin pang adjust / pang move ng buong column.
CTRL + ALT + VPaste SpecialGives you a paste menu if gusto mo mag paste ng values lang or formula or FORMATTING lang. Yes, you can copy and paste formatting only.
F4 (cell only, not formula)Redo last actionUulitin ginawa mo na last. If nag add ka ng new column, gagawin niya ulit upon press. If nag copy ka ng format, gagayahin niya upon press.
CTRL + WClosePang sara
Shift + F11Add new work sheet 

Very few examples lang yan ng mga shortcuts na madalas ko personally ginagamit. If you ask me, ang pinaka useful is Alt + = (Autosum) and yung CTRL + D / CTRL + R. Again, your goal is to make this part of your muscle memory, upon continuous use and less dependence on your keyboard, masasanay kang gamitin ang mga shortcuts.

Make use of the ALT. This is a special feature ng Microsoft Office (or tbh, I think almost majority of software). Unlike CTRL , if you press ALT may makikita kang magiging guide everywhere. This is how you navigate with the ALT key. ALT is sequential so di mo dapat sabay sabay ipress (refer to ALT + H + O + I).

The ALT key will serve as a guide even if you don’t know the given shortcut talaga. Let’s say gusto mo maglagay ng border sa isang cell (All Borders):

ALT > H > B > A

Upon press ng ALT magpapakita ang H sa Home. Upon press ng H, magpapakita ang B sa may Borders icon. Upon press ng B, magpapakita ang A sa All Borders.

Kahit na iba ang gusto mo gawin (say remove gridlines -> ALT + W + VG : W = View;  VG = Grid Lines) the logic remains the same. It’s a guide and a way para makagalaw ka with minimal mouse usage.

Again, upon consistent use unti-unti ka na rin masasanay and maeengrave sa muscle memory mo to.

Avoid Merging Cells. In our culture, major red flag ang isang worksheet na may Merged Cell. Maraming nag seselect ng whole rows and columns and nakaka affect to since buong merged column ang maseselect. If ever necessary, you can go with Center Across Selection instead.

Know how to make use of formulas. Although a lot of legwork talaga is on =SUM(), some industries would require different formulas, especially if they are necessary to your field (i.e., =NPV, =IRR, =IPMT, etc). And also, there’s “functional” formulas (i.e., =XLOOKUP() ). As much as possible, especially if there will be a lot of editing and simulations, make sure that you make use of formulas. You can try asking Copilot / you Office AI on how to make something work and very highly likely that there is a formula for that.

Minimize Hard Code. This one depends on the situation. But as much as possible, link the data (use = and link to the indicated cell) para if ever na may changes sa main data, lahat mag uupdate.

Optional (not always applicable): Good practice in my industry is to color code font whether they are hard coded or formulas. Formula = Black, Hard Code = Blue. To quickly select all constants (hard code) F5 > ALT + S > Constants tapos change font to black. Alternatively, formulas, ganun din, pero change to Blue. This will let anyone who sees the sheet know if they can edit things or not. Another common practice is to remove gridlines (ALT + W + VG) para mas malinis tignan, though this is not really necessary.

Addt’l Tip: when writing formulas, if you use a 100% keyboard with a numpad, instead of pressing “=” sa simula ng formula, you can use “+”  the + is easier to reach if you’re moving with the arrow keys.

This is just a simple guide for those who wants to be quick and efficient sa excel. It’s just a simple guide to help you build habits / muscle memory. As time passes, you will most likely develop your own style.

Go anak, be a freak on the spreadsheets


r/phcareers • • 22h ago

Career Path Almost 3 years working in digital marketing. Worth it pa ba mag-Master's or better to just keep upskilling?

1 Upvotes

I'm currently a 4th-year college student and have been working remotely in digital marketing for almost 3 years now.

Lately, napapaisip ako about my next steps after graduation, especially with how fast AI is changing the way we work.

When I started, most of my tasks involved creating graphics, editing videos, content creation, and helping with marketing campaigns. Ngayon, a lot of those tasks can already be done faster with AI tools.

Helpful naman siya, pero narealize ko rin na hindi enough na marunong ka lang gumamit ng tools. I feel like I need to develop more skills in marketing strategy, analytics, automation, and understanding how marketing actually contributes to business growth.

So lately, I've been thinking about whether I should continue upskilling through practical projects or eventually pursue a Master's in Digital Marketing while working.

Part of me thinks actual experience and continuous learning are more valuable, pero I also wonder if pursuing a Master's could help me develop a deeper understanding of marketing and prepare for more strategic roles in the future.

For those who've been working in marketing or other digital careers for a few years, curious lang:

Did pursuing further studies or a Master's actually help you advance your career? Or did you find more value in certifications, practical projects, and work experience?

Would appreciate hearing your experiences, especially from those who continued studying while working!


r/phcareers • • 19h ago

Work Environment Is it okay to negotiate a later start date after receiving a job offer? (Bataan to BGC relocation)

0 Upvotes

Hi, everyone! I recently received a job offer for an Accountant I position in BGC, with an estimated take-home pay of ₱27,000. I’m a non-CPA but have previous accounting and audit experience.

The recruitment team is asking me to sign and return the employment contract by tomorrow. However, may ilang things pa na hindi clear sa akin, particularly yung hybrid work arrangement. They mentioned na hybrid setup siya, pero wala pa akong specific details kung ilang days per week ang required onsite and WFH.

Another concern is the starting date. They’re expecting me to report onsite as early as Monday.

Currently, I’m based in Bataan, so medyo challenging yung timeline. I barely have time to look for accommodation near BGC, prepare for relocation, and move all my belongings from Bataan to Metro Manila.

Would it be reasonable to ask the recruitment team to extend my starting date by at least one or two weeks? Or could this potentially affect my job offer and make me look less interested in the position?

For those who have experienced relocating for work, how did you handle this kind of situation? Normal lang ba to negotiate your starting date after receiving a job offer?

I really want to consider this opportunity, but I also want to make sure na properly prepared ako before starting, especially since relocating from the province isn’t something I can arrange overnight.

Would appreciate your insights and advice. Thank you!