Worksheet basics. Creating your first spreadsheet ; Adding information to worksheets ; Moving data ; Managing worksheets ; Formatting cells ; Smart formatting tricks ; Viewing and printing worksheets -- Formulas and functions. Building basic formulas ; Math and statistical functions ; Financial functions ; Manipulating dates, times, and text ; Lookup, reference, and information functions ; Advanced formula writing and troubleshooting -- Organizing worksheets. Tables : list management made easy ; Grouping and outlining data ; Templates -- Charts and graphics. Creating basic charts ; Formatting and perfecting charts ; Inserting graphics ; Visualizing your data -- Sharing data with the rest of the world. Protecting your workbooks ; Worksheet collaboration ; Using Excel on the web ; Exchanging data with other programs -- Advanced data analysis. Scenarios and goal seeking ; Pivot tables ; Analyzing databases ; Analyzing XML and web data -- Programming Excel. Automating tasks with macros ; Programming spreadsheets with VBA -- Appendix. Customizing the ribbon.
|
