TRAINING ON MICRSOFT EXCEL 2007

Download
Share  Add to  Flag Embed
Views:
 
Category: Entertainment
     
 
License:   All Rights Reserved

Presentation Description

No description available.

Comments

Presentation Transcript

Slide 1:

1 INHOUSE TRAINING ON EXCEL FROM– NIIT [TILAK ROAD CENTER]

Slide 2:

2 TRAINING FOR MICROSOFT EXCEL 2007 By- Himanshu Mirchandani

OBJECTIVES:

OBJECTIVES To give General Awareness about Excel To understand how to use excel in day to day operations How to manipulate data using excel technique for various analysis 3

SCOPE :

SCOPE This session covers the M icrosoft Excel 2007 techniques which are useful in the organization . This session is divided into two parts theory and practical. 4

T H E O R Y ( SECTION – I ) :

T H E O R Y ( SECTION – I ) 5

CONTENTS:

CONTENTS Navigating the Excel environment Excel functions Basic formulas & common formula errors Shortcuts Filters Pivot Table Charts File Protection 6

BASIC EXCEL FUNCTIONS:

BASIC EXCEL FUNCTIONS Basic Functions Commonly used Formulae's Excel Common Formula Errors 7

SHORTCUTS TO EXCEL:

SHORTCUTS TO EXCEL SHORTCUTS 8

Slide 9:

9 Navigating in Worksheets and Selecting Cells Format Cells Function keys in Excel 2007 CTRL Combinations in Excel 2007 Smart-Art Graphics: Work with shapes Smart-Art Graphics : Work with Text Microsoft Clip Organizer main Work with the Excel Ribbon

EXCEL FILTERS:

EXCEL FILTERS 10 Filter text Filter numbers Filter dates or times Filter for top or bottom numbers Filter for above or below average numbers Filter for blanks or nonblanks Filter by cell color, font color, or icon set Filter by selection Ungroup the hierarchy of dates in the AutoFilter menu

PIVOT TABLE:

PIVOT TABLE About PivotTable reports Ways to work with a PivotTable report About PivotChart reports Differences between PivotChart reports and charts Working with PivotTable source data and PivotChart source data 12

EXCEL CHARTS:

EXCEL CHARTS Column charts Line charts Pie charts Bar charts Area charts XY (scatter) charts Stock charts Surface charts Doughnut charts Bubble charts Radar charts 12

FILE PROTECTION :

FILE PROTECTION Using passwords to help secure an entire workbook Protecting specific worksheet or workbook elements Protect worksheet elements Protect workbook elements Protect elements in a shared workbook 13

P R A C T I C A L ( SECTION – II ) :

P R A C T I C A L ( SECTION – II ) 14

PART – I :

PART – I Calculating data with advanced formulas Organizing Worksheet and Table data Presenting data using charts Analyzing Data using PivotTables and Pivot Charts Inserting graphic objects Customizing and Enhancing Workbooks and the Excel Environment 15

Calculating data with advanced formulas :

Calculating data with advanced formulas Manage Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions 16

Organizing Worksheet and Table data :

Organizing Worksheet and Table data Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate data in a Table or Worksheet 17

Presenting data using charts :

Presenting data using charts Create a chart Modify Charts Format Charts 18

Analyzing Data using PivotTables and Pivot Charts :

Analyzing Data using PivotTables and Pivot Charts Create a PivotTable Chart Analyze data using Pivot Charts 19

Inserting graphic objects :

Inserting graphic objects Insert and Modify Pictures and Clip Art Draw and Modify Shapes Illustrate Workflow using Smart Art Graphics Layer and Group Graphic Objects 20

Customizing and Enhancing Workbooks and the Excel :

Customizing and Enhancing Workbooks and the Excel Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates 21

Part – II (ADVANCED):

Part – II (ADVANCED ) Streamlining Workflow Collaborating with Others Auditing Worksheets Analyzing Data Working with multiple Workbooks Importing and Exporting Data Using Excel with Web 22

Streamlining Workflow :

Streamlining Workflow Create a macro Edit a macro Apply conditional formatting Add data validation criteria Update a Workbook’s Properties Modify Excel’s Default Settings 23

Collaborating with Others :

Collaborating with Others Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access 24

Auditing Worksheet:

Auditing Worksheet Trace Cells Troubleshoot errors in Formulas Troubleshoot Invalid Data in Formulas Watch and Evaluate a Formula Create a Data List Outline 25

Analyzing Data:

Analyzing Data Create a Trend Line Create Scenarios Perform What-if-Analysis Perform Statistical Analysis with the Analysis Toolpak 26

Working with multiple workbooks :

Working with multiple workbooks Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit Links 27

Importing and Exporting Data:

Importing and Exporting Data Export Excel Data Import a Delimited Text File 28

Using Excel with Web:

Using Excel with Web Publish a worksheet to Web Import Data from the Web Create a Web Query 29

THANK YOU:

THANK YOU 30