 |
 |
 |
|
Customizing
Excel 
Customizing
tools bars
adding buttons
removing buttons
Creating custom buttons
using the optons dialog box |
|
|
|
 |
 |
 |
|
|
|
|
|
Moving data around a spreadsheet Pivoting
rows & columns
Creating
a pivot chart reports
Modifying a pivot chart
report
a what if analysis
Using smart tags
Opening
multiple windows |
|
|
|
|
|
|
|
|
|
|
|
Advanced
Data Display How
to use data markers
Using error bars
Using trend
lines
Summarizing data in lists |
|
|
|
|
|
|
|
|
|
|
|
Web
Pages & HTML
Inserting
a hyperlink III
Converting a worksheet to a webpage
creating interactive web spreadsheets
publishing pivot tables
sending workbook via email |
|
|
|
|
|
|
|
|
|
|
|
Document
Tools
mapping
your
spreadsheet
creating
multiple versions
vewing
document versions
deleting
versions
creatign
a workbook index
does
cell have formula function.
creating
an advanced lookup table |
|
|
|
|
|
|
|
|
|
|
|
|
Work
Book Settings
Sharing
workbooks
Routing workbooks
Merging workbooks
Publishing work books to the internet.
Linking workbooks with formulas Limitations of shared workbooks or Grouping worksheets
File compatibility |
|
|
|
|
|
|
|
|
|
|
|
Using
If Statements Validating
cell entries
Filtering data
Sorting data |
|
|
|
|
|
|
|
|
|
|
|
Using
Advanced Formulas Creating
user defined constants
vlookup when setting ranges of user defined functions. |
|
|
|
|
|
|
|
|
|
|
|
Advanced
Stats
Functions
The
LARGE()
function
The
SMALL
()
function
The
STDEVA()
function
The
STDEVPA
function
The RAND() function
The RANDBETWEEN() function
The VAR() function
The COVAR() function
The VARP() function
The VARAP() function
The PROB() function
The QUARTILE() function
The LINEST() function
The LOGEST() function
The CONFIDENCE function
The INTERQUARTILE() function
The SKEW() function
The GEOMEAN() function
The HARMEAN() function |
|
|
|
|
|
|
|
|
|
|
|
Ditribution Functions
The
NORMSDIST function
The BETADIST() function
The GAMMADIST() function
The CHIDIST() function
The
FDIST() function
The BINOMDIST() function
The CRTBINOM() function
The HYPGEOMDIST() function
The NEGBINOMDIST() function
The POSSION() function
The NORMSIV() function
The BETAINV() function
The GAMMAINV() function
The CHIINV() function
The FINV() function
The TINV() function |
|
|
|
|
|
|
|
|
|
|
|
|
Reference
Functions
The
VLOOKUP()
function
VLOOKUP
across
multiple
sheets
The
LOOKUP()
function
The
HYPERLINK()
function |
|
|
|
|
|
|
|
|
|
|
|
Working With
Office Apps
Importing
data
query and
external database
importing text files
imporitng xml data
Exporting data
Exporting data from Excel into a database (Access)
exporitng text files
exporting xml files |
|
|
|
|
|
|
|
|
|
|
|
Templates
Working
with built in templates
editing templates
Creating Excel Templates |
|
|
|
|
|
|
|
|
|
|
|
Sharing Documents
Protecting
workbooks
protecting worksheets
sending your workbook via email |
|
|
|
|
|
|
|
|
|
|
|
Advanced
Charts
Creating
a water fall chart
2-axis logarithmic charts
Creating a 4 quadrant chart
Creating a Gantt chart
Creating an organizational chart/diagram
Printing
charts |
|
|
|
|
|
|
|
|
|
|
|
Advanced
Chart Fortmatting
changing axis locations
axis view data with chart
creating dual axis charts |
|
|
|
|
|
|
|
|
|
|
|
3D
Charts
3D scatter graphs
Contour map or surface map
3D bubble plots
3d bar charts
3d Histograms
3d pie charts |
|
|
|
|
|
|
|
|
|
|
|
User
defined functions & Plugins
How
to create your own function Downloading and
using custom functions |
|
|
|
|
|
|
|
|
|
|
|
Working
with Macros What
is a macro
recording and running a macro
the relative nature of macros
editing a macro
debugging a macro
animating a chart with a macro animating a line chart
controlling charts with buttons controlling charts with list boxes
working with vba code
funcion procedures |
|
|
|
|
|
|
|
|
|
|
|
Pivot Tables
rearranging
pivot tables
formatting pivot tables
creating pivot charts |
|
|
|
|
|
|
|
|
