bdjobs.com :: Largest Job Site in Bangladesh

Microsoft Excel 2007 Professional
(For Professional and Business Use)

About Workshop

Microsoft Excel 2007 is the latest version of Microsoft's famous spreadsheet application. It is one of the most powerful and widely used spreadsheet applications available today. Excel's functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world.

Microsoft Excel 2007 is the latest version of Microsoft's famous spreadsheet application. It is one of the most powerful and widely used spreadsheet applications available today. Excel's functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world.

Excel 2007 provides a wealth of financial, mathematical, and statistical functions that you can apply to your data. Excel 2007 also offers numerous formatting and presentation options that will help you create slick, professional looking reports. You can use Excel as a database, a graphing and charting tool, a means of evaluating complex formulas, and as a way of sharing data and collaborating with others. When you change data in an Excel spreadsheet, Excel will recalculate your totals, functions, and formulas accordingly.

Excel 2007 is comprehensive enough to meet the needs of beginners and experienced users alike. With Excel you can perform a wide range of tasks, from building basic spread sheets to performing advanced data analysis. Excel can help you process, interpret, and extract meaningful conclusions from your information.

Workshop topics to be covered:

What's New in Excel 2007

• New User Interface and Ribbon

• New Features introduced

• Extended capabilities over Excel 2003

Setting up a Workbook

• Creating Workbooks

• Saving Workbooks

• Modifying Worksheets and Workbooks

• Customizing the Excel 2007 Program Window

Working with Data and Data Tables

• Entering and Revising Data

• Moving Data Within a Workbook

• Finding and Replacing Data

• Correcting and Expanding Upon Worksheet Data

• Defining a Table

Performing Calculations on Data

• Naming Groups of Data

• Creating Formulas to Calculate Values

• Summarizing Data That Meets Specific Conditions

• Finding and Correcting Errors in Calculations

Changing Document Appearance

• Formatting Cells

• Defining Styles

• Applying Workbook Themes and Table Styles

• Making Numbers Easier to Read

• Changing the Appearance of Data Based on Its Value

• Adding Images to a Document

Focusing on Specific Data Using Filters

• Limiting Data That Appears on Your Screen

• Manipulating List Data

• Defining Valid Sets of Values for Ranges of Cells

Reordering and Summarizing Data

• Sorting Data Lists

• Organizing Data into Levels

• Looking Up Information in a Data List

Combining Data from Multiple Sources

• Using Data Lists as Templates for Other Lists

• Linking to Data in Other Worksheets and Workbooks

• Consolidating Multiple Sets of Data into a Single Workbook

• Grouping Multiple Sets of Data

Creating Dynamic Lists with PivotTables

• Analyzing Data Dynamically with PivotTables

• Filtering, Showing, and Hiding PivotTable Data

• Editing PivotTables

• Formatting PivotTables

• Creating PivotTables from External Data

Creating Charts and Graphics

• Creating Charts

• Customizing the Appearance of Charts

• Finding Trends in Your Data

• Creating Dynamic Charts Using PivotCharts

• Creating Diagrams by Using SmartArt

Printing

• Adding Headers and Footers to Printed Pages

• Preparing Worksheets for Printing

• Printing Data Lists

• Printing Parts of Data Lists

• Printing Charts

Automating Repetitive Tasks with Macros

• Introducing Macros

• Recording and Modifying Macros

Working with Other Microsoft Office Programs

• Importing from and exporting to other office programs

• Creating Hyperlinks

• Pasting Charts into Other Documents

Collaborating with Colleagues

• Sharing Data Lists

• Managing Comments

• Tracking and Managing Colleagues' Changes

• Protecting Workbooks and Worksheets

Back to Workshop Home