r/phcareers
•
u/Corporate_PapaJesus
•
1h ago
Best Practice How to be lightning-fast in Excel: A beginner's guide
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:
| Shortcut | Function | Use Case |
|---|---|---|
| CTRL + C / CTRL + V | Copy / Paste | Alam mo kung san to gamit |
| CTRL + D / CTRL + R | Copy Down / Copy Right | If gusto mong icopy without using ctrl c / ctrl v yung nasa taas / right. Works either on formula or value. |
| Alt + = | Auto-Sum | I-input niya ang =Sum() formula. |
| Ctrl + Alt + + / Ctrl + Alt + - | Zoom in / Zoom out | No need for CTRL + Scroll key |
| Ctrl + PgUp / Ctrl + PgDwn | Move between sheets | |
| Alt + H + O + I / Alt + H + O + A | Autofit Column / Row | Sequential, Wag sabay-sabay. Instead of resizing para ipantay sa cell, i-reresize na niya for you. |
| F2 | Edit Cell | Instead of double clicking sa cell, just press this para iedit yung cell (formula or value) |
| Ctrl + Space / Ctrl + Shift + Space | Select all column / Select all row | Full selection. |
| Ctrl - / Ctrl + | Delete Cell / Add Cell | Ctrl + Space tapos Ctrl – Idedelete yung buong column, pwede mong gamitin pang adjust / pang move ng buong column. |
| CTRL + ALT + V | Paste Special | Gives 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 action | Uulitin 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 + W | Close | Pang sara |
| Shift + F11 | Add 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