Monday, July 22, 2024
Future-Proof Your Files: Why Microsoft 365’s ODF 1.4 Update Matters
Tuesday, July 2, 2024
Math: OneNote’s Hidden Superpower
Monday, July 1, 2024
Inserting Checkboxes in Excel: A Comprehensive Guide
Thursday, June 27, 2024
Boost Your iPhone Productivity with the New Microsoft 365 Widget
Friday, June 21, 2024
Gather Feedback Like a Pro with Microsoft Forms
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, April 1, 2024
Effortless Data Sharing: Your Ultimate Guide to Exporting CSV Files from Excel Online
- Open a spreadsheet in Excel for the web.
- With your 365 subscription, go to Office and select "Excel"
- Navigate to the ‘File’ tab within and select ‘Export’.
- Choose ‘Download this sheet as CSV’ from the dropdown menu.
- Save the file to your desired location.
![]() |
fig.1 - Export CSV from Excel on the Web |
- Open the workbook you want to export.
- Click on the File tab at the top-left corner.
- Select Save As and choose the location where you want to save the file.
- In the Save As dialog box, click the dropdown arrow in the Save as type box.
- Choose CSV (Comma delimited) (*.csv) from the list of file types.
- Click Save.
- Ensure the data is properly formatted in Excel before exporting to avoid any discrepancies in the CSV file.
onecooltip.com@gmail.com
Monday, March 25, 2024
Unleashing the Power of TEXTSPLIT: Excel’s Game-Changing Formula
- Open your Excel workbook
- Locate the cell where you wish to use the TEXTSPLIT function.
- Enter the TEXTSPLIT function:
- =TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
- The text you want to split. Required.
- col_delimiter The text that marks the point where to spill the text across columns.
- row_delimiter The text that marks the point where to spill the text down rows. Optional.
- ignore_empty Specify TRUE to ignore consecutive delimiters. Defaults to FALSE, which creates an empty cell. Optional.
- match_mode Specify 1 to perform a case-insensitive match. Defaults to 0, which does a case-sensitive match. Optional.
- pad_with The value with which to pad the result. The default is #N/A.
- Press Enter and watch as Excel splits the text into separate cells.
![]() |
fig. 1 - Microsoft Excel TEXTSPLIT |
onecooltip.com@gmail.com
Monday, March 18, 2024
How to Harness the Power of Real-Time Collaboration in Microsoft Word
- Save your Word document to OneDrive or SharePoint (for Enterprise customers).
- Share the document with your team by clicking Share on the ribbon and entering their email addresses.
- Team members can then open the document in Word for the web or the Word desktop app.
- As edits are made, they appear in real-time, with each collaborator’s cursor labeled with their name.
![]() |
fig. 1 - Microsoft Word Document Share |
onecooltip.com@gmail.com
Monday, February 19, 2024
Unlock the Full Potential of Your Presentations with Microsoft Copilot Pro in PowerPoint
- Ensure you have a Microsoft 365 subscription that includes Copilot Pro.
- Make sure your PowerPoint is updated to the latest version to access all features.
- Open PowerPoint and locate the Copilot chat window, usually found in the corner of your screen.
- Type prompts or commands into the Copilot chat to edit, format, or design your slides.
- Ask Copilot to reformat text, adjust layouts, animate slides, and generate speaker notes.
![]() |
fig. 1 - PowerPoint Copilot Prompt to Generate a PowerPoint Slide Presentation |
![]() |
fig. 2 - Copilot Creates a PowerPoint Slide Deck |
Monday, February 12, 2024
How to Use Copilot Pro in Microsoft 365 Word to Create and Edit Documents More Efficiently
- Open Microsoft 365 Word and create a new blank document.
- In the “Draft with Copilot” floating box, type or paste your prompt describing what you want the AI to generate.
- For example, “Write a proposal for a new Work from Home policy for our employees that does not require HR or Management approval in advance, that starts March 1, 2024 and allows employees to work from home two days each week."
![]() |
fig. 1 - Copilot Prompt in Microsoft 365 Word |
- Click the “Generate” button.
- Copilot Pro creates a draft with new content.
![]() |
fig. 2 - Copilot Pro AI Prompt - Work from Home Policy |
- Once Copilot generates content, select:
- “Keep it” to keep the content,
- The “Regenerate” icon to regenerate a response,
- The “Discard” icon to discard the content, or
- Fine-tune the draft by entering details into the compose box, like “Make it more concise.”
- Remember that Copilot for Microsoft 365 generates a draft. You’ll need to verify and modify details to make sure it’s accurate and fits your tone and style. If the draft isn’t exactly what you’re after, or if Copilot wasn’t able to complete the task, try modifying your prompt by adding specific details, such as “…employees must be in the office on each Monday.”
- You can also fine-tune your result by entering details into the compose box in Copilot’s options bar after a response is created. The Copilot icon is on the Word Ribbon menu.