Basic Microsoft Excel Training Program

 

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

Click Here for Registration

Leave a Reply

Your email address will not be published. Required fields are marked *