Monday, July 22, 2024
Future-Proof Your Files: Why Microsoft 365’s ODF 1.4 Update Matters
Monday, July 15, 2024
Revolutionize Your Spreadsheets with Google Sheets' New Pre-Built Tables
Monday, July 1, 2024
Inserting Checkboxes in Excel: A Comprehensive Guide
Monday, June 24, 2024
Improve Your Presentations with PowerPoint's AI Coach
Monday, June 17, 2024
Revolutionize Your Documents: Google Docs Tables Get a Powerful Upgrade
Monday, June 10, 2024
Excel Hacks: Master Line Breaks and Bullets for Cleaner Spreadsheets
Monday, June 3, 2024
How to Draw in Excel: Unleash Your Inner Artist
Monday, May 20, 2024
Essential Keyboard Shortcuts for Word, Excel, and PowerPoint
- Ctrl + C / Ctrl + V / Ctrl + X - Copy selected text or graphics to the clipboard with Ctrl + C. Use Ctrl + V to insert or Ctrl + X to remove the content, optimizing your document editing flow.
- Ctrl + Z / Ctrl + Y - Made a mistake? Hit Ctrl + Z to undo it. Want to reverse the undo? Ctrl + Y is your go-to command for redoing actions.
- Ctrl + S - Never worry about losing your progress again. Press Ctrl + S frequently to save your document, securing your hard work in seconds.
- Ctrl + Arrow Keys - Navigate through your spreadsheet with precision using Ctrl + Arrow Keys, jumping to the edge of data regions effortlessly.
- Ctrl + Shift + L - Manage large datasets like a pro. Activate filters with Ctrl + Shift + L and analyze your data with just a few keystrokes.
- Alt + E, S, V - Take control of how you paste your data. Alt + E, S, V opens the Paste Special dialog, giving you options to paste exactly what you need.
- F5 - Launch into your presentation seamlessly with F5, starting from the very first slide.
- Ctrl + M - Need a new slide? Ctrl + M adds a fresh one to your deck instantly, keeping your creative flow uninterrupted.
- Ctrl + Shift + C / Ctrl + Shift + V - Ensure visual consistency across your slides. Use Ctrl + Shift + C to copy formatting and Ctrl + Shift + V to paste it elsewhere.
Monday, May 13, 2024
Share Excel Sheet Views & Supercharge Team Productivity
Sheet Views in Microsoft Excel are a powerful feature that allows users to create personalized views of a spreadsheet without affecting how others see the data.
Sheet Views are particularly useful in collaborative environments where multiple users need to work on the same data set but focus on different aspects of it.
They enhance productivity by allowing each user to work independently within the same shared workbook.
Creating a Sheet View in Microsoft Excel is a simple process that allows you to personalize your data analysis experience.
Here’s how to do it:
Create Sheet View
- Open Your Excel Workbook.
- Make sure it’s saved on OneDrive or SharePoint Online for Excel for the Web.
- Go to the View Tab:
- In the ribbon, find the Sheet View section.
- Click on New Sheet View.
- This will enable you to set up filters and sorts without affecting other users.
- Apply filters, sort orders, or hide columns to focus on the data you need.
- Save Your Sheet View:.
- Duplicate, delete, or switch between Sheet Views using the options in the Sheet View box.
![]() |
fig. 1 - Create and Manage Sheet Views - Excel for the Web |
Remember, any changes you make in a Sheet View won’t disrupt others’ views of the spreadsheet, making it an excellent tool for collaborative work environments.
The new feature, Share Sheet Views in Excel for the Web, is a significant enhancement for users who manage large or complex workbooks.
- It allows users to share links to specific Sheet Views within a workbook.
- Users can direct others’ attention to a particular subset of the workbook’s contents.
- Open a workbook in Excel for the Web.
- Navigate to the View tab.
- Select an existing Sheet View or create a new one.
- Right-click on any cell or the sheet tab and choose Copy Link To Sheet View.
- Click the Close button in the Link to Sheet message.
- Share the link via email, Teams chat, or any other communication platform.
![]() |
fig. 2 - Copy Link to Share Sheet View - Excel for the Web |
Monday, May 6, 2024
How to Use Link Preview Feature in Word for Web to Avoid Link Hassles
- Open your document in Microsoft 365 Word for Web.
- Highlight the text you want to link.
- Right-click and select ‘Link’ or use the shortcut Ctrl+K.
- Insert the URL and click ‘OK’.
- Hover over the hyperlink to see the preview pane.
![]() |
fig. 1 - Word for Web - Link Preview |
Monday, April 29, 2024
Unlock Excel’s Hidden Power: Boost Performance with “Check Performance”
- Open Excel (make sure you’re using Excel for the Web or Excel for Windows).
- Open the workbook that’s been giving you grief.
- Select Review> Check Performance.
- If your workbook contains size bloat, Excel will kindly notify you with a business bar.
- Click on the “Check Performance” button. It’s your ticket to a leaner, meaner workbook.
- As you optimize, watch your workbook transform. Those pesky formatted cells vanish, and your file size shrinks.
Monday, April 22, 2024
Effortlessly Translate English to Spanish in Google Sheets
- text: The text you want to translate (cell reference or text in quotes).
- source_language: Language code for the original text (e.g., "en" for English).
- target_language: Language code for your result (e.g., "es" for Spanish).
![]() |
fig. 1 - Google Sheets - GOOGLETRANSLATE Function |
- French: "fr"
- German: "de"
- Italian: "it"
- Spanish: "es"
- Japanese: "ja"
- Chinese (Simplified): "zh-CN"
- Chinese (Traditional): "zh-TW"
- Korean: "ko"
Monday, April 15, 2024
Unlock PowerPoint’s Video Editing Features for Dynamic Presentations
- Create a new PowerPoint or open an existing file.
- Add your video to the desired slide.
- Insert from Device.
- Insert from Stock.
- Insert from Online.
- Use the built-in trim feature to cut out any unnecessary parts.
- Apply video styles, borders, and effects to match your presentation’s theme.
- Customize how your video plays during the presentation, like setting it to loop or play full-screen.
- Overlay text or shapes to provide additional context or highlight key points.
![]() |
fig. 1 - Edit Video in PowerPoint |
- To trim a video, select it and click on ‘Trim Video’ under the Playback tab.
- To add effects, select ‘Video Effects’ under the Video Tools Format tab.
![]() |
fig. 2 - Trim Video in PowerPoint |