Microsoft Excel 2010 – Starter Level

Introduction

Getting Started with Microsoft Excel 2010

The topics covered in this course provide the learner with the skills and knowledge necessary to create workbooks in Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting.

Learning outcomes
At the completion of this course, participants will be able to:
Work within the basic Excel environment
Create, open and navigate within workbooks and worksheets
Make changes to data in a workbook
Understand, create and work with formulas and functions used to perform calculations
Understand and use formula cell referencing to create more complex formulas
Understand and work with ranges in a worksheet
Copy and paste data in Excel
Use font formatting techniques to greatly enhance the look of a worksheet
Align the contents of cells in a number of ways
Format rows and columns in a worksheet
Understand and use the number formatting features in Excel
Print your workbook data
Create effective charts in Microsoft Excel

Prerequisites
This course assumes no prior knowledge of Microsoft Excel 2007. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.

Methodology

The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:

Getting To Know Excel
● Starting Excel; ● The Excel Screen; ●Using The Ribbon; ●Using Key Tip Badges; ●Minimising The Ribbon; ● Using Shortcut Menus; ● Launching Dialog Boxes; ● Customizing The Quick Access Toolbar; ●The Office Button; ●Using The Office Button; ●The Status Bar; ● Customizing The Status Bar.

Start Working with Workbooks
●Understanding Workbooks; ●Using The Blank Workbook Template; ● Typing Text Into A Worksheet; ● The Save As Dialog Box; ●Saving A New Workbook; ●Typing Numbers Into A Worksheet; ●Typing Simple Formulas In A Worksheet; ●Easy Formulas; ●Typing Dates In A Worksheet; ● Easy Formatting; ● Checking Spelling In A Worksheet; ●Making And Saving Changes; ● Printing a Worksheet; ●Safely Closing a Workbook

Working With Workbooks
● Opening An Existing Workbook ● Moving About A Worksheet ● Moving About A Workbook ● Going To A Specific Location● The Open Dialog Box

Editing In A Workbook
●UnderstandingDataEditing●OverwritingCellsContents●EditingLongerCellEntries●EditingFormulas ●Editing Functions ●Clearing A Cell ●Deleting In A Worksheet ●Undoing And Redoing Operations

Formulas And Functions
● Understanding Formulas ● Creating Formulas That Add ● Creating Formulas That Subtract ● Formulas That Multiply And Divide ● Understanding Functions ● Using The SUM Function To Add ● Summing Non-Contiguous Ranges ● Calculating An Average ● Finding A Maximum Value ● Finding A Minimum Value ● More Complex Formulas ● What If Formulas

Formula Referencing
● Absolute Versus Relative Referencing ● Relative Formulas ● Problems With Relative Formulas ● Creating Absolute References ● Creating Mixed References Selecting Ranges ● Understanding Ranges ● Selecting Ranges ● Selecting Non-Contiguous Ranges ● Using Special Selection Techniques ● Selecting Larger Ranges ● Selecting Rows ● Selecting Columns ● Viewing Range Calculations ● Creating An Input Range

Copying Excel Data
● Understanding Copying In Excel ● Using Fill For Quick Copying ● Copying From Cell To Another ● Copying From One Cell To A Range ● Copying From One Range To Another ● Copying Relative Formulas ● Copying To A Non-Contiguous Range ● Copying To Another Worksheet ● Copying To Another Workbook

Font Formatting
● Understanding Font Formatting ● Working With Live Preview ● Changing Fonts ● Changing Font Size ● Growing And Shrinking Fonts ● Making Cells Bold ● Italicising Text ● Underlining Text ● Changing Font Colours ● Changing Background Colors ● Using The Format Painter ● Applying Strikethrough ● Subscripting Text ● Superscripting Text

Cell Alignment
● Understanding Cell Alignment ● Aligning Right ● Aligning To The Centre ● Aligning Left ● Aligning Top ● Aligning Bottom ● Aligning To The Middle ● Rotating Text ● Indenting Cells ● Wrapping And Merging Text ● Merging And Centering ● Merging Cells ● Unmerging Cells

Row And Column Formatting
● Approximating Column Widths ● Setting Precise Column Widths ● Setting The Default Column Width ● Approximating Row Height ● Setting Precise Row Heights ● Hiding Rows And Columns ● Unhiding Rows And Columns

Number Formatting
● Understanding Number Formatting ● Applying General Formatting ● Formatting As Currency ● Formatting Percentages ● Formatting As Fractions ● Formatting As Dates ● Using The Thousands Separator ● Increasing And Decreasing Decimals Printing ● Understanding Printing ● Previewing Before You Print ● Performing A Quick Print ● Selecting A Printer ● Printing A Range ● Printing An Entire Workbook ● Specifying The Number Of Copies ● The Print Dialog Box

Creating Charts
● Understanding The Charting Process ● Choosing The Chart Type ● Creating A New Chart ● Working With An Embedded Chart ● Resizing A Chart ● Dragging A Chart ● Printing An Embedded Chart ● Creating A Chart Sheet ● Changing The Chart Type ● Changing The Chart Layout ● Changing The Chart Style ● Printing A Chart Sheet ● Embedding A Chart Into A Worksheet ● Deleting A Chart

Related Courses

Muhammad Arif-ur-Rahman
  • 24 - 25 Feb 2017 (2 Days Long)

Advanced Microsoft Excel 2007 & 2010 course to develop ...

IT
Price 3,000 Tk + VAT
Moshiur Rahman
  • Saturday, February 25, 2017

Advertising on Facebook is easy for you and your customers. ...

IT
Moshiur Rahman
  • 26 Feb - 6 Apr 2017

This course will help you to know how to promote your ...

IT
Samiul Huq
  • 28 Feb - 9 Mar 2017

This course will walk you through the world of business ...

IT

Contact

9140345, 9117179

workshop@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

This course is primarily designed for people who need to know how to use Microsoft Excel 2010. It is designed for beginner users who have little or no understanding, knowledge of, or experience in using Microsoft Excel.