Microsoft Excel News Express

So who is up for an Excel challenge? Shelly, who is an HR Manager sent this distress call last week, First off, I LOVE your site. It is the first place I go for any excel question and I love the daily ...Read More »

Now when is that neighborhood planning meeting and will it conflict with the business dinner your boss just asked you to attend? Your calendar is so full that scanning it won't help. You might not know that the Outlook Calendar ...Read More »

Last week at the Chandoo.org Forums, Senthilkumar_rm posed the question: “I Have file name as D:\Data\Personal\sramasam\desktop\Exceldata.xls I want to find the position of the 4th slash “\” What is a simple way ? ”   I proposed 3 answers being: =FIND("\",A1,FIND("\",A1,FIND("\",A1,FIND("\",A1)+1)+1)+1) =SEARCH("\",A1,FIND("\",A1,FIND("\",A1,FIND("\",A1)+1)+1)+1) =FIND(CHAR(135),SUBSTITUTE(G5,"\",CHAR(135),4)) and Faseeh proposed a 4th answer: =(LARGE(((MID($A1,ROW(INDIRECT("1:"&1024)),1))="\")*ROW(INDIRECT("1:"&1024)),2)) So today ...Read More »

Do your spreadsheets smell? This week, a tweet from Felienne Hermans caught my eye. "Our @icse2012 paper on spreadsheet smells already has a citation before publication" Spreadsheet smells? I've seen some stinky spreadsheets, but have never read a conference paper on spreadsheet ...Read More »

Issue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views by site ...Read More »

We're always looking for ways to improve our products and provide content that meets your needs. So this post introduces you to two brand new SmartArt graphics -- Hexagon Radial and Picture Frame. This is the third in our series of ...Read More »

Please participate an improved, small, non-scientific survey about spreadsheet version usage. My previous survey allowed only one version of Excel to be selected for work and for home. I knew that this was limiting, but the survey seemed easier to set ...Read More »

Hello folks, I have a quick announcement. As you may know, I am doing a set of Excel & Dashboards Masterclasses in Sydney, Melbourne & Brisbane. We had a fantastic session in Sydney (with 18 delegates). We are sold out in ...Read More »

In creating a table header that explains what the row and column values represent, a common approach is to use a cell with text separated by a diagonal line. This, first for me, video tutorial explains how. For those who ...Read More »

Microsoft Office 365 is an online business service that was purposely built to optimize the flexibility, responsiveness, and efficiency of the cloud. It was also created with a strong emphasis on data protection and with Microsoft's three tenets of privacy ...Read More »