A list of all the articles that can be found on
openofficetips.com
FUNCTION TIPS
Basic Functions: FIXED
Formatting ratios
Filling a multiplication chart
Basic functions: CHOOSE
Rounding to the nearest nickel: MROUND()
Looking up data in tables V
Combining Data In Cells
Rounding Functions I
Easter Formula
Extracting a filename from a full path (Windows)
Cell Counting 1: COUNTIF
Using names for cell ranges
Text Formulas: Extracting First & Last Names
Looking up Data in Tables IV
Looking up Data in Tables III
Looking up data in tables II
Looking Up Data In tables I
Printing only non-zero values
Averaging non-zero values
Array Formulas: Working with Matrices
Basic Functions: SUM, AVERAGE
Basic Functions: LARGE, SMALL
Basic functions : REPLACE, SUBSTITUTE
Average a range without highest and lowest values
Basic Functions: HLOOKUP
Calculating weighted average
Basic Functions: INDEX, MATCH
Basic Functions: ISERR
Database functions: DAVERAGE
Basic functions: REPT
Basic functions : SUMIF
SUMPRODUCT and conditional summation
Text manipulation 1 : Concatenation
Basic Functions : CELL
Basic functions : SUBTOTAL
Basic Functions: FREQUENCY
Largest values in an array
Advanced Functions: INDIRECT
Counting letters in a string
Conditonal summation revisited
Ranking and sorting
Basic functions: TEXT
Splitting a string into characters
Counting unique entries in a range
Summing across sheets
MATHS & STATISTICS
Basic Functions: FORECAST, TREND, GROWTH
New
Lognormal distribution
Normal Distribution IV: Skewness
Normal Distribution III
Regression Analysis III : LINEST
Regression Analysis II : Basic functions, charting
Regression analysis I : Basic linear formulas
Generating the nth roots of a number
Random numbers: Normal Distribution I
Random numbers: Normal Distribution II
CHARTING
Charting : Introduction
Charting: Editing charts : part 3
Charting: Editing charts : part 2
Charting: Editing charts : part 1
Charting: Creating a Gantt chart
Charting: Creating a Candlestick chart
Charting: Pie charts
FORMS
Controls : PushButton
USING OPENOFFICE CALC
Instant Status Bar Statistics
New
Data Validation: Lists
Paste Special IV: Inserting rows
Paste Special III: Merging rows
Random sort
Paste Special II - Removing formulae
Paste Special I
Using Pop Up Notes in Cells
Checkerboard shading
Secret StarWars games
Using Names as constants
Conditional Formatting IV : Masking errors
Data Consolidation 101
Character Codes
Special Characters
Auto Filling Cells
Freezing row & column headers
Customizing a Toolbar
DataPilot 101
Data Filtering : AutoFilter
Selecting an entire sheet
Webquery : Importing HTML tables
Hyperlinks : Linking to a webpage
Goal Seek
Datasources : Spreadsheets
Data Filtering : Advanced Filter
Data Filtering : Standard Filter
Importing Tabular Data : CSV Files
Adding notes to cells
Autocorrect
Adding a background graphic
Creating Custom Cell Styles
Introduction to the Status Bar
Using the Navigator
Adding a background graphic
Data Validation 101
Copying Formulas while preserving references
Filling a Cell Range with a Series
Conditonal Formatting III
Conditional Formatting II
Conditional Formatting I
Datapilot revisited
Datapilot revisited II
OPENOFFICE BASIC
Macros: A Lotto Number Generator
Macros: Text Utilities Part I
Adding a dialog: Part I
Adding a dialog: Part II
Listing Cell Notes
Macros: Prime numbers
A Simple Macro: Fibonacci Numbers
A simple recursive macro: GCD
Macros: A simple clock
Macros: Getting Cell Information
Macro : Sorting sheets
Spelling out numbers
DATE & TIME
Creating A Series Of Workdays
Date & Time Basics
Date & Time : Calculating Dates of Holidays
Determining whether a year is a Leap Year
Date & Time : Calculating the end-of-month
Custom Time Formatting for a timesheet
Converting text to dates
FINANCE
Financial Functions: CUMIPMT & CUMPRINC
Financial Functions: Calculating Principal & Interest
Financial Functions 1 : Mortgage calculation
Financial Functions 3 : Complex Accumulation
Financial Functions 2: Accumulation
Webquery: Scraping FOREX quotes from Yahoo
Webquery: Scraping stock quotes from MSN
Rounding Numbers to Thousands and Millions
