Blog Archives

File Formats

Posted on May 14, 2009 by Yilmaz Rona — No Comments ↓

Background In the coming years, there will be a file format war that will be reminiscent of the DVD format wars of the mid 2000′s. To most people, this war will seem like a tempest in a teapot, a bunch…

Posted in Design and Needs Analysis, Microsoft Office, Open Office, Uncategorized

Adding Custom Functions to Microsoft Excel

Posted on April 6, 2009 by Yilmaz Rona — No Comments ↓

Anybody who works extensively with Excel has found themselves in the hell of nested ‘IF‘ functions. This week I will show you how to write a function that you can embed into your formula field for a particular cell. The…

Tagged with: Customizing Excel, Excel, Microsoft Excel, VBA, Visual Basic for Applications
Posted in Excel, Visual Basic for Applications (VBA)

Analyzing and Graphing Lab Data with Open Office Calc

Posted on March 21, 2009 by Yilmaz Rona — No Comments ↓

One of the most important uses of spreadsheets in business, academia and for fun is in the statistical analysis of data. For many students on a shoestring budget, this means the use of the free to use OpenOffice Calc. While…

Tagged with: Calc, chart, graph, graphing data, OpenOffice, Statistical Analysis
Posted in Calc, Data Analysis, Open Office

Navigating the Word 2007 Menu System

Posted on February 28, 2008 by Yilmaz Rona — No Comments ↓

Note: This post will be updated repeatedly in the coming months as I learn new things about office 2007 and have time to make improvements. Introduction Microsoft Office 2007 comes with a radical redesign of the User Interface. People who…

Tagged with: Help, Microsft Office 2007, New User, Saving Word Documents, Word 2007
Posted in Microsoft Office