#, numbers replaced with
#N/A
& operator
Abs()
Add data to a list using a form
Adding a range of numbers
Address()
Advanced filters
Age, the difference between dates
And()
Array functions
Audit toolbar
Autosum
Average()
Average, weighted
Balanced scorecard
bandings, grouping values in
Best fit lines on Charts
book.xlt
Books about Excel
Bridge charts
Bullet Points in text
Buttons, adding a macro
Buttons, placing on worksheets
Calculation, Manual or Auto
Cell comments
Cell names
Cell protection
Cell references as text
Cell values, identify a location
Cell() to display filename
Char(), ASCII characters
Chart, axis linked to cell
Chart, pictures in bars
Charts, avoiding zero values
Choose()
Code(), ASCII characters
Color and ColorIndex properties
Colour scales, conditional formatting
Colours, background and font
Combining text from different cells
Combo boxes
Comma separated text
Comments in cells
Compound interest
Concatenating cells
Conditional formatting
Confidence()
Configuring excel
Convert numbers to words
Costing and pricing
Count()
CountA()
Criteria (array functions)
Criteria (database functions)
Criteria (SumProduct function)
CumPrinc() and loans
Data Bars, conditional formatting
Data validation
Database functions
Date and Time formats
Date format codes
Date()
Datediff()
Dates and times as values
Daverage()
Default headers and footers
Default number styles
Default worksheet settings
Dependent cells
Design of good worksheets
Display cell formula
Division by zero
Drop down lists
Dsum()
Error testing
Errors, spreadsheet design
Extract text from string
Extremes, excluding outer values
File name, with directory path
Filtering a table of data
Financial functions
Financial management
Find value in table
Find()
Fixed width text
Formats, numbers and dates
Formatting, conditional
Forms, an input form for data
Formula, displaying
Frequency()
Functions, introduction
FV()
Google Docs forms
Goto special
Graphs, see charts
Grouping values into categories
Hidden personal workbook
Highlighting exceptional values
HTML pages from Excel
Hyperlinks
If()
IF() in array functions
iFrames in HTML
Index(), referring to cells in a table
Indirect(), cell references
Input form to enter data
Int()
Interest
Internal rate of return (IRR)
Investment appraisal
IsError()
Isna()
Keyboard shortcuts
Large()
Linking Excel to Word
Links to other Workbooks
List boxes
Lists, choosing an option
Loan repayments
Logical functions
Lookup values on table
|
Macro workbook
Management accounting
Mapping a spreadsheet
Match()
Max()
Mean()
Median()
Mid()
Min()
Mod()
Mode()
Multiple criteria
Name and location of file
Name box
Named ranges
Net present value (NPV)
Normal distribution
Now()
Number format codes
Number styles
Numbers as words
Offset()
OneDrive, Excel online
Or()
Organisation charts
Output to text file
Parsing text data
Paste Link
personal.xls
Pictures in chart bars
PMT()
PowerPoint, displaying excel using
Precedent cells
Principal outstanding on loan
Probability
Project appraisal
Protection of cells
Quartiles
Quick Access Toolbar
Rank()
Regional settings for date formats
Repayments
Rept()
Ribbon buttons, modifying
Ribbons
Risk
Save as HTML
Search for value
Series(), defining charts
Sheet.xlt, template
Shortcuts, keyboard
Shortcuts, to run a macro
Small()
Standard deviation
Statistics
Styles, numbers
Sum()
Sum() in array functions
SumIf()
SumProduct()
Symbols in text
Testing worksheets for errors
Text files, exporting to
Text splitting to fields
Text to columns
Text values to numbers
Text()
Text, splitting up strings
Time()
Time, calculating more than 1 day
Toolbars, adding a macro
Traffic lights, conditional formatting
True and False
Unique values in a list
Validation, drop down list
Validation, exceptional values
Value()
VBA forms and modules
VLookUp()
Volatile functions
Waterfall charts
Web pages from Excel (basic)
Web pages with more formatting
Weekday()
Weighted average()
Word docs, update using Excel
Worksheet names, a function to retrieve
Worksheet settings, default
Xlstart
XML files, save as
Zero values on Charts
Search the internet for help on Excel - a custom search engine powered by Google -
[Click here]
Links to external (MS) pages with information about making the transition
to Excel 2010
|