List of topics covered in our final exam

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
4. Combo Charts / Combining line and column charts
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
6. Print cheques
7. Find average / SD/ CV for each company
8. Format Tables
9. Copy data from one sheet to another
10. Clear the data
11. For loops
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


Excel Solver
1. Setting constraints
2. Objective cell
3. Changing cells

Comments