Notes for class X on EXCEL

Click here

CONTENTS
Unit 4: Spreadsheet (Intermediate)
NAME OF THE TOPIC	PAGE NO IN BOOK
SESSION 1: USE AUTOSUM IN CELLS	150
SESSION 2: CONDITIONAL FORMATTING	152
SESSION 3: HIDE / UNHIDE / FREEZE ROWS AND COLUMNS	156
SESSION 4: SET PAGE BREAKS	158
SESSION 5: SET PAGE LAYOUT	161
SESSION 6: MANAGE WORKBOOK VIEWS	163
SESSION 7: APPLY CELL AND RANGE NAMES	165
SESSION 8: CREATE MODIFY AND FORMAT CHARTS	168
SESSION 9: SORT AND FILTER DATA	171
SESSION 10: CALCULATE DATA ACROSS WORKSHEETS	175
SESSION 11: USING MULTIPLE WORKBOOKS AND LINKING CELLS	177
SESSION 12: SHARING WORKSHEET DATA	179