Archive

Category Archives for "Excel Lessons"

OEE Solution – Querying Various Sheets

In this post we will pull together formulas that we’ve seen in these posts Formula to get first, second and third highest values Formula to get last row number http://blog.thejaytray.com/excels-indirect-function/ Data Validation Lists COUNTIF Function Before continuing, if you are not familiar with the above posts or functions I would recommend reading them.  Although I […]

Continue reading

Excel Logo Animation

In 2017 I will be creating my ExcelWithExcel.ie site, in preparation for this I had to design a logo. So, being an Excel geek, I thought why not create the logo in Excel….. so I did. When talking about animating the logo as an introduction to videos, I was challenged to animate the logo in […]

Continue reading
1 2 3 6
Follow

Get every new post delivered to your Inbox

Join other followers: