Tags » Excel 2007

Pivot a Row or Column of Data in Excel

Excel is a great tool for data manipulation. One feature that can come in handy is the ability to pivot a data row into a column or pivot data in a column of information into a row. 157 more words


Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time: 728 more words


Getting it Right

To err is human, to forgive divine, but to correct and learn from error is the route to improve quality.

Philosophers, psychologists, and ergonomists have spent lifetimes classifying and analysing human error; if you want a sound and readable introduction, I can recommend any of James Reason’s excellent books. 643 more words


Excel 2007- dən imtina etmək üçün 7 səbəb

2015-ci ildə olmağımıza baxmayaraq Excel istifadəçilərin böyük hissəsi hələ də 2007 və 2010 versiyalarından istifadə edir. Bu yazımızda bunun heç də yaxşı fikir olmadığını, 2007-ni 2013-ə dəyişdiyimiz anda qazandıqlarımızı görəcəyik. 662 more words


MS EXCEL 2007 Keyboard Shortcuts

1. Navigating in Worksheets and Selecting Cells Action 2,739 more words

Two New Cases

Here are two new Excel based cases I have just prepared that I know some of you will appreciate.

UK Petrol Prices

I downloaded a file of all retail petrol and diesel prices for the UK from 2003 to 2014. 200 more words

Intro to the Excel VBA Editor

This post is not about learning to code, it’s about where to find your way around the basics of the Excel VBA developer interface. If you’re just getting started with VBA programming, this should help give you an idea of where to find the tools you need. 1,050 more words