MeadInKent
| Feedback | Google search on Excel |

A detailed index of Excel Help available on this site

A to L M to Z

#, 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

facebook

Index lists created using 'MeadInKent Index.xls'


file: xlidx.htm © meadinkent.co.uk 2016 CMIDX S0 P2 X Page last modified Dec15