Excel Basics
Operators in Formulas
Selecting Cells
Clearing and Copying
Functions--Sum, Count, Max, Min, Average
Naming Cells
Functions--If, And, Or, Not
Functions--Sqrt, Log, Exp
Functions--Trig
Functions--Int, Mod, Sign, Abs, Pi
Sheets--Naming, Moving, Copying, Deleting
Tables--Setup, Naming, Entering Records
Tables--Adding Records, Freeze Panes
Tables--Sorting
Tables--AutoFilter
Tables--Inserting a Column
Tables--Validation from List
Tables--Related Tables & Vlookup
|
Large Sheet Fill
Large Sheet Select
Large Sheet Freeze
Functions--Rand
Random Numbers in a Range
Random Integers
Random with Discrete Frequencies
Macros--Sorting Macro
Macros--Button for Macro
Macros--Editing
Radix Investigations--Ten? Two? Precision?
Surface Plot--Introduction
Surface Plot--Example
Surface Plot--Flexible Domain
Surface Plot--Solid of Revolution
Download Blocked? |
Col-Row Labels in Formulas
Named Row-Col References
Solid of Revolution--Clean Up
Solid of Revolution--Cone
4th-order Runge-Kutta Page |