List of topics covered in our final exam
CONDITIONAL FORMATTING
1. Text based formatting
2. Formula based formatting
3. Formatting only numbers
4. Formatting only formulas
5. Formatting only text
FILTERING DATA
Pivot Tables
1. Rows
2. Columns
3. Filters
4. Values
5. Average, sum, min, max, etc
6. Pivot Charts
Charts and Graphs
1. Bar charts
2. Line Charts
3. Scatter
5. Pie
6. Chart layout / Designs
7. Changing chart axis names, titles, shape, colors
Vlookup
1. Named ranges
2. Modifying a named range
3. Single criteria lookup
4. Multiple criteria lookup
List of Macros
1. Change cells
2. Change sheets
3. Add a specific value to a cell existing value
4. Delete / color every n column
5. Delete /color every n row
7. Find average / SD/
8. Format Tables
9. Copy data from one sheet to another
10. Clear the data
12. Save file as Macro-Enabled Workbook
Print Excel Data
1. Set print area
2. Modify print area
3. Print row titles
4. Landscape / Portrait
5. Setting margins
6. Setting page breaks
7. Page numbers
8. Print only selected text
9 Change Print Area by hold and drag
10. Print Header and Footer
11 Print only pages 10 to 15
12. Custome scaling
13 Margins
14. Orientation
15. Page numbers
16. Page breaks
17. Page size
18. Freeze rows / Columns
19. Header / Footer
20. Print IMSCiences logo in light color in the background