Duration: Until all Topics are not Covered
Course Topic:
1. Formatting a Worksheet
Creating Headers, Footers, and Page Numbers
Adjusting Page Margins and Orientation
Adding Print Titles and Gridlines, rows to repeat at top of each page
Formatting Fonts & Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colors and Patterns
Using the Format Painter
Merging Cells, Rotating Text
2. Managing your workbooks
Inserting and Deleting Worksheets
Protecting a Workbook
Hiding Columns, Rows and Sheets
Splitting and Freezing a Window
Entering Date Values and using AutoComplete
Inserting Cell Comments
3. Formulas & Filtering:
Creating a basic Formula
Calculating Value Totals with AutoSum
Editing & Copying Formulas
Sorting, Subtotaling & Filtering Data
4. Creating & Working with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a Chart
Changing a Chart’s Source Data
Changing a Chart Type and Working with Pie Charts
N:B: Topics can be add, deduct or modify as and when required.
Prepared by:
Md. Tahamidur Rahman
Admin, Excel-Bangla