HODADAK - DEV Community

HODADAK

Oct 23

Word table basics: add rows, insert columns, merge cells, delete rows

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 22

Turn a Prose Report into Bullet Points with One ChatGPT Prompt

#chatgpt #productivity #writing #beginners

2 min read

HODADAK

Oct 22

PowerPoint for the web slideshow shortcuts that actually work

#powerpoint #productivity #beginners #tutorial

2 min read

HODADAK

Oct 21

Excel SUM wrong? Fix numbers stored as text with Text to Columns

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 21

Excel text cleanup functions: LEN, TRIM, SUBSTITUTE, TEXTJOIN, LEFT

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 20

Excel row numbers that stay in order after deleting rows: =ROW()-1

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 20

PowerPoint slide numbers: number every slide, skip the title slide

#powerpoint #productivity #tutorial #beginners

2 min read

HODADAK

Oct 20

Excel date functions: EDATE, EOMONTH, NETWORKDAYS, WORKDAY, DATEDIF

#excel #productivity #tutorial #beginners

3 min read

HODADAK

Oct 19

Excel custom number format: add units without breaking SUM

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 19

Word Heading 1 style: change one heading, update them all

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 19

SUMIF vs SUMIFS vs COUNTIFS: which Excel function to use when

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 18

Excel for the web Ctrl+L table shortcut and an automatic Total Row

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 18

Excel weekday from a date with TEXT: Mon, Tue, Wed in one formula

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 18

Business Email Openers: First Lines for Five Common Situations

#writing #productivity #career #beginners

2 min read

HODADAK

Oct 17

PowerPoint Morph Transition: Animate Shapes Between Two Slides

#powerpoint #productivity #tutorial #beginners

2 min read

HODADAK

Oct 17

Word Page Numbers: Show \"1/5\" Automatically and Skip the Cover

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 17

Windows 11 Snap Shortcuts: Arrange Windows With Win + Arrow Keys

#windows #productivity #beginners #tutorial

2 min read

HODADAK

Oct 16

Excel Transpose: Swap Rows and Columns With Paste Options

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 16

Excel Status Bar: Check Sum, Average, Min and Max Without Formulas

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 16

PowerPoint Shortcuts for Shapes: Select, Duplicate, Group, Ungroup

#powerpoint #productivity #tutorial #beginners

2 min read

HODADAK

Oct 15

Word Tables: Repeat the Header Row on Every Page

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 15

PowerPoint Designer: Turn a Bulleted List Into a SmartArt Diagram

#powerpoint #productivity #tutorial #beginners

2 min read

HODADAK

Oct 15

Excel Error Values Explained: #N/A, #DIV/0!, #VALUE! and More

#excel #beginners #productivity #tutorial

1

2 min read

HODADAK

Oct 14

Excel XLOOKUP: Pull Prices From a Lookup Table in One Formula

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 14

Excel Conditional Formatting: Highlight Overdue Dates Automatically

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 14

ChatGPT Excel Formulas: Four Details to Put in Your Prompt

#chatgpt #excel #ai #productivity

2 min read

HODADAK

Oct 13

Excel Ctrl+; Shortcut: Insert Today's Date as a Fixed Value

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Word Paste Options: Ctrl+V, Ctrl+Shift+V and Keep Text Only

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

File Naming Conventions That Sort by Date: 4 Simple Rules

#productivity #beginners #tips #organization

2 min read

HODADAK

Oct 13

Excel Number Format Shortcuts: Currency, Percent, Time and Borders

#excel #productivity #beginners #tips

2 min read

HODADAK

Oct 13

Google Search Operators for Work: site:, filetype:, Quotes, Minus

#google #productivity #beginners #tips

1

2 min read

HODADAK

Oct 13

Word Formatting Shortcuts: 6 Keys for Clean Report Layouts

#word #productivity #beginners #tips

2 min read

HODADAK

Oct 13

Excel Table Shortcuts: 7 Keys That Replace Mouse Dragging

#excel #productivity #beginners #tips

2 min read

HODADAK

Oct 13

Word Translator: Translate a Selection Without Leaving Word

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Excel Drop-Down List with Data Validation: Stop Typo Statuses

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Word Track Changes: Show Every Edit, Then Accept All

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Excel Remove Duplicates: Clean a List in One Step

#excel #productivity #tutorial #beginners

1

2 min read

HODADAK

Oct 13

Word Table of Contents: Build and Update It Automatically

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Excel Freeze Panes: Keep Header Rows and Name Columns Visible

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Word Format Painter: Copy Heading Formatting in One Click

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Excel Absolute References with F4: Fix Formulas That Return 0

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Word Find and Replace (Ctrl+H): Change or Delete Text Everywhere

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Excel AutoSum Shortcut (Alt+=): Totals Without Typing SUM

#excel #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Word Page Break Shortcut (Ctrl+Enter) Instead of Pressing Enter

#word #productivity #tutorial #beginners

2 min read

HODADAK

Oct 13

Excel Flash Fill (Ctrl+E): Clean Up a Column Without Formulas

#excel #productivity #tutorial #beginners

2 min read

Writing Debut