PM PULSE Logo  [home] [contact]
 
  CONTACT
Cell # +91 9902070483
e-mail: sujala@pmpulse.net
 
The Pulse of Project Management          
Home About Consulting Training Events Mentoring Resources PM Pulse Buddies
 
IT Thumb Introduction To MS Excel – White Belt    
Training   Home >>Training >> Tools & Techniques >> Introduction To MS Excel – White Belt    

 

Introduction to Excel
…Effective way to work with spreadsheets


Prerequisite

A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Excel is required.


Course Level

Foundational


Duration

1 Day


Who should attend?

Working professionals from any function, currently working Windows-based PCs and wish to use MS Excel


Performance Focus

At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work environments. Spreadsheets that you create will be easier to use and look more presentable.


Content

Basic outline of the course:

Getting Started
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks


Entering and editing data
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks


Modifying a Worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges
Using Functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Formatting Worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Printing
Preparing to print
Page Setup options
Printing worksheets

Creating Charts
Chart basics
Modifying charts
Printing charts


Recap & Closing
 

Email at
sujala@pmpulse.net
or
Call +91 9902070483
to book this course
   
       
                     

 

about | contact | sitemap | privacy
Copyright © 2010 PM Pulse. All rights reserved.