Top 10 Advanced Excel Shortcuts

 

Top 10 Advanced Excel Shortcuts:

 

1. Ctrl + Shift + L Toggle filters

2. Alt + E + S + V Paste Special Values

3. Ctrl + Arrow Keys Navigate to data edge

4. Ctrl + Shift + Arrow Keys Select large data ranges

5. F4 Repeat last action

6. Ctrl + ` Toggle formula view

7. Alt + = Insert SUM function

8. Ctrl + Shift + $ Apply Currency format

9. Ctrl + ; Insert current date

10. Ctrl + Shift + & Apply borders

 

These shortcuts boost productivity and efficiency in navigating, formatting and managing data.

"Reboot, Refresh, Repeat: Why Restarting Your Laptop is a Must"

 

 

"Reboot, Refresh, Repeat: Why Restarting Your Laptop is a Must"

 

When you shut down your PC, Fast Startup saves the state of your RAM to the drive. When you turn the PC back on, this data is reloaded into RAM, allowing Windows to start faster. However, the downside of Fast Startup is that your RAM is never completely flushed, which can lead to performance issues or glitches over time.

 

To check your system's uptime, search for Task Manager in the Start menu or press CTRL + ALT + DELETE and select Task Manager. On Windows 11, you may need to click "More details" to expand the view. Next, navigate the Performance tab to see your system's performance metrics. At the bottom of the page, you’ll find Uptime displayed in the format DD:HH:MM:SS. For example, if it shows 8:17:31:06, it means the computer has been running for 8 days, 17 hours, 31 minutes, and 6 seconds since its last restart or reboot.

 

"Time It Right: Schedule Chat Messages in Microsoft Teams"

 

Take control of when your chat messages are delivered! Use Microsoft Teams' schedule send feature to compose and send messages up to 7 days in advance. Ensure your messages arrive during work hours, avoiding inconvenient notifications. Plus, edit or delete scheduled messages before they're sent. Simply right-click the send button, choose your preferred date and time, and let Teams do the rest. Boost collaboration and respect everyone's schedules with this powerful feature!

 

Schedule your chat message to be sent later

1. Compose your message in the chat, and right-click on Send . 

2. Choose the date and time that you'd like to send it from the pop-up menu. 

3. Click the Continue button.

4. Select Send .

Your chat message will be automatically delivered at the scheduled date and time. 

Edit your scheduled chat message 

1. Hover over your message to select Edit . 

2. Edit your chat message, then select Done  to save the update.

Reschedule the delivery of your chat message 

1. Hover over your message to select Edit . 

2. Select the down arrow next to the scheduled date and time to choose a new date and time to send your message. 

3. Change the date or time. 

4. Select Continue, then select Done  to save the update.

Delete your scheduled chat message 

1. Go to the message and select More Options   > Delete .

Schedule your chat message to be sent later.

 

Personalize Your Voicemail in Teams!

                              

 

Want to leave a great impression even when you’re unavailable? Microsoft Teams lets you set a custom voicemail greeting to reflect your personality and professionalism.

 

Why?

Sound professional.

Guide callers with clarity.

Add your unique touch!

 

How?

Go to Settings > Calls > Configure Voicemail and record your custom message. It takes seconds, but it makes a lasting impact!

 

Try it today—your voicemail deserves some flair!

How to check replication status of all Domain Controllers and replication status of users across Active Directory Forest

 

 

 

Suppose you are working in that company who have various locations and have multiple domain controllers, recently that company opened new branch in new region and you have created new Domain controller for that region and now you want to check that new domain controller able to see or replicate properly among all domain controllers and users or objects created under new domain controller able to sync properly in the Active Directory Forest.

Use below command to get all the domain controllers details in a text file (DCDetails.txt).

•       DSQuery Server –O RDN > DCDetails.txt

Use below command to check the status of the newly created users among all domain controllers. This command gives output in text file named Detail.txt

•         For /F “Tokens=*” %L IN (DCDetails.TXT) DO DSQuery user –DomainRoot –Name Username> Detail.txt 

How to check the Volume Shadow Copy Service (VSS) provider/writer status

 

Problem

How to check the Volume Shadow Copy Service (VSS) provider/writer status.

Solution

To check the VSS provider/writer status.

1. Open a command window. Click Start > Run and type CMD, and then click OK.
2. At the command prompt, type vssadmin list providers, and then press ENTER.
3. Confirm that Microsoft VSS provider is listed as:
 
Microsoft Software Shadow Copy provider 1.0

 
4. Type vssadmin list writers at the command prompt, and then press ENTER.
5. Confirm that all the VSS writers are showing:
State: [1] Stable
No error


NOTE: If any errors are found with a specific writer, contact the writer's corresponding application manufacturer technical support for further assistance.