When I was in high school, we used to plot points on graph paper and then try to fit a curve with some plastic templates named in undoubtedly sexist terms as French Curves. There was also a flexible ...

Create a CRM using Excel with dropdown customer selection and FILTER plus XLOOKUP, saving time while keeping leads and deals ...

Microsoft recently announced that they are adding a feature to Excel that will allow Python code to be embedded and used for advanced analytics. That made me wonder if it might be possible to create ...

Excel is that must-have tool for managing, analyzing and reporting on paid search campaigns that is impossible to know too well. Many of us are self-taught — picking up tips and tricks here and there ...

In my previous post, I showed you how to create a clickable button in Excel. That button displayed a simple message box. Now, I want to show you how to use the button to kick off a PowerShell script.

Life is hectic, and juggling dozens of apps for the "must-do" chores adds to the noise. Since I already work in Excel daily, ...

Excel, part of Microsoft Office, is a spreadsheet application used for almost infinite projects. Individuals often use Excel in the home for organizing personal data. Business incorporate Excel for ...

Microsoft Excel, part of the Office software suite, allows you to create business-oriented worksheets composed of columns, rows and cells. Within these containers, characters – including special ...

Today we have more handy Excel tricks from Bing Ads Evangelist John Gagnon. This second installment of PPC Excel tips focuses on intermediate level techniques for speeding up campaign analysis. Paid ...

In Part 1 of this blog, we looked at the way that Excel can help generate an equation that describes a curve based on collected data. Then, that curve can be linearized. We left off noting that the ...