top of page
Search


My Journey as an Online Instructor: A Conversation with Damon Lembi
I recently had the opportunity to sit down with Damon Lembi and share my journey as an online instructor. We talked about how I got started, the ups and downs along the way, and what I’ve learned building a career teaching millions of students around the world. And if you’ve ever taken one of my courses, you’re part of that story! If you’re an educator, entrepreneur, content creator, or simply someone trying to build something of your own, I think you’ll enjoy the conversatio
Kyle Pew
4 days ago1 min read


Stop Manual Formatting in Word
If you manually format headings in Microsoft Word, you’re doing extra work—and breaking your document. Bold text, font size changes, and spacing tweaks do not create structure. Because of that, Word can’t properly build things like a Table of Contents. The Fix: Use Styles Word Styles tell Word what your text is, not just how it looks. When you use Heading 1 and Heading 2: Word knows what sections are A Table of Contents generates instantly Updates happen automatically Formatt
Kyle Pew
Apr 231 min read


Excel WRAPROWS: Turn a List Into Rows Instantly
The WRAPROWS function in Excel lets you take a long list and automatically arrange it into rows — perfect for labels, grids, or clean layouts. No copying. No dragging. Just one formula. Syntax WRAPROWS(vector, wrap_count, [pad_with]) vector — your list wrap_count — items per row pad_with — optional fill value Example Column list: Formula: =WRAPROWS(A2:A7,3) Result: Real Use WRAPROWS is great for: Mailing labels Product layouts Seating charts Print grids Watch the full WRA
Kyle Pew
Feb 271 min read


Referencing Spilled Arrays in Excel (Using the # Operator)
If you’ve started using modern Excel functions like VSTACK or FILTER , you’ve probably noticed something new — formulas that return multiple results that spill into surrounding cells. But then the next question comes up: How do you reference those spilled results in other formulas or sheets? The answer is the # spill reference operator . When a formula spills, you can reference the entire result using just the first cell plus #. Example: =A2# That means: use the whole spill
Kyle Pew
Feb 231 min read
bottom of page



