It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life

Easy Excel for Beginner to Advance

This training program is jointly organized by BITM & People NTech Limited

 

After the successful completion of the Easy Excel for Beginner to Advance Training program, students will be able to:

 

ü  Identify the different components of the Excel worksheet.

ü  Differentiate between an Excel workbook & worksheet.

ü  Use the Office Assistant

ü  Open an existing workbook and create a new workbook

ü  Enter text and formulas in to an Excel spreadsheet

ü  Enhance alpha and numeric data in an Excel Worksheet

ü  Move & Copy alpha and numeric data

ü  Construct formulas to manipulate numeric data in an Excel Worksheet

ü  Create a spreadsheet to tabulate and record numeric values

ü  Change the appearance of an Excel spreadsheet

ü  Use the print function to create a printable copy of data stored on an Excel spreadsheet.

ü  Set up the chart function of Excel to represent numeric data in multiple formats.

ü  Differentiate between formulas and functions in Excel.

ü  Perform various formulas and functions in Excel.

 

Training will be held in People NTech Limited's premises.

FEE - Tk 6000

Prerequisite

Who have the idea about basic computer system?

Project Oriented Course

One will practically learn all mentioned tools and techniques by completing assignments.

Course Outline

Chapter 1: Office Workspace Basics

  • Basic Window Elements
  • Exploring Microsoft Office Backstage
  • Working with the Ribbon
  • Customizing the Quick Access Toolbar
  • Working with Key Tips
  • Using the Status Bar
  • Getting Help

 

Chapter 2: Introduction to Excel

  • What is Excel?
  • Getting to Know the Excel Window
  • Moving the Cell Selector
  • Opening a Workbook
  • Navigating a Workbook
  • Selecting Cells
  • Creating Workbooks
  • Saving a Workbook
  • Closing a Workbook

 

Chapter 3: Entering and Editing Data

  • Entering Text, Numbers, and Data
  • Editing Data
  • Using AutoComplete and AutoFill
  • Copying Data
  • Moving and Clearing Data
  • Using Undo and Redo
  • Finding and Replacing Data

 

Chapter 4: Introduction to Formulas and Functions

  • What are Formulas and Functions?
  • Entering Formulas
  • Entering Functions
  • Using the Insert Function Tool
  • Using AutoSum
  • Copying and Moving Formulas

 

Chapter 5: Working with Functions

  • Using Statistical Functions
  • Using Financial Functions
  • Testing Conditions with IF
  • Using Date and Time Functions
  • Using Linked Values in Formulas
  • Copying Formula Values

 

Chapter 6: Formatting Data

  • Introduction to Formatting
  • Applying Number Formats
  • Applying Font Formats
  • Changing Cell Alignment
  • Applying Cell Styles
  • Copying Formats
  • Clearing Formats
  • Finding and Replacing Formats

 

Chapter 7: Formatting Worksheets

  • Inserting and Deleting Rows and Columns
  • Inserting and Deleting Cells
  • Adjusting Column and Row Sizes
  • Hiding Worksheet Components
  • Inserting and Deleting Worksheets
  • Copying and Moving Worksheets
  • Customizing Sheet Tabs
  • Adding a Worksheet Background

 

Chapter 8: Adding Charts and Graphics

  • Creating a Chart
  • Enhancing a Chart
  • Modifying Chart Data
  • Changing Chart Types
  • Drawing Shapes
  • Inserting Pictures
  • Creating SmartArt

 

Chapter 9: Viewing and Printing Workbooks

  • Changing View Options
  • Splitting and Freezing a Worksheet
  • Sorting and Filtering Data Info about Slicers
  • Customizing the Page Layout
  • Adding Headers and Footers
  • Modifying Page Breaks
  • Previewing and Printing the Worksheet
  • Printing Selected Data

 

Chapter 10: Managing Workbooks

  • Arranging Multiple Workbooks
  • Adding Hyperlinks
  • Working with Comments
  • Saving Workbooks in Different Formats
  • Saving a Workbook as a Web Pages
  • E-Mailing a Workbook

Used Tools

Ms Office Enterprise.

COURSE SUMMARY

Course Duration : 12 Days
Total Hour : 32 Hours
Number of Batch : 1 Batch

Application Last Date : 28 April, 2017

Class Schedule

Day & Time : Friday 9:00 am - 12:00 pm
: Saturday 9:00 am - 12:00 pm
Duration : 3 hours per class

Project:

This will be discussed during the session


Certificate:

Certificate will be provided after the completion of the course.