- #, numbers replaced with
- #N/A
- & operator
- Abs()
- Access data, Excel links
- Add data to a list using a form
- Adding a range of numbers
- 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
- Buttons, adding a macro
- Buttons, placing on worksheets
- Cell comments
- Cell names
- Cell protection
- Cell references as text
- Cell values, reading a location
- Cell() to display filename
- Chart, title or axis linked to cell
- Chart, pictures in bars
- Charts, avoiding zero values
- Choose()
- 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
- Conditional sums, choice of functions
- Confidence()
- Configuring excel
- Convert numbers to words
- Costing and pricing
- Count()
- CountA()
- Criteria (array functions)
- Criteria (database functions)
- Criteria (SumProduct function)
- 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
- Excel WebApp
- Exporting data as text files
- External data source, Access
- 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()
- Get External Data, from Access
- 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
- Indirect(), cell references
- Input form to enter data
- Int()
- Interest
- Interest on Loans
- Internal rate of return (IRR)
- Investment appraisal
- IsError()
- Isna()
- Javascript, display Excel tables
- Javascript, display variable on web page
- Keyboard shortcuts
- Large()
- Linking Excel to Word
- List boxes
- Lists, choosing an option
- Loan repayments
- Logical functions
- Lookup values on table
|
- Macro workbook, Personal.xlsm
- Mail Merge, Excel data source
- 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
- Office Leave Planner, Excel version
- Offset()
- Or()
- Organisation charts
- Output to text file
- Parsing text data
- Paste Link
- Pay enhancements for shifts
- PDF file, Output options
- Personal.xls, macro workbook
- Pictures in chart bars
- PMT()
- PowerPoint, displaying excel using
- Precedent cells
- Principal outstanding on loan
- Probability
- Project appraisal
- Protection of cells
- Publish as PDF or XPS file
- Quartiles, statistics
- Quick Access Toolbar
- Rank()
- Regional settings for date formats
- Repayment of Loans
- Repayments
- Rept()
- Ribbon buttons, modifying
- Ribbons
- Risk
- Save as HTML
- Search for value
- Series(), defining charts
- sheet.xlt
- Shift pay enhancements
- Shortcuts, keyboard
- Shortcuts, to run a macro
- Skydrive, online Excel files
- Small()
- Standard deviation
- Statistics
- Styles, numbers
- Sum()
- Sum() in array functions
- SumProduct()
- 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
- Validation
- Value()
- VBA forms and modules
- VLookUp()
- Waterfall charts
- Web Apps, Online
- Web pages from Excel (basic)
- Web pages with more formatting
- Web pages, display Excel tables
- Web pages, display variables
- Weekday()
- Weighted average()
- Word docs, update using Excel
- Word Mail Merge linked to Excel
- Worksheet names, a function
- Worksheet settings, default
- Xlstart
- XML files, save as
- XML, viewing in web pages
- XML, viewing with XSL
- 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
|
