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.

Monday, October 21, 2024

Get Ready for a Sulit Food Trip LIKE NO OTHER with Mang Gyupsal!



What’s up, mga ka-foodtrip! If you’re looking for a dining spot that won’t hurt your wallet but will definitely satisfy your cravings, check out Mang Gyupsal! Located just a short walk from Enverga University, Univesity Site, Lucena City in Quezon province. It’s the perfect go-to place for Korean BBQ lovers.

Imagine this: unlimited BBQ and street food without needing to order straight from Korea! They’ve got BBQ, fried noodles, fish cakes, corndogs, tteokbokki, and even a kimchi burger! Yup, you heard that right, a kimchi burger! You won’t find that everywhere.

But wait, there’s more! If you love sizzling dishes, you’re in for a treat. Mang Gyupsal serves up Korean Soy Garlic Chicken, Sizzling Kare-Kare, and the crispiest, most flavorful sisig. Trust me, the sisig here is next-level - crispy and creamy all at once, like a fiesta in your mouth!

Feeling adventurous? Try their Do-It-Yourself ramen, where you can customize the flavors to your heart’s content. Plus, they’ve got classics like chao pan, pansit canton, and lutong-bahay dishes, making it the ultimate comfort food destination.

The vibe? Super chill! With an al fresco setup and a cozy second floor, it’s the perfect spot to unwind after class or hang out with friends. Best of all, it’s easy on the student budget, so you can enjoy that unli BBQ without feeling guilty about your allowance.

And don’t forget the extras - Korean eggdrop sandwiches, chicken pastil, fries, and refreshing coolers to wash down all the deliciousness. If you’re looking for an all-in-one dining experience that’s both sulit and satisfying, Mang Gyupsal is the place to be.

So, what are you waiting for? Unli BBQ, sizzling dishes, Korean street food, and more, it’s all here! Perfectly located near Enverga University, Mang Gyupsal is your new post-class hangout. Kita-kits sa Mang Gyupsal!