Thursday, November 28, 2024

PLDT's "Fiber Always On": Because Internet Downtime is So 2005

 

Say goodbye to those awkward moments when your WiFi gives up during your Netflix and chill or right in the middle of an intense online game. PLDT’s Fiber Always On is here to save the day—and your sanity.

Two is Better Than One

This hybrid modem is like your favorite duo: fiber for speed and LTE for backup. When your fiber says, “BRB,” LTE steps in with, “Don’t worry, I got this.” It’s the relationship you deserve, one that doesn’t leave you hanging.

No "Load Drama"

Unlike your clingy ex, LTE isn’t demanding. The data is already part of your plan! For just PHP 299/month, it’s your internet’s life insurance policy, peace of mind for the price of your weekly milk tea fix.

SOS for Your WiFi

Lost fiber connection? No need to panic or refresh your router a million times. PLDT’s system automatically files a service request faster than you can say, “Hello, tech support?”

Speed That Gets You

With Smart’s LTE Cat 6 tech, you’ll get up to 300 Mbps download speeds—perfect for working, gaming, or watching your favorite K-drama. Plus, with WiFi 6 support, your connection is smooth, steady, and ready to flex on both 2.4GHz and 5GHz bands.

How to Get It

1.    Add it to your existing PLDT Fiber plan for just PHP 299/month.

2.    Call PLDT customer service.

3.    Wait 24-48 hours (faster than your last food delivery).

With Fiber Always On, internet interruptions are a thing of the past. It’s the superhero your WiFi didn’t know it needed—fast, reliable, and always online.

So, what are you waiting for? Because buffering isn’t cute. 😏


Wednesday, November 27, 2024

Automate Your WORK HOURS in 2 Minutes!

Learn how to automatically calculate total work hours in Excel and classify status as Halfday or Wholeday based on Time In and Time Out!

Monday, November 11, 2024

How to Check Attachment Size Limits in Microsoft Outlook

In Microsoft Outlook, the attachment limit is typically 20 MB for standard email accounts (such as Outlook.com and Office 365). However, the attachment limit can vary depending on the email provider you're using (e.g., Gmail, Yahoo, or other services linked to Outlook).

To check the attachment limit in your Outlook, follow these steps:

  1. Check Outlook Documentation: You can go to Microsoft Support and search for "attachment limit" to find the latest information.
  2. Email Account Settings: In Outlook, go to your account settings and check the configurations to see if your email provider’s attachment limit is indicated there.
  3. Attachment Prompt: If you exceed the limit while attaching a file, you’ll see an error message indicating that the attachment size is beyond the allowed limit.

If you often encounter issues with attachment size, you can use OneDrive or another cloud storage service to share larger files.

Sunday, November 10, 2024

Difference Between 𝑰𝑻 (π‘°π’π’‡π’π’“π’Žπ’‚π’•π’Šπ’π’ π‘»π’†π’„π’‰π’π’π’π’π’ˆπ’š), π‘ͺπ’π’Žπ’‘π’–π’•π’†π’“ π‘Ίπ’„π’Šπ’†π’π’„π’† (π‘ͺ𝑺) 𝒂𝒕 π‘ͺπ’π’Žπ’‘π’–π’•π’†π’“ π‘¬π’π’ˆπ’Šπ’π’†π’†π’“π’Šπ’π’ˆ (π‘ͺ𝒐𝑬) course

 Information Technology (IT):

  • Focus: Implementing and managing technology for businesses or organizations.
  • Key Areas: System administration, database management, networking, cybersecurity, and IT infrastructure.
  • Skills: Maintaining systems, troubleshooting, managing servers and networks, and assisting users.
  • Career Path: Network administrator, IT support specialist, systems analyst, database administrator, cybersecurity analyst.

Computer Science (CS):

  • Focus: Studying computation, algorithms, and software development, with a focus on the theoretical aspects of computing.
  • Key Areas: Programming languages, software engineering, artificial intelligence, machine learning, data structures, algorithms, and computational theory.
  • Skills: Software development, coding, problem-solving in computational issues, and creating new technologies.
  • Career Path: Software developer, data scientist, AI specialist, systems architect, research scientist.

Computer Engineering (CoE):

  • Focus: Combines electrical engineering and computer science to design hardware and software systems, focusing on building and designing computers and their components.
  • Key Areas: Hardware design, microprocessors, embedded systems, circuit design, robotics, and firmware development.
  • Skills: Designing and assembling hardware, optimizing hardware-software integration performance, programming low-level systems (e.g., assembly language).
  • Career Path: Hardware engineer, embedded systems engineer, robotics engineer, firmware developer, chip designer.

Summary of Differences:

  • IT: More practical, focused on using and managing technology.
  • CS: Focused on software development and computational theory.
  • CoE: Combines hardware and software, focused on creating physical computer systems and devices.

In short, if you want to focus on software and algorithms, CS is your path; if you’re into hardware and devices, go for CoE; and if you want to work in technology management and operations in companies, IT is the best fit!

Microsoft Excel Shortcut Keys Reference

Here are some useful shortcut keys in Excel that can enhance your productivity:

✅Ctrl + C: Copy selected cells.

✅Ctrl + X: Cut selected cells.

✅Ctrl + V: Paste copied or cut cells.

✅Ctrl + Z: Undo the last action.

✅Ctrl + Y: Redo the last undone action.

✅Ctrl + A: Select the entire worksheet.

✅Ctrl + Home: Navigate to cell A1.

✅Ctrl + Arrow keys (Up, Down, Left, Right): Move to the edge of the current data region in the direction of the arrow key.

✅Ctrl + Shift + Arrow keys (Up, Down, Left, Right): Select cells from the current cell to the edge of the data region in the direction of the arrow key.

✅Ctrl + Shift + L: Toggle filter on/off for the selected range.

✅Ctrl + Shift + L + Arrow keys (Up, Down): Select entire columns or rows within a filtered range.

✅Alt + =: AutoSum selected cells.

✅F2: Edit the active cell.

✅Ctrl + Shift + "+": Insert new cells, rows, or columns.

✅Ctrl + "-": Delete cells, rows, or columns.

✅Ctrl + Shift + "$": Apply currency format.

✅Ctrl + Shift + "%": Apply percentage format.

✅Ctrl + Shift + "#": Apply date format.

✅Alt + Enter: Start a new line within a cell.

✅F4: Repeat the last action.

  

Wednesday, November 6, 2024

Automate Your Loan Due Date Tracking Using EDATE: Conditional Formatting...


Learn how to automate loan due date tracking in Excel! This tutorial covers using the EDATE function to auto-calculate future due dates and Conditional Formatting to highlight payments due, so you never miss a deadline.

Monday, November 4, 2024

How to Create an Automated Attendance Sheet in Excel with Conditional Fo...

I’ll show you how to create an attendance sheet in Excel that does the hard work for you. With just a few easy steps, you’ll be able to set up automated attendance tracking using Conditional Formatting to highlight "Present" and "Absent" cells in different colors. It’s the perfect solution for teachers, HR managers, or anyone needing a quick attendance record without the hassle. Be sure to watch my YouTube tutorial linked below for a full walkthrough!

Step-by-Step Guide:

1. Set Up Your Sheet - Begin by setting up your headers: “Name,” “ID Number,” and dates across the top. List attendee names down the side.

2. Marking Attendance - Record attendance by marking P for “Present” and A for “Absent” under each date.

3. Using Conditional Formatting - Here’s the trick to make it visually clear:
   - Select your range (e.g., C2:G10).
   - Go to Home > Conditional Formatting > New Rule.
   - Select Use a formula to determine which cells to format and enter:
   - For Present: `=C2="P"` with a green fill.
   - For Absent: `=C2="A"` with a red fill.

4. Add Totals (Optional) - Add a column for Total Presents and Total Absents to quickly track each person’s attendance.

Bonus: Want to see exactly how it’s done? Check out the tutorial on my YouTube channel where I demonstrate each step visually to make setup a breeze!

Saturday, November 2, 2024

How to Merge Rank, Full Name, and Suffix in Excel Using TEXTJOIN


Learn how to combine rank, full name, and suffix in Excel using the TEXTJOIN function! This tutorial shows you how to merge names into a single cell with proper formatting, perfect for military or formal lists.