Quantunet.com

My Account

Joins Us
Excel 2003 Knowledegbase
Intermediate Excel Knowledgebase

Courses & Lessons
Short Cuts
ClickByClick
QuickSkills
Worksheets
Knowledgebase
Functions Library
DG Tutorials
AV Tutorials

Data & Cells
Entering Data into Cells
Types of cell entries

Copy and paste
Autofill Labels
The formats s for cell entries Excel justifies text by default Data
Fractions
Decimals-Excel uses two decimal places by default
Percentages
Dates

Worksheets & Workbooks
The concept of the worksheet

Functions & Formula
Controling calcualtions

Intermediate Math Functions
Methods of inserting functions
Recalculating functions & formaula

Math Functions
The Analysis Toolpak
The EXP() function
The POWER() function
The LOG() function
The LOG10() function
The LN() function

The EVEN() function
The ODD function
The LCM() function
The GCD() function

The COUNT() function
The COUNTA function
The COUNBLANK function
The COUNTIF() function
The SUMIF function
The SUMIFS fucntion
The SUMPRODUCT() function
The SUMSQ() function
The SERIESSUM() function
The SUBTOTAL function

Intermediate Stats Functions

The AVERAGE() function
The AVERAGEA() function
The MEDIAN() function
The MODE() function

The PERMUT() function
The COMBIN() function

The RANK() function
The LARGE() function
The SMALL() function

The STDEV() function
Building a STDEV function in excel
The PERCENTILE() function
The PERCENTRANK() function
The FREQUENCY() function
The RSQ() function
The TREND() function
The GROWTH() function
The PEARSON() function
Intermediate Trig Functions

The secant function
The cosecant function
The cotangent function
The inverse secant function
The inverse cosecant function
The inverse cotangent function

Date & Time Functions
The Date & Time
The date system
Problems with thte date system
The time system

The NOW() function
The TODAY() function

The TIME() function
The TIMEVALUE() function
The HOUR() function
The MINUTE() function
The SECOND() function

The DAY() funvtion
The MONTH() function
The YEAR() function
The YEARFRAC() function

The WEEKDAY() function
The WEEKNUM() function
The WORKDAY() function
The NETWORKDAYS() function

The DATEVALUE() function
The DATE() function

The DAYS360 funvtion
The EOMONTH() function
The EDATE function
The DATEDIFF() function

Business/Finalncial Functions The INTRATE() function
The RATE() function
The NOMINAL() function
The RECIEVED() function
The PV() function
The NPV() function
The PMT() function
The EFFECT() function
The IPMT() function
The IRR() function
The PRICE() function
The YEILD() function

Text and Data Functions

The LOWER() function
The UPPER() function
The VAUE() function
The ROMAN() function

Logical Functions
The TRUE function
The FALSE function

The AND function
The OR function
The NOT function

The IF function
Nested IF functions
The IFERROR() function

Chart Properties & Tools
Histograms
Pictograms
Histograms vs bar charts

Scatter chart trend lines
Different types for error display demo

Advanced Formatting
Conditional formatting
The pivot table
The pivot chart

© 2008 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us