Excel Documentation - Free reading
Standard tables (simple and printed on one page) and slightly more complex tables
- Basic commands linked to navigating, selecting, typing ...
- Structure of the table (row or column width/height - delete - insert)
- Formats
- Cut-copy-paste : excel specific implications
- Formules et fonctions simples
- Formulas and easy functions
- Page setup and print options - Managing worksheets and files
- Large tables : page setup and print options
- Data formats (custom - conditional ...)
- Formulas and functions (absolute references - names))
- Navigate - Reorganize - Compare
- Charts (simple intro)
- Sort and Filter (simple intro)
- Workbook and cell protection (simple)/li>
Charts and graphic tools
- Creating and choosing the chart typ
- DESIGN Tab
- LAYOUT Tab
- FORMAT Tab
- Creating a chart template
- Samples of less common charts
- Drawn shapes and SmartArt
Data Tables (Lists)
- Convert into a list
- Managing duplicates
- The TRIM and CONCATENATE functions
- Outline Mode
- Data validation
- Tips to select and navigate in a very large worksheet
- Defining a list as a data table
- Sorting
- Filtering : simple and advanced
- Subtotals - integrated inside the table
- Pivot tables
- BD functions
Functions and Protection - Analysis tools
- Absolute and relative references
- Functions : general principles
- NomNamess
- Examples of functions : COUNT, COUNTBLANK, COUNTIF - SUMIF - AND, OR - VLOOKUP (H) - INDEX, MATCH, EXACT, SUBTOTAL and so on
- Audit
- Conditional formats
- Protection
- Analysis tools : custom views - scenarios - simple & double entry table - Goal seek
Customize and Automate>
Customize
- The types of templates
- The other files linked to customization
- Customizing the Quick Access Toolbar
Automate
- Introduction to macro-instructions : create, modify ...
- Macro settings (security)
- Custom button for a macro
- Forms
- Special functions : converting to PDF format