MicroSoft Excel Basics

Have Queries? Ask us +91 72592 22234

Course Overview


Students will create, edit, format and print basic worksheets and charts in Excel.To effectively understand MicroSoft Excel course, we recommend that you take an Microsoft Office Windows XP Introduction course or have equivalent knowledge.

Course Content


EXPLORING THE EXCEL ENVIRONMENT

  • Exploring the User Interface
  • Explore the ribbon
  • Obtain Help
  • Customise the quick access toolbar

WORKING WITH AN EXCEL WORKSHEET

  • Navigate in Excel
  • Select and Enter Data
  • Save a workbook

MODIFYING A WORKSHEET

  • Manipulate Data
  • Insert and Delete Cells, Columns and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

PERFORMING CALCULATIONS

  • Create Basic Formulae
  • Calculate with Functions
  • Compare Formula with Functions
  • Create a Mixed Reference

FORMATTING A WORKSHEET

  • Convert Text to Columns
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Align Cell Contents
  • Find and Replace Formats
  • Apply Auto Format
  • Apply Cell Styles
  • Apply Themes

DEVELOPING A WORKBOOK

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook

INSERT and DELETE Worksheets

  • Copy and Paste Worksheets
  • Function point analysis
  • COCOMO model
  • Agile Estimation

PRINTING WORKBOOK CONTENTS

  • Set Print Titles
  • Create a Header and a Footer
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

CUSTOMIZING LAYOUT

  • Split a Worksheet
  • Arrange Windows
  • Freeze and Unfreeze Rows and Columns
  • Hide and Unhide worksheets   

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234