Microsoft MVP Microsoft 365 • LibreOffice Automation • Business Intelligence • Productivity Tutorials • Templates • Courses
Lexington, KY
Joined September 2023
- Tweets59
- Following321
- Followers130
- Likes23
Still using Ctrl+K to create hyperlinks in Microsoft Word? There's an easier way!
Copy a website URL, highlight your text, and press Ctrl+V. That's it! Ctrl+K still works, but this shortcut is faster.
#MicrosoftWord #Microsoft365 #WordTips
10
Viewer Requested Tutorial
Learn to print specific pages, multiple page ranges, and selected text without printing the entire document. @LibreOffice
Watch: youtu.be/a1rj47UdsyQ
#LibreOffice #LibreOfficeWriter
Still filtering Excel tables with drop-downs? Use Slicers for cleaner, faster filtering. #Excel #MicrosoftExcel #ExcelTips #Data
31
Deleting blank rows one at a time? Don’t.
Use Go To Special → Blanks → Delete Entire Row.
Done in seconds. #Excel #ExcelTips #Productivity
1
14
Manually bolding totals? Hard-coding row numbers? There’s a better way. Automatically bold totals in Excel and build a dynamic SUM that won’t break when rows move. #Excel #ExcelTips #ConditionalFormatting #Spreadsheet
12
Paste Special not working in Excel? Greyed out or shortcut won’t open? Here’s a full troubleshooting guide covering clipboard state, protection settings, add-ins, and VBA conflicts.
Watch here: youtu.be/-GtA23bz4Y4
#Excel #MicrosoftExcel #PasteSpecial #ExcelTips #Microsoft365
20
Stop manually numbering rows in Excel. Use SEQUENCE for ranges or a Table + ROW formula for stable, auto-updating numbering that adjusts when rows are added or deleted. #Excel #MicrosoftExcel #ExcelTips #Excel365
13
Excel removing leading zeros? Use custom number formatting to keep IDs and invoice numbers intact. #Excel #ExcelTips #Microsoft365
10
Model or Mess? Here’s how to design structured Excel models that are clear, consistent, and safe to hand off — plus a practical audit checklist. Template available on website.
Watch →youtu.be/bm9iAzs6NKY
#Excel #SpreadsheetDesign #BusinessExcel #Microsoft365
28
Align Excel charts cleanly for presentations and dashboards. Select them once, align and distribute, done. #Excel #ExcelTips #DataVisualization
10
Inherited an Excel file and afraid to touch it? Learn how to find formulas, see what they affect, and fix errors so you can update data with confidence.
#Excel #ExcelFormulas #AuditExcelFormulas
youtu.be/2OrC5e03uoM
22
Compare data between two columns and have Excel flag changes automatically. Perfect for audits, order updates, and reviews.
#Excel #ExcelTips #MicrosoftExcel #DataValidation #Productivity
1
17
Stop right-clicking to duplicate Excel sheets. Hold CTRL, drag the sheet tab, and drop it where you want — instant copy.
#Excel #ExcelTips #Productivity
1
22
Stop right-clicking to duplicate Excel sheets. Hold CTRL, drag the sheet tab, and drop it where you want — instant copy.
#Excel #ExcelTips #Productivity
Excel workbook slow or crashing? Deleting rows isn’t always the fix. This video explains why Excel performance issues are usually caused by how the workbook is designed. #Excel #ExcelPerformance #ExcelTips
youtu.be/iYsXOVc0Vis
16
We can automatically strike through rows when a task is complete using Excel’s built-in checkboxes and conditional formatting. No VBA required.
#Excel #MicrosoftExcel #ExcelTips #Productivity #BusinessExcel
Gridlines are helpful when building spreadsheets, but they clutter reports when presenting. Turn them off in Excel for a cleaner, more professional report. #Excel #MicrosoftExcel #ExcelTips #ExcelForBusiness
13
Data doesn’t always come into the right columns. Here’s how to split text into columns in Excel. #Excel #MicrosoftExcel #ExcelTips #Spreadsheets
1
11