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!

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.

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.

  

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.

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!

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.