Monday, January 13, 2025
Python in Microsoft Excel: A Game Changer for Data Enthusiasts
Monday, January 6, 2025
Top Microsoft 365 Cool Tips in 2024
Monday, December 30, 2024
Discover the New Copilot Prompt Gallery in Microsoft 365
Monday, November 25, 2024
Compose Texts Using '&' in Microsoft Excel: A Simple Yet Powerful Formula
- Start by opening the workbook that contains the data you want to combine.
- Click on the cell where you want the combined text to appear.
- Type the formula =A2&" "&B2, replacing A2 and B2 with the cells you want to combine.
- Hit Enter to see the combined text in the selected cell.
- Drag the fill handle to copy the formula to adjacent cells if you need to combine text in multiple rows.
fig. 1 - Use & in Microsoft Excel to Combine Cells |
READ MORE
Monday, November 11, 2024
How to 'Clean Data' with Copilot in Excel
Monday, November 4, 2024
How to Use the Accessibility Checker in Microsoft 365 to Create Inclusive Content
- Open your document in Word, Excel, PowerPoint or OneNote.
- Go to the Review tab.
- Click on Check Accessibility. This will open the Accessibility Checker pane on the right side of the screen.
- Review the findings under Inspection Results. The checker lists any errors and warnings, along with recommendations on how to fix them.
- Apply the recommended actions to address each issue. Select an issue, view the recommended actions, and apply the fix directly from the pane.
fig. 1 - Check Accessibility |
fig. 2 - Check Accessibility Best Practices |
- Go to File > Options > Accessibility
- Select the option to show "Keep accessibility checker running while I work."
Monday, September 2, 2024
Throwback: Select An Excel Data Set Faster with this Shortcut
You can select data in Excel faster than just using a mouse and dragging the cursor.
Let your fingers do the selecting.
To select an entire data set, click anywhere inside the data set and then press and hold the CONTROL + SHIFT + * keys.
You can also click in the first cell you want to select and press and hold the Control+Shift and then press an arrow key (Left, Right, Up or Down) to select data in a direction.
Monday, August 19, 2024
How to Master 'Show Changes' in Microsoft Excel
Monday, August 12, 2024
Transform Your Handwriting into Editable Text with Microsoft 365 Ink to Text Pen
Monday, August 5, 2024
Discover Microsoft Excel's Modernized Grid
Monday, July 22, 2024
Future-Proof Your Files: Why Microsoft 365’s ODF 1.4 Update Matters
Monday, July 1, 2024
Inserting Checkboxes in Excel: A Comprehensive Guide
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
Thursday, May 30, 2024
Unlock the Power of ChatGPT: Effortlessly Analyze Excel Tables and Create Stunning Charts
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 |