Excel 2007 Core-Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets.

Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets.

Excel 2007 Core

Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets.

A brief summary

Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners. By sharing a spreadsheet using Office Excel 2007 and Excel Services, you can navigate, sort, filter, input parameters.

Instructor:

Priti

What you will learn

Creating and Manipulating Data 
Creating and Modifying Formulas 
Presenting Data Visually Create and format charts. 
Collaborating on and Securing 

Course Fee: Rs. 999.99

Certification By: Microsoft

Creating and Manipulating Data

Introduction to Excel 2007, Insert Data using Autofill, Data Integrity, Modify Cell Content and Formats, Change Worksheet Views, Manage Worksheets

Formatting Data and Content

Format Worksheets, Insert and Modify Rows and Columns, Format Cells and Cell Contents, Format Data as a Table

Creating and Modifying Formulas

Parts of Formula, Reference Data in Formulas, Summarize Data using Formulas, Summarize Data using Subtotals, Conditionally Summarize Data, Lookup Data by using formula, Use Conditional Logic in a Formula, Format or Modify Text using Formula, Display and Print Formulas

Presenting Data Visually

Create and Format Chart, Modify Chart, Apply Conditional Formatting, Insert and modify illustrations, Sort and Filter Data

Collaborating and Securing Data

Protect and Share Workbooks, Prepare Workbooks for Distribution, Save Workbook, Set Print Options for Printing Data, Worksheets and Workbooks

Back to top