Excel doesn’t have a direct equivalent. To achieve the same result, you’d either have to piece together complex formulas with functions like SEARCH or write custom VBA scripts. While those approaches ...

Microsoft Excel turns 40 today, and the company has outlined plans for future updates set to transform how we work with data.

That all changed when I discovered two features in Excel most people don't know about: Watch Window and Custom Views. Together, they provided me with a way to track the numbers that matter without ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee ...

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates. Explore Get the web's best business technology news, tutorials, reviews, trends, ...

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Thomas J. Brock is a CFA and CPA with more than 20 years of experience in ...

If you’re feeling particularly spreadsheet-y today, this BBC podcast highlights some interesting details about the creation of Excel, including Gabe Newell’s involvement and how developers wanted to ...