Unique Visitor

Flag Counter

বৃহস্পতিবার, ৮ নভেম্বর, ২০১২

Excel Lession Advance Level

Click Here To Read The Manual(Excel)

Contents:

 1.           Simple file handling.
               a)         Navigate to drives and folders
               b)         Organise files
               c)         Create, copy, move, rename, find, files and folders.

2.           Using Worksheets
               a)         Rename, delete,  insert, change order.
3.           Cell
               a)         Copy, paste, drag and drop
               b)         Create a Series
               c)         Alter cell width and height
4.           Formatting
               a)         Wrap, Centre across selection, shade, border, change font attributes
               b)         Number formatting – number of decimal places, currency
5.           Formulas
               a)         Order of operations (BEDMAS) and use of operators + - / * ^ ()
               b)         Use of functions, SUM, MAX, MIN, AVERAGE, COUNT, COUNTA
               c)         Use of % sign
               d)         Relative and Absolute cell references
6.           Graphing – simple pie, bar and column graphs.
7.           Apply Data Integrity Practices
               a)         comparison with original information sources
               b)         audited formulae
               c)         check-totals.

Click Here To Read The Manual(Excel)

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন