Excel Lesson – Index

These are the content of excel lesson I plan to cover in my blog. Keep an eye out for these!

1. Format:

2. Sort and Filter: 

• Filter
• Sort
• Default sort

3. Manipulating Data:

• Combining data
• Splitting data
• Conditional formatting

4. Mathematical Calculation:

5. VLookUp:

• Search field example
• Search table example

5. Pivot Table:

6. Charts and graphs:

• Selecting graphs
• Switch Row/Column
• Chart Layout
• Edit names of series
• Reverse axis order
• Edit axis
• Edit grid lines
• Suppress 0 value

7. Dashboard and Counting:

8. More IF functions: