Splitting text in Excel used to mean wrestling with nested LEFT, RIGHT, MID and SEARCH formulas. Not any more. Excel 365 and Excel 2024 have three functions that do the job in one step: TEXTBEFORE, TEXTAFTER and TEXTSPLIT. TEXTBEFORE grabs everything before a delimiter, TEXTAFTER grabs everything after it, and TEXTSPLIT breaks a whole string […]
Wanna be a better, faster Office user? Impress your friends? Be the envy of women and men for miles around? Use simple keyboard shortcuts, called KeyTips, that you don’t have to memorize because they are on the screen. Instantly access Ribbon commands in Word, Excel, PowerPoint, and Outlook for Windows or Mac. Save time and […]
The Developer tab in Microsoft Office unlocks powerful tools like macros, form controls, and advanced customization features. Even if you’re not a programmer, many useful option, such as checkboxes, drop-down lists, and macro controls are hidden there. If the Developer tab is missing from Word, Excel, PowerPoint, or Outlook, you can easily enable it in […]
Creating clean, professional-looking stacked fractions in Microsoft Office is easier than many users realize, if you know where to look. The built-in Equation feature lets you insert vertical (stacked) and other fractions quickly, without hacks or manual formatting. Here’s the fastest and most reliable way to add proper mathematical fractions in Word, Excel or PowerPoint. […]
Calculating the ‘Standard Error of the mean’ or SEM is simple using Excel’s in-built functions. Understanding ‘Standard Error of the mean’ isn’t hard either. We’ll explain the formula and what it all means. To calculate standard error of the mean get the Standard Deviation of a sample (STDEV.S() or STDEV()) then divide by the square […]
