S

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

salvage arguments (depreciation)
saving files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
        as PDFs 2nd 3rd
        in older formats 2nd 3rd 4th 5th
        macros
        password protection 2nd 3rd
        Save As command
Scale with Document option (headers/footers)
scales
        category axis scaling
        dates and times as
        logarithmic
        tick marks
scaling (printing)
scatter charts
scenarios 2nd 3rd 4th 5th 6th
        merging
        storing Solver results in
        worksheet protection and
schemas
        mapping with
scientific data 2nd 3rd
Scientific format
scrap value
Screen (image resolution setting)
scroll buttons
scroll mode 2nd
scroll wheel (mouse)
        zooming with
SEARCH() function
SECOND() function
security
        macros and 2nd 3rd 4th 5th 6th 7th
selecting
        AutoSelect
        cells 2nd 3rd 4th 5th 6th
                continuous
                Go To feature
                in tables
                non-contiguous
                with keyboard 2nd
        elements (charts)
        Selection and Visibility pane
        selection modes
        shapes
Send to Back command
serial numbers 2nd
        charting
series 2nd 3rd
SERIESSUM() function
server-side databases
servers
shadow effect (shapes)
shadows (charts)
shapes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
        adding text
        column (3-D charts)
        connecting
        drawing
        grouping
        styles
shaping pictures 2nd
SharePoint
        publishing documents to
sharing
        templates
sheet settings (printing)
shortcuts
        formula 2nd 3rd 4th 5th 6th 7th
        macro 2nd 3rd
        shortcut keys
Show Calculation Steps command
Show Formulas command
Show Values as tab (pivot tables)
showing/hiding
        comments
shrink to fit (text)
SIGN() function
significant digits
sites
skip blanks option (paste special)
SLN() function
SMALL() function
SmartArt 2nd 3rd
soft edges effect (shapes)
Solver 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
        configuring
        reports
        results
sorting
        by color
        sorting keys
        tables
        with custom lists
source cells
Source pane
source security (databases)
source workbooks
spaces
        removing
span with line option (empty cells)
special characters 2nd 3rd
Special number format
special pasting 2nd 3rd 4th 5th 6th 7th
spell checker 2nd 3rd 4th
spell checker and
splitting windows into panes 2nd
spreadsheets
        change tracking 2nd 3rd 4th
        collaborating on 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th
        comments 2nd 3rd 4th 5th
        converting to HTML files
        document properties 2nd
        multiple 2nd
        preparing for collaboration 2nd
        protecting
        saving
SQL Server databases
SQRTPI() function
square roots
        SQRT() function
stacked charts
        area
        column
        line
standalone charts 2nd
stars
start tags (XML)
static ranges
statistical functions 2nd 3rd 4th
statistics (document)
status bar 2nd 3rd
        configuring
STDEV() function
STDEVP() function
stickiness
stock charts
Stop If True option (conditional formatting)
straight-line depreciation
string codes 2nd 3rd 4th 5th 6th 7th
        date and time 2nd 3rd
        number 2nd 3rd 4th
        text
string literals
structured tables
styles 2nd 3rd 4th 5th 6th 7th 8th 9th
        border
        chart 2nd
        line
        modifying
        picture
        shape
        table
        themes 2nd 3rd 4th
sub-expressions (formulas)
subgrouping 2nd
subroutines
SUBSTITUTE() function
SUBTOTAL() function 2nd 3rd
subtypes
Sum indicator (status bar) 2nd
SUM() function 2nd 3rd
sum-of- years -digits depreciation method
SUMIF() function 2nd
SUMIFS() function
Summarize by tab (pivot tables)
summarizing data
summary reports (scenarios)
summary tables 2nd 3rd
summing
        AutoSum
surface charts
Switch Windows list
SYD() function
symbols (text) 2nd
syntax
        VBA
system tray