ERIVAN Services

Table of content

1. Basic knowledge
   1.1. Text
   1.2. Formatting texts
   1.3. Alignments, merging, colors
   1.4. Moving and copying contents
   1.5. Saving and printing

2. Tables

2.1. Table borders
2.2. Types of tables
2.3. Pivot tables

3. Size and formatting

3.1. Cell size and formatting

4. Mouse pointer shapes

5. Inserting objects
   5.1. Shape 5.2. WordArt and images
   5.3. SmartArt

6. Operations, functions and basic computation

6.1. Formula calculations and functions
6.2. IF Function and copying formulas
6.3. Comparison operators

7. AutoFill Series

7.1. AutoFill number and text

7.2. AutoFill calculations and functions .

7.3. IF function, AutoFill of formulas

8. Cell Reference

8.1. Relative cell reference

8.2. Name a cell or a range of cells

8.3. Absolute and mixed cell references

8.4. Cell reference in different sheets

9. Graphs
   9.1. Inserting graphs
   9.2. Inserting Sparkline graphs

10. Conditional formatting

10.1. Conditional formatting (I)
10.2. Conditional formatting (II)
10.3. Conditional formatting (III)
10.4. Conditional formatting (IV)
10.5. Conditional formatting (V)

11. Supplements
    11.1. Page Layout
    11.2. Drop-down list
    11.3. Multiple drop-down lists and data validation

12. Using a database

12.1. Inserting data

13. Astuces

13.1. Calculation

13.1.1. Round

13.2. Cell and sheets

13.2.1. Keep the same cell reference when auto filling

13.2.2. Start a new line in a cell

13.2.3. Freeze rows and columns in Excel

13.3. Dates and hours

13.3.1. Calculate the remaining days before a date

13.4. Divers
13.4.1. Save an Excel Sheet as PDF
13.4.2. List all external links in a workbook

13.5. Errors

13.5.1. List of errors Excel (#NAME?, #DIV/0!, #N/A, #VALUE!, #REF!, #NUM!...)

13.6. Text

13.6.1. Concatenate text and values

14. Operations, functions and advanced formulas
    14.1. IF function
    14.2. COUNTIF and COUNTIFS functions
    14.3. VLOOKUP
    14.4. Logical functions “AND” and “OR”